I have a measure which is "Working Days to Stock-Out". We calculate
this in our source database at each of three levels in the product
hierarch (call them Item, Item Group, and Item Group Parent). We
trend this value over time using the latest data just like an inventory
snapshot.
My problem is that this measure is totally non-additive up the product
dimension. Is there a way I can populate the cube levels above Item
manually so that the cube returns the correct value at each level of
this hierarchy? Failing this, I will have to create a separate cube
for each level, which seems wasteful.

Hi,

Are your thought about semi-additive measures of AS2005?
They works with time dimension only.

I your case the measure has non-additive behaviour along of product
dimension.
Generally you can use:
- Custom Rollup
- Cell Caculations
- Calculated measure.

It's heavy to give you exactly advice without details of your caclulations.


Vladimir Chtepa

"Cresset" <mstjohn (AT) cressetconsulting (DOT) com> schrieb im Newsbeitrag
news:1136823428.629988.69390 (AT) g14g2000cwa (DOT) googlegroups.com...

I had a similar problem, and it was solved by using Existing (Sum())
kind of syntax. If you want details, please look for posts by me. And
Deepak's suggestion helped me with this.