Hi Jens,
Believe me it is a relational expression. The main problem here is that you are trying to use SQL based logic (the CASE statement) against a dimensional data source (which doesn't understand SQL). There is nothing equivalent to a CASE statement in MDX, except using if, then, else.
You will not get an syntax error, but you can get unexpected behaviour when mixing dimensional and relational expressions in a report. I have seen for example reports not showing data or totals in crosstabs when using case statements in query items. Replacing this with if, then, else solved these issues.
If you are using a DQM package, you could use the macro case statement instead.
------------------------------
Thomas van der Meer
------------------------------
Original Message:
Sent: Tue December 01, 2020 05:34 AM
From: Jens Tüselmann
Subject: XQE-PLN-0026 Found unsupported IIF function arguments
Hi Thomas,
I don't believe that a case statement is not supported by an DMR model in general. I didn't find anything about that in the documentation (especially Redbooks, Cookbook etc.).
I have checked one of our reports with several case statements in a query subject and I have determined not every case statement produces the error message. Only if the case statement contains a calculation with more than one operator in the else path for example "else 12+2*2". But it is not realy clear because the behavior is different in different case statements and it depends on the syntax of the whole case statement.
So, I think this is a bug and we will try to contact the support.
BR
Jens
------------------------------
Jens Tüselmann
Original Message:
Sent: Mon November 30, 2020 01:15 PM
From: Thomas van der Meer
Subject: XQE-PLN-0026 Found unsupported IIF function arguments
Hi David,
I'm not sure if this is applicable for dynamic cubes, but I do know that the case statement is a relational expression.
So you are not supposed to use it in a dimensional model.
------------------------------
Thomas van der Meer
Original Message:
Sent: Tue September 01, 2020 03:53 AM
From: David Kristensson
Subject: XQE-PLN-0026 Found unsupported IIF function arguments
Hi,
After upgrading from 11.1.3 to 11.1.7 some of our reports and also some measures in our dynamic cubes stopped working. I have found the cause of the problem to be our CASE WHEN statements. After changing them to IF THEN ELSE it works. But in some cases when there are many possible outcomes it is much easier to use CASE WHEN so my question is why this happens?
Has anyone else experienced the same problem?
Here is an example from the dynamic cube startup log:
<![CDATA[XQE-ROL-0095 The definition for the calculated member 'Share' is not valid. It has been removed from the hierarchy [Measures].XQE-PLN-0026 Found unsupported IIF function arguments.
BR,
David
------------------------------
David
------------------------------
#CognosAnalyticswithWatson