Showing 3 different dates in a report
Options
Moses Emuze
Customer
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
------------------------------
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:
0
Answers
-
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
------------------------------
-------------------------------------------0
Categories
- All Categories
- 1.8K Forums
- 1.7K Platform
- 106 Academy
- 282 Resources
- 3 Community Captains
- 1 About Community Captains
- 1 Meet the Community Captains
- 1 Topics & Thought Starters
- Board Manual
- 50 Best Practices
- 42 How-To Guides
- 25 Board Advocacy Program
- 158 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- Academy
- 2 Board Academy
- 7 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.1K Idea Exchange
- 305 Partner Hub
- 2 Solution Sales Toolkits
- 91 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP