Partial Alternate Hierarchies

There have been a couple of questions on the Microsoft OLAP newsgroup (microsoft.public.sqlserver.olap) recently about making dimension members appear in more than one place in the dimension. Have a look at this article for one method of implementing this. [More]

[Updated 27 Oct 2005] I have add more detail on the Analysis Services 2005 solution as it was a little bit light on regarding exactly how the dimension usage was set up.

Print | posted on Monday, October 24, 2005 9:08 AM