Showing 3 different dates in a report

Moses Emuze

Dear,

One of my clients would like to have a supply chain report wher in 3 dates are available. 
Creation date, shipment date and requested confirmed date. 
So creation date of the order and shipmentdates and requested dates of the order. 

I don't know what is the best practice is creating something like this. 
Do someone has an idea?

Kindly looking to the response. 

Warm regards,
Moses

------------------------------
Moses Emuze
Business Intelligence Consultant
Handelmaatschappij A. Smit en Zoon B.V.
Netherlands
------------------------------

Helmut Heimann

Hi @Moses Emuze,

my approach would be to:

1. create an entity for the order number
2. create an entity for the desired KPI (members being: creation, order, shipment)
3. create a DATE cube with those entities
4. fill the cube and work with a "refer to" concerning the KPI in your dataview/layout

Hope, that helps!

Helmut

------------------------------
Helmut Heimann
Senior Consultant
Board Community
Germany
------------------------------
-------------------------------------------