Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MDX: Showing two levels in a dimension

Status
Not open for further replies.

ajc123

Programmer
Oct 6, 2001
25
US
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?
 
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
 
The following should be what your looking for.
Code:
Descendants({[Category].[MainCategory], [Category].[SubCategory],SELF_AND_AFTER)

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top