A dimension playing off another dim

A dimension playing off another dim

am 16.01.2008 19:15:06 von Mike K

I asked this question in the OLAP group but got no response. I am
hoping somebody will have some answers here.
Thanks
-------------------
HI,

I need to create a dimension that will play off another dimension. For
example: lets say we have branches going into discontinued operations
time to time. What we would like to create is a dimension that will
have the Discontinued status with Year. So something like:
2007 Discontinued
2006 Discontinued
2005 Discontinued

By clicking on each of those members we can effect a 2nd dimension
called Branch which will have its own parent child rollup for example:
United Kingdom
Birmingham
London
USA
New York
Dallas

My question is what is the best way to design this. Thanks for all
your help.