Showing 3 different dates in a report

Moses Emuze
Moses Emuze Customer
First Anniversary
edited July 2021 in Platform
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
------------------------------
Tagged:

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited July 2021

    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
    ------------------------------
    -------------------------------------------