Skip to Content
avatar image
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

  • Follow
  • Get RSS Feed

1 Answer

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

    Hi,

    In Select clause, write:

    <EXPRESSION>@Select(Key Figures\Orders)</EXPRESSION> 

    In Where clause, write:

    <OPERATOR VALUE="AND">
      <FILTER KEY="[0MATERIAL].[LEVEL01]"> 
        <CONDITION OPERATORCONDITION="InList"> 
          <CONSTANT CAPTION="DPC1009"/> 
          <CONSTANT CAPTION="DPC1010"/> 
        </CONDITION> 
      </FILTER> 
      <FILTER KEY="[0PLANT].[LEVEL01]"> 
        <CONDITION OPERATORCONDITION="InList"> 
          <CONSTANT CAPTION="1000"/> 
          <CONSTANT CAPTION="1200"/> 
          <CONSTANT CAPTION="2000"/> 
        </CONDITION> 
      </FILTER> 
    </OPERATOR>
    

    Regards

    Add comment
    10|10000 characters needed characters exceeded