I have a specific requirement to design a report that show daily sale, MTD, YTD compare with Budget and they want to show factory date such as
May 28 2009
may-2009 - day 20 off 22
Product --- D --- MTD --- YTD -
Sweet A --- 22 --- 565 --- 58854 --- 32
Sweet B --- 22 --- 500 --- 50054 --- 16
My questions are:
1. I can figured out sales by day, MTD, YTD but budget day I have to calculate using factory calendar, how can I get calendar becasue there is no carlendar factory char. in the cube?
2. I also cannot figure out how to get the calendar display as above.
Any of your idea is my highly appreciate.