ISNULL USING MDX IN SSRS

Question

Using ISEMPTY,I want to use ISNULL equivalent in MDX .
I want 2 dates to be compared and display the not null date value in the report.

MDX expression:

IIF(ISEMPTY(DATE1),DATE3,DATE2)
DATE1 = [DATE1].[DT Date]
DATE2 = [DATE1].[DT Date].ALLMEMBERS
DATE3 = [DATE3].[DT DATE].ALLMEMBERS

Result displays the LAST DATE specified in the condition i.e. DATE2 in above scenario, irrespective of the IIF Condition.
Could somone help me in resolving the issue ?
 

Answer 1

You can look for empty values in Multidimensional Expressions (MDX) statements and then perform certain calculations on cells with valid (i.e., not empty) data. It can be important to eradicate empty values when performing calculations, because some calculations, such as an average, may be inaccurate if empty cell values are included.

If empty values can be stored in your underlying fact table data and you don't want empty cell values to appear in your cube, queries and data-modification statements should be created which either eliminate empty values or combine empty values into some other value. Additionally, the Null Processing option of a measure can be used to modify null facts to convert the null into 0, convert it to an empty value, or even throw an error while processing.

Check out ssrs tutorial that helps you to gain much more knowledge.