Hi All,

We've got a cube with some measures that will be aggregated in hierarchy
of one dimension, and some measures for which aggregated values need to
be preloaded for higher levels of hierarchy.

Any comments on how to do it?

Many thanks,
Robert

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

you can create 1 cube for each level of detail, then create a virtual cube
which combine these cubes.

For example, you have 1 cube with "daily sales" which contain detailled
sales, and 1 cube "monthly budget" which contain your budget at the month
level.
Combine these 2 cubes into 1 virtual allow you to access measures at the day
and month level.

does it this type of usage resolve your issue?

"Bob" <rmail (AT) devdex (DOT) com> a écrit dans le message de news:
OQfLCFVxEHA.2196 (AT) TK2MSFTNGP14 (DOT) phx.gbl...

I also have the same doubt... Your answer does not seem to clarify
fully...

My dimension is;

Brand Dimension
Level1 -> .Manufacturer
Leve2 -> ..Product

Now there are two fact tables.. one by manufacturer and one by product.
Each has a common measure called quantity. However, its pre-aggregated
in the fact table and need not be rolled-up in the cube. But actually
they are only one one measure 'Quantity'.

Mittche..

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

ok

its the same way
2 cubes
+ 1 virtual

create a calculated measure like this:
iif(Dimension.currentmember.level is dimension.manufacturer,
(Dimension.currentmember, measures.manufmeasure), (Dimension.currentmember,
measures.productmeasure))

hide your manufmeasure and productmeasure
and the user will see 1 measure only and the right value without any effort


"Mitcherson" <Christos (AT) yahoo (DOT) com> a écrit dans le message de news:
%230mRrxVxEHA.3336 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

Thanks .. Thats solves it.

Mittche..

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!