I have created Dealer dimension in SSAS 2005 and it has 3 hierarchies. By default the hierarchy created first is the default hierarchy of the dimension. Is there any way to change the default hierarchy to another hierarchy.
changing default hierarchy of Cube dimension
1.8k Views Asked by paranjai At
2
I don't think there is actually a "default hierarchy" property, but if you want to change the ordering of the hierarchies you could try scripting out the dimension as "Alter" from SQL Management Studio and then changing the order of the nodes.