Hi,

Trying to do a stock turn calculation from a inventory history
database.
I have available only the movements (deltas) from the table, the
closing stock is available as a property of the product dimension.

Need to arrive at stock on hand working backwards from today's closing
stock by addind subtracting deltas backwards.

Please hep with an MDX for a calculated member.

Cheers !!

Aussie

Please help, I have 2 fact table

1. FactOrder with field
SONo
OrderDate_Key
RequestDate_Key
CancelDate_Key
ProdNo_Key
Qty Order
etc

2. FactShipment with Field
InvNo
SONO
Invdate_key
ProdNo_key
Qty Shipment
etc

Now i want to create report

RequestDate Qty Order Qty Open On Time Qty Late
Qty All Late Qty
Jan, 2006 10 5 3
2 7

where
On Time Qty = inv date < requestdate - 7
Late Qty = InvDate >= RequestDate
All Late QTy = Late Qty + ( All Open Order which request date < today )

Thanks,
Alvin Warouw

Hi Alvin,

You didn't say whether you already have a cube and, if so, what its
design is like. Anyway, if you can join the Order and Shipment tables in
a view (presumably there could be multiple shipments per order), that
might make some of the measures easier to compute. If your fact tables
are large, then a cube may be slower in correlating orders with the
corresponding shipments.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi Deepak,

Yes I can do it with View, but i think this condition will be same with
another fact table like Orders data vs Job Orders data ( Work Order ).
example : Late Job Order vs Orders Report

Thanks,
Alvin Warouw

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote