Skip to Content
0
Former Member
Aug 06, 2009 at 07:31 AM

pre-defined conditions in an OLAP universe

22 Views

Hi,

I need to schedule my report and pass date parameter as yesterday.

so for that i was trying predefined condition in universe, but i am not able to pass day/year dynamically.

the OLAP cube's hierarchy is like

A. YEAR >Month >Day

so please help me to achieve this

i have used a conditional filter and the condition is

<FILTER KEY="[A].[Day]">

<CONDITION OPERATORCONDITION="InList">

<CONSTANT CAPTION="19]"/>

</CONDITION>

</FILTER>

<OPERATOR VALUE=u201DANDu201D><FILTER KEY="[A].[Month]">

<CONDITION OPERATORCONDITION="InList">

<CONSTANT CAPTION="1"/>

</CONDITION>

</FILTER></OPERATOR><OPERATOR VALUE=u201DANDu201D><FILTER KEY="[A].[Year]">

<CONDITION OPERATORCONDITION="InList">

<CONSTANT CAPTION="2009"/>

</CONDITION>

Regards,

Vishhu