Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)

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 ?

 

1 Answer

0 votes
by (47.2k points)

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. 

Related questions

0 votes
1 answer
asked Jan 31, 2020 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
asked Feb 27, 2020 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
0 votes
1 answer
asked Feb 27, 2020 in BI by Vaibhav Ameta (17.6k points)

Browse Categories

...