Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to create filtered measure in universes mapped to infocubes?

Hi all,

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

Stefano

Former Member
Former Member replied

Hi,

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].[2000])</EXPRESSION>

In that case it will work perfectly.

Regards

Didier

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question