MDX Syntax Error in OLAP Universe

[former_member203809]

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

[Henry_Banks]

Hi,

What's your version, SP, and Patch level information?

Same for BW, what's your Ehp and SP level?

Does the integration work if you remove the suspect variable?

Regards,

H

[former_member203809]

Henry,

   Thanks for the reply.

1. BO 4.0 and SP 5 and Patch 1.0

2. BW:  Release 730, SP Level - 0007

3. Yes the report works fine when I remove the suspect variable.

Regards,

Vijay S