Hello I'm new to MDX and wondered whether I could get a pointer in the
correct direction? Say I have Product A, B and C which are stored in my fact
table at a daily level with the number of units sold and number returned
etc..
I've created a time dimension, a product dimension and a measures dimension.
The measures holds things like the units sold. That's fine because when
rolling up days into weeks I get the number of products sold summed up for
the week by product. However, I also want to see the stock units. These
aren't to be summed up obviously. I only want to ever see the number of units
at the beginning of the period. So if product A had one unit in stock on
day1 and then 2 on day and thence forth I would only want to see 1 unit when
I roll up to the week and then even to the year. However, I want to sum up
across the product dimension, i.e. if both product A and B belonged to the
same brand I'd want the brand stock figure to be the sum across those two
products but only ever at the opening period. Any thoughts on how I achieve
this? Sorry if this is a little vague

Thanks

maybe you can try the unary operator to do this, however I think that the
best aproach would be:

focusing on a classic inventory problem, this article describes the
implementation techniques of semiadditive measures in online analytical
processing.
url:
http://msdn.microsoft.com/library/en...rame=true&_r=1

'cause thats what Microsoft would like us to do ;=)

"DaveK" wrote: