NON additive measure across different dimensions

[ewmwayne]

I have a cube with 3 dimensions.
Product,Store Structure,Time (Year/Period/Week)

I have multiple measures for sales/margin and stock.

The sales and margin should be aggregated by adding accross all dimensions.

The stock figures should be added across all dimensions
except the time dimension.
Across the time dimension the stock figure should be the figure for the last week.

How and where can I add MDX formulas to achieve this

Andy.

 

[MDXer]

Look at using Calculated cells. Calculated Cells are Like a Calculated measure but based upon a criteria. You could set the criteria to be your time member and then create a straigh forward measure probably using previous member. Sorry don't have AS installed where I am at but it shouldn't be to hard. Although doing this may mess up rollups at higher levels.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck