Dimension question

I asked this question in the MS OLAP and the SQL group but got no
response. I am
hoping somebody will have some answers here.
Thanks in advance
-------------------
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.
.

Relevant Pages

  • Re: johnreed take 14 - 2005
    ... Nice overall response Bill. ... that I believe that the mathematician physicist must take more ... third dimension all things are purely imaginary. ... trajectories of planets the result of a curved space when taken over ...
    (sci.physics.relativity)
  • Re: Why string theorists like Brian Greene are Crackpots
    ... > Androcles says, "I'd tell you but you don't respond, so I won't bother." ... > his definition of "dimension" because I won't respond? ... With you it's a blank stare. ... At least I provoked a response that time. ...
    (sci.physics.relativity)
  • Re: johnreed take 14 - 2005
    ... > Nice overall response Bill. ... > that I believe that the mathematician physicist must take more ... > third dimension all things are purely imaginary. ...
    (sci.physics.relativity)
  • RE: Drill through from excel 2003 into analysis server 2000
    ... Sorry for delaying this response. ... Select Cube Analysis -> Build Report; ... select Row and Column Headers; ... Click View Data Pane, select the connection, select Dimension as ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: [end 1:end-1] syntax
    ... > Thanks Jos for answering my earlier question. ... > I'm not familiar with the syntax of the following expression that ... > provided in response to a previous question. ... last 'coordinate' of that dimension automatically, ...
    (comp.soft-sys.matlab)
Loading