MDX: Showing two levels in a dimension

[ajc123]

Newbie question:

The "Category" Hierarchy has two levels. I want to show both the Category and Sub-Category as my rows. It's easy to check these levels in a Pivot Table, but how do I get both to show up using MDX?



I'm using the syntax:
{[Category].[MainCategory].members, [Category].[SubCategory].members } on rows

But when I parse the return set I only get the members from the Section level.

Is it my MDX or my parsing algorithm that's wrong here?

 

[hudi]

Hey,

it's better if you user function descendants.
You can define which levels you want to show.
Check out help and there is a good example!

Bye,
Andrej

 

[MDXer]

The following should be what your looking for.

Descendants({[Category].[MainCategory], [Category].[SubCategory],SELF_AND_AFTER)

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck