Have 2 amounts that need to be combined - here's the setup:

Have a hierachical dimension with lets say 2 levels. On the first level I
have one amount and on the second level I have another amount.

So it looks kind'a like this:

Amount1 Amount2

Area 1 10000
Branch 1-1 9000
Branche 1-2 500

Area 2 20000
Branch 2-1 7000
Branch 2-2 14000

I would like to put this into olap and have considerede several different
approaches:

*) a physical cube for each amount type and combining those in a virtual
cube - that didn't seem to do the trick...perhaps i need to combine
this with something special in the dimensions

*) Using ragged hierachies - my problem is thought that this isn't always
supported by the front-end....but I could put area's and branches into one
dimension table and having this UNION dimension table reference a total fact
table - and then I could choose to hide member if name = parent - that
would get rid of area's on branch level ?

Are there any other ways to go....?

/Michael V.

Problem solved - found another post with virtual cubes....
"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote

Merge the amount colomns and make a hierarcy of the Area dimension.

Ole

"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote

Got i solved...but I cannot merge the amount columns - its to different
amounts that needs to be displayd like this:

One is a centralized budget frame and the other is a decentralized
budget....

But if can all be solved by 2 differencet cubes put into a virtual cube
where you in one cube change the mapping and hide the
bottom level...

Not something I would think of myself but got the tip in some other posts...

"Ole" <ole4u (AT) online (DOT) no> wrote