Skip to Content
avatar image
Former Member

olap universe lov restriction on detail object key

Hi,

I created a restriction on dimension lov in SAP olap universe using 0PLANT dimension on Orders keyfigure as below

<EXPRESSION>(@Select(Key Figures\Orders),[0PLANT].[1000])</EXPRESSION> 

this syntax works but webi results are not matching with BEx.

Values of BEx RKF and formula object (

=[Orders] Where([L01 Plant] = "1000") 

)created in webi are matching.

I am trying to create restriction on detail key object, like

<EXPRESSION>(@Select(Key Figures\Orders),[0PLANT].[LEVEL01].[[20PLANT]].[Value].[1000])</EXPRESSION> 

above measure is giving error when i run the webi query.

here both L01 Plant and L01 Plant Key are having same lov as 1000,but i wanted check exact values with detail key syntax.

Can anyone please tell me the syntax for using detail objects keys for restriction in Select Clause.

Thanks,

Harsha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 03, 2010 at 09:41 PM

    Hi,

    why are you not creating this as a restricted key figure in the underlying BEx Query ?

    Ingo

    Add comment
    10|10000 characters needed characters exceeded