Choose a default hierarchy in a dimension

Hi all,

I explain my case. In a Article dimension I have 3 hierarchies (Natures, Staven, Service). When I browse my cube in bids with this exemple :

on rows axis I drag and drop article dimension

on columns axis I drag and drop a time dimension

on data area I made the same operation with a mesure

Then wen I expand article dimension the hierarchy I saw is Natures. I don't want it. I want Service one. How can i do that?

In advance thanks for your help.

Christophe

The first hierarchy you create in BIDS will be your default hierarchy. IE: The Top/left-most hierarchy you see in BIDS.|||

Hi,

Thanks for your reply. It's impossible to change that?

Christophe.

|||Hey,

You could recreate your hierarchies (if it's not too much of a pain). Or, I haven't tried this yet but assume it'll work, you could just change the order of your hierarchies in XMLA.

So, just script your dimension to a new query editor, search for your hierarchies, (you're looking for the <Hierarchies></Hierarchies> tags), and move the hierarchy you want to be default to the top of the list.

C