Common Date dimension
I have a requirement where I need to display Calendar days along with Key figure values, however, the calendar day characteristic is not part of InfoProvider. In the below case, PO date and Delivery date shall match calendar date for count to occur. Any ideas?
I have PO date and Delivery date in InfoProvider but not calendar date (which I need to display in output).
Please also note the third row where the count is zero but I still need to display the row.
Date No. of Purchase Orders No. of Delivery Document
01.01.2015 50 40
02.01.2015 300 45
03.01.2015 0 0
04.01.2015 10 20