I have two measures in my cube - STOCKVALUE and STOCKQTY.
I have the following Dimensions - Products, ProductType,
Time-Year>Month>Week

Now we want to do the following kind of ageing reports :


ProductType < 3 Months > 3 months & < 6 Months > 6 Months < 12
Months

ABC001 $1990,900 (value of stock)
XYZ002


So for each productType we want to show the value of the stock in
various time buckets by productType.

Can somebody please clarify how we can do this kind of ageing report.


Thanks
Karen

Karen Middleton wrote:

Karen

I think you have a granularity issue here. To do stock aging you need
to refresh the age data summaries derived from sku data each time you
reload data.

The problem is that in a very simple example

Month 1 Month 2
Opening Inv 100,000 100,000
Sales 0 0
Intake 0 0
Closing Inv 100,000 100,000

You have the same stock in months 1 and 2. Nothing has sold, however
all inventory is now a month older.

To complicate the example a little further, if you sell 1,000 in month
1, then unless you know the age of the stock you sell, you can't hope
to work out the age profile of the remaining inventory.

Of course if you store the data at a level where you can do this
arithemetic and you can calculate on a FIFO basis then you might get
there!

Typically in my work with retailers they get aged stock reports based
on summaries of sku level data based on season code attributes.

Does this make sense to you?

Regards

John

--
John Hobson
The Planning Factory Ltd
www.planfact.co.uk

John

Thanks for the update.

May be I did not communicate the meaning of stock age that clearly I
am trying to see which stock had a movement in the last 3 months, 3 to
6 months and 6 to 9 months and more than 9 months.

I am not a MDX expert and not sure how I can do this from the time
dimension my cubes stores at product level when the last movement
happened in the time dimension now I want to show these movements in
various time buckets.

Thanks
Karen


"John Hobson" <jhobson.nospam (AT) planfact (DOT) co.uk> wrote