Skip to Content
0
Former Member
Jan 17, 2013 at 08:18 AM

MDX Syntax Error in OLAP Universe

46 Views

Hi,

I'm using Bex query on top of the UDT universe. I'm trying to create a Universe level filter for a "Previous Day" time dimension using below MDX syntax.

<FILTER KEY="[0PSTNG_DATE].[LEVEL01]">

<CONDITION OPERATORCONDITION="Equal">

<CONSTANT CAPTION="[Measures].[ZPREV_DAY]">

</CONSTANT></CONDITION></FILTER>

// [Measures].[ZPREV_DAY] - comes from Bex as a formula variable


However, its throws an error in WebI while running:

"Database error: Failed to execute MDX query. Reason: Syntax error: Syntax Error : ... ON ROWS FROM [ZSDSO_M01/ZSDSO_M, row 247, item: 247. (IES 10901) (WIS 10901)"

We're using BO 4.0 - SP 5.0. Please help me to resolve this.

Thank you,

Vijay S