Skip to Content
author's profile photo Former Member
Former Member

Restricted measure in sap olap universe

Hi,

I am trying to create a restricted measure in sap olap universe with Orders key figure restricted on 0PLANT and 0MATERIAL objects.i want to restrict on list of 0PLANT (1000,1200,2000) and 0MATERIAL (DPC1009,DPC1010).

I used <EXPRESSION>@Select(Keyfigures\Orders)</EXPRESSION> in select clause,

and restriction on list of values in where clause as below.

<FILTER KEY="[0MATERIAL].[LEVEL01]">

<CONDITION OPERATORCONDITION="InList">

<CONSTANT CAPTION="DPC1009"/>

<CONSTANT CAPTION="DPC1010"/>

</CONDITION>

</FILTER>

but when i used orders restricted measure, report returned no data,actually there is data for this restriction.

can anybody tell me where is this mistake in the above syntax and also how can i add 0PLANT restriction to this syntax.

Thanks,

Harsha

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    Posted on Aug 11, 2010 at 03:59 PM

    Hi,

    In Select clause, write:

    @Select(Key Figures\Orders) ]]>

    In Where clause, write:

       
         
           
           
         
       
       
         
           
           
           
         
       
    
    ]]>

    Regards

    Add comment
    10|10000 characters needed characters exceeded