I need to develop a report which displays the following output for each Site / Customer selection:
- Item Code
- Item Description
- Last 7 days orders
- Stock at 05.30 (of current date)
- Orders for next day
- Resulting Stock (Stock 05.30 u2013 Orders stock next day Delivery)
- 6 additional columns u2013 orders for the next 6 days
We have a delivery performance cube which holds orders / delivery / billing data and a stock cube. I am planning to combine these two in a Multicube however I am not sure which source Tables / Fields correspond to the above output and how to go about designing this report.
One more thing, my client wants to be able to view this data realtime.
Could you pls point me in the right direction.
Thanks,
Milind