Skip to Content
author's profile photo Former Member
Former Member

Condition in OLAP Universe (Analysis Services 2008)

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Aug 24, 2012 at 09:45 AM

    A solution to retrieve the latest period in an OLAP cube is given page 33 of the document

    http://scn.sap.com/docs/DOC-29733

    Note that this paper is related to the UNX universe.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.