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.
// [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.