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?
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?