• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 820
  • Last Modified:

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
0
keplan
Asked:
keplan
  • 4
  • 2
1 Solution
 
Rainer JeschorCommented:
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
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now