I have Product Dimension with 2 level, Category (Members: A, B, C) and
Type. When a user click on members A, I want to hide Type Level, but if
they click others, we will provide the Type. What sould do? Do I have
using MDX or separate level Type into other dimension?
If use MDX, how's the syntax and where should I place it?

Thanks

There is a property on each level called "HideMembersIf". You can set
members to be hidden if they have the same name as their parent or if
their name is null. These settings are usually used to create ragged
hierarchies, but would work here if you manipulate the name column
appropriately.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

I think HideMemberIf is used to hide Member.
But what I want to hide is the Level, not Member.
Could I do that?

Thanks

If you want to hide a whole level, you can set it's visible property to
false. Or even disable the level within the cube. But I thought what you
wanted to do was to display the second level for some member of the
first level and not for others.

In this case you would manipulate the name column of the all the members
you did not want to see.

eg.

Set the HideMemberIf property to "NoName"

....and setup the dimension table (or a view of it) something like the
following.

MemberId, Level 1, Level 2
1, A, NULL
2, A, NULL
3, A, NULL
4, B, B1
5, B, B2
6, B, B3
7, C, C1
8, C, C2
9, C, C3

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell