How can I hide a dimension while browsing the cube if the measurement value is nothing?

I see 'hide member if' property but i am not sure if this is what i am looking for or not. The 'only child with parent's name, etc.' is confusing.
thx

Not sure if you want to hide a Dimension or a member of a Dimension. If it
is the latter here is some MDX that does it:

SELECT { [Measures].[Sales] } ON COLUMNS , NON EMPTY { { { [Products].[All
Products].CHILDREN } * { [EmployeeID].[All Employee ID].CHILDREN } } } ON
ROWS FROM [Cube1]



So you want to look at the NON EMPTY MDX statement...

An example of what this does is:

Before NON EMPTY

Product 1 500

Product 2

Product 3 1000

After NON EMPTY

Product 1 500

Product 3 1000

"dave" <dave (AT) discussions (DOT) microsoft.com> wrote

Well, the dimension is usernames. If the user has a value of nothing in the measurements i do not want to display that username. How would i remove or hide this username if the measurement value is zero when browsing the cube?

thank you for your quick response.
dave

It definitely sounds like NON EMPTY is the answer to your question...

Using FoodMart...

Run the following query:
SELECT { [Time].&[1997] } ON COLUMNS ,{ [Customers].[All
Customers].CHILDREN } ON ROWS FROM [Sales] WHERE ( [Measures].[Unit Sales] )



You will get Canada and Mexico listed with no Sales... And USA with X
amount...

Now run this query:

SELECT { [Time].&[1997] } ON COLUMNS ,NON EMPTY { [Customers].[All
Customers].CHILDREN } ON ROWS FROM [Sales] WHERE ( [Measures].[Unit Sales] )

You will get USA with X amount and no Canada or Mexico. Is this not what
you want?

"dave" <dave (AT) discussions (DOT) microsoft.com> wrote

or hide this username if the measurement value is zero when browsing the
cube?

To clarify, i am not directly using mdx expressions. I am using the excel interface or browsing the cube through analysis server. So, through either excel or analysis server how do i hide empt values?
thank you once again

I am not sure how to do this through the Excel interface as I do not use it.
As for the AS browser... I don't think this is possible, unless you modify
your query to prevent members with zero.
For example:

Select * From Vw_Sales Where Sales NOT 0

Good luck, and I apologise that I couldn't assist further.
"dave" <dave (AT) discussions (DOT) microsoft.com> wrote

excel or analysis server how do i hide empt values?