olap universe lov restriction on detail object key

[former_member206223]

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

[IngoH · Accepted solution]

Hi,

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

Ingo

[former_member206223 · Accepted solution]

Thanks Ingo,

I will make use of RKF functionality of BEx.

Regards,

Harsha