on 01-17-2013 8:18 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.