Skip to Content
0
Former Member
May 29, 2009 at 01:06 PM

How to add factory calendar to display in Bex query report?

54 Views

Hi Experts,

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 -


Budget day

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.

BSTOMS