Creating Restricted Key Figures in Relational Universe (UNX Universe, Information Design Tool)

[Former Member]

We are creating a relational universe on top of BW using Information Design Tool and not creating reports on top of existing BEX Queries. I am guessing Simple restricted key figures can be created as measures in universe by using case statements (or if statements) but did not find any workaround for complex Restricted Key Figures (which restrict by infoproviders, etc). Is there any workaround for handling complex Restricted Key Figures.

[former_member184594]

If you are using Federated BW universes, your restricted key figures are gone. You are no longer able to use the functionality. Instead you should try creating by using case statements and where statements to create restricted key fiugres in the universe.

[former_member201183]

Hi,

Please try using the Select and Where clauses for restricting the Key Figures..

Thanks and Regards,

Rupali