How to create filtered measure in universes mapped to infocubes?
i need some help to create a filtered measure at universe level with BO Designer.
For example i have a key figure named ZSTKQTY and i want to filter it only for certain values of the dimension [ZDDT].[LEVEL01].[NAME]
What is the correct syntax to do this?
I mean, i create a new object but what i have to put between <EXPRESSION></EXPRESSION> ?
I did not find any document that could really help me...does anybody here know how to do this?
I tried this (and something similar):
<EXPRESSION>@Select(Key Figures\Stock), [ZDDT].[LEVEL01].[NAME].[valueToFilter]</EXPRESSION>
Thanks for the help
Didier MAZOUE replied
This RKF works only if you retrieve PLANT members in your query whatever the addional dimensions you have in your query.
But if you don't want to use PLANT in the query but always have an RKF based on plant value then the syntax is the first one I suggested:
<EXPRESSION>(@Select(Key Figures\Amount), [0PLANT].)</EXPRESSION>
In that case it will work perfectly.