SSAS CUBE - MDX Help

Hi,

I have CUBE  developed using SSAS 2012. I need to clean the data showing to the users.
Such as empty cell should not show to the users.

i have attached the excel sheet for your reference.

I have highlightedrow that I dont want users to see. How do I achieve this please.

Thanks for any help.
MDX-Help.PNG
keplanAsked:
Who is Participating?
 
Rainer JeschorConnect With a Mentor Commented:
Hi,
in Excel or via MDX?
From my head (as I am ob the road)
In Excel right-click on the table and in the options either deselect "Show empty rows" OR check "Show non-empty" rows.
HTH
Rainer
0
 
keplanAuthor Commented:
Hi Rainer,

I need  using MDX please?

Thanks,
0
 
Rainer JeschorCommented:
Hi,
sorry for the late response but very busy project.

You have to use the nonempty parameter / config:
http://msdn.microsoft.com/en-us/library/ms145988.aspx
http://blogs.msdn.com/b/karang/archive/2011/11/16/mdx-nonempty-v-s-nonempty.aspx

HTH
Rainer
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
keplanAuthor Commented:
h
0
 
keplanAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for keplan's comment #a39280116

for the following reason:

ghj
0
 
keplanAuthor Commented:
d
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.