Skip to Content
0
Former Member
Oct 26, 2010 at 12:34 AM

OLAP Universe Filter for Constant

18 Views

Hello

I am trying to create a universe filter. We have a BO OLAP Universe on top of MSAS 2008. We are at BOXI 3.1 SP2/FP2.2

<FILTER KEY="[Date].[Calendar Date].[Date]"><CONDITION
OPERATORCONDITION="InList"><CONSTANT
CAPTION="[Today].item(0).MEMBER_CAPTION"/></CONDITION></FILTER>

Where [Today] is a calculated member.

This one parses fine, however when it comes to MDX which i capture via

profiler


WITH SET NS28B9BE741FD446A5A0414EA718F8FC_0 AS Filter([Date].[Calendar
Date].levels(4).allmembers,((([Date].[Calendar
Date].currentmember.properties("CAPTION")="[Today].item
(0).MEMBER_CAPTION"))))


SELECT { [Measures].DefaultMember } ON COLUMNS ,
NS28B9BE741FD446A5A0414EA718F8FC_0 DIMENSION PROPERTIES
MEMBER_UNIQUE_NAME, MEMBER_CAPTION ON ROWS FROM [My Cube]

This returns empty. However it works fine and returns value if i remove "" wrapping

[Today].item(0).MEMBER_CAPTION and run this query in SQL Server Management Studio ( MDX query)

However i cannot introduce the same in the filter - if i try it gives

me a parse error.

i.e the following doesnt help

<FILTER KEY="[Date].[Calendar Date].[Date]"><CONDITION
OPERATORCONDITION="InList"><CONSTANT
CAPTION=[Today].item(0).MEMBER_CAPTION/></CONDITION></FILTER>

Can you kindly advise if you have seen similar errors and what i can do possibly in this case to workaround this?

Edited by: ramaks on Oct 26, 2010 2:35 AM

Edited by: ramaks on Oct 26, 2010 2:36 AM

Edited by: ramaks on Oct 26, 2010 2:37 AM