conditional sentence MDX

[Former Member]

Hello,

What's the sintax for a conditional sentence MDX for a Universe with source BW?

I have the following:

<EXPRESSION>IIF(@Select(Indicad. Meta / Real\L01 Indicad. Meta / Real)="REAL",@Select(Ratios\Reclamos Oper. Acu.),0)</EXPRESSION>

In the universe this sentence is correct but in the webi report I have a error:

A database error ocurred. The database error text is: The MDX query WITH MEMBER

[Measueres].[...]

..

failed to execute with the error Unknown error. (WIS 10901)

Thank you.

Hugo.

[IngoH]

Hi,

some examples are included here:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0a45246-ce76-2b10-e688-f5c82062...

Ingo

[Former Member]

Hi Ingo,

That was the document used to produce the sentence, but I have the error of the previous note.

Hugo.

[IngoH]

Hi,

could you copy the complete error message and MDX statement here ?

thanks

Ingo