Skip to Content
0
Former Member
Aug 16, 2012 at 09:30 PM

Condition in OLAP Universe (Analysis Services 2008)

22 Views

Hi,

We have an OLAP Universe connected to Analysis Services 2008.
We would like to create a condition to use it as a filter to the reports in WebIntelligence.
I have tried a lot of things but i couldnt solve it.

We want to filter the report with the last child of a time dimensión hierarchy.

I tried:

<FILTER EXPRESSION="IIF(([Períodos del Stock].[Jerarquía Períodos del Stock].currentmember.properties(&quot;CAPTION&quot;))=(ClosingPeriod([Períodos del Stock].[Jerarquía Períodos del Stock].[Período]).MEMBER_CAPTION),1, 0)"><CONDITION OPERATORCONDITION="Equal"><CONSTANT CAPTION="1"/></CONDITION></FILTER>

or:

<FILTER KEY="[Períodos del Stock].[Jerarquía Períodos del Stock].[Período]"><CONDITION
OPERATORCONDITION="Equal"><CONSTANT
CAPTION="ClosingPeriod([Períodos del Stock].[Jerarquía Períodos del Stock].[Período])"/></CONDITION></FILTER>

or:

<FILTER EXPRESSION="IIF(([Períodos del Stock].[Jerarquía Períodos del Stock].currentmember.properties(&quot;CAPTION&quot;))=(ClosingPeriod([Períodos del Stock].[Jerarquía Períodos del Stock].[Período]).properties(&quot;CAPTION&quot;)),1, 0)"><CONDITION OPERATORCONDITION="Equal"><CONSTANT CAPTION="1"/></CONDITION></FILTER>

but it didnt't work.

I would appreciate any suggestions.

Agustín