Have a hierachical dimension with four levels - now I have the need to have
to differenct fact tables / physical cubes and I want to combine these using
virtual cube. Should be pretty straight - forward - however...

In cube 1 containing budget measures these measures are NOT placed on
the last level of this dimension - they are placed on level 3 - not level 4.

And in cube 2 containg realized measures the measure are placed on the
last level of the dimension.

How can go about combining this so when drill down to level 3 I will see
both budget and realized amounts and when drilling down to level 4 I will
only see realized amounts.

Have tried to make a virtual dimension with only three levels - that was a
no go...it
demands to have the lowest level which I can't use to map to cube 1.

Considering this approach:

I will place the budget measure in cube 1 on a random level 4 member - but
when
showing level 4 I will by MDX prevent it from being shown.

This is a bit cheaty ? Is there a more clever AS way to do this ?

Thanks

/Michael V.

Use the same 4-level dimension in both cubes, but disable level 4 in the
budget cube (In Cube Editor, select level 4 of your dimension, go to the
Advanced Tab and set the Disabled Property to 'Yes').
When you create the virtual cube, it will behave the way you described.

HTH,
Brian
www.geocities.com/brianaltmann/olap.html
"Michael Vardinghus" wrote:

Nope - didn't do...

I need this

Budget Realized

When drilling down to level 3 there will be amounts on both..but when
drilling down to 4 there should only
be amounts on realized...

Couldn't hide a level in one physical cube because whether or not a level is
shown will apply to both amounts
in the virtual cube.

So it must be a currentmember.level test...



Brian Altmann <findme@thesignaturewebsite> wrote

I'm not sure I understand.
If a level is disabled (this is different from hiding, BTW) in a source
cube, when you build the virtual cube the budget cells for the disabled level
will be shown, but they will be empty, the budget measure will only have
values from level 3 up.
I thought this was the behavior you wanted but it appears I was wrong.
Regards,
Brian
"Michael Vardinghus" wrote:

It is .. by I couldn't get it too work the way you say.....

Perhaps I should try again - you really mean the virtual cube at a level of
a
shared dimension between the 2 physical cubes can display from one
physical cube and not from the other ?

The first attempt as I recall it meant that I couldn't see the level 4 at
all but I
must admit I didn't check everything - just concluded that AS couldn't do
it.

Brian Altmann <findme@thesignaturewebsite> wrote

Yes, that's what I mean.
I've used that design without problems. Usually calculated members are added
to the Virtual Cube so the lower level budget cells are filled by using an
allocation algorithm.
Regards,
Brian


"Michael Vardinghus" wrote:

Hi,
Would you be able to send me the construct for the allocation algorithm? Im
am trying to achive the same thing with no success.

Thanks

Simon Misich (simon.misich (AT) nzdf (DOT) co.nz)

"Brian Altmann" wrote: