Thursday, June 14, 2012 7:32 PM
i am trying to get the data by simple MDX query like following
Select [location][city].members on columns, [measure][count] on rows Note:(query not same but like this sample)
But the in the results it is giving one blank value along with city value. how to avoid that blank value.
- Delhi 90
- bangalore 60
- chennai 70
Here what is the 80 value. its belongs to any city value? please let me know how to avoid those empty box?
Thursday, June 14, 2012 7:41 PM
Hi Madhu Mi
The value is probably related to NULL's or an empty string in your dimension. The question is what you want from the display - do you care about the 80 value or not?
If not you could simply change the query to be EXCEPT([Location].[City]., [Location].[City].[City]) On Rows
Thursday, June 21, 2012 5:36 AMModerator
You can try to use Non Empry within the MDX statement. Here are some related articles for your reference, please see:
NonEmpty (MDX): http://technet.microsoft.com/en-us/library/ms145988.aspx
MDX : Non Empty v/s NonEmpty: http://www.ssas-info.com/analysis-services-articles/50-mdx/2196-mdx-non-empty-vs-nonempty
Avoid null values in MDX: http://social.technet.microsoft.com/Forums/zh/sqlanalysisservices/thread/cb9be475-bd70-4630-a644-86868b2cb042
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, June 25, 2012 10:44 AM
Thursday, June 21, 2012 6:06 AMInstead of fixing this in SSAS or eventually MDX. Catch hold of the source system and check the entries in the location table. This is a data issue.
Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar | My Blog