Question:
Dear All
At my clients place they are deciding to monitor Management Cockpit on weekly basis,,, By default it is monthly/quarterly basis.
Have anybody already done a cockpit less than a month/year..
Early help would be appreciated 1
Thank you.
sanju
_________________
Sanju
Answer:
We had a weekly cockpit that we implemented at a client.
All data loads and buffering was done on a daily basis but all the underlying queries were based on calendar week.
Worked well.
Answer:
Oh thats a good news,
Can you elaborate more how the setting was done ? Have you created new periodizations and Time variable for weeks or you have used CPM variable to arrive at weekly information ...
For Ex, I need to compare current week sales with earlier week. I am keeping time variable as month still.. and creating a cpm variable for a week.. Is there other way to do that ?
Please let me know ASAP.
Many thanks in advance @
sanju
Answer:
Create the queries at week level... you can use 0CALWEEK in the queries
Structure for the x-axis with off sets.
You can also mix months and weeks in the same graph... we did a rolling 12 month graph with the last five weeks being in week format. This was done but creating a structure for the x-axis
Current period -12 until Current period -1
Current week -5 until Current week
Hope this helps
Answer:
Sanju - sorry was not lo9gged in when I posted the reply... let me know if this helps you or not
melfield
Answer:
Create the queries at week level... you can use 0CALWEEK in the queries
Structure for the x-axis with off sets.
You can also mix months and weeks in the same graph... we did a rolling 12 month graph with the last five weeks being in week format. This was done but creating a structure for the x-axis
Current period -12 until Current period -1
Current week -5 until Current week
Hope this helps
Dear all,
I am also facing same week wise data problem in MC , could u please explain in detail.
Where u created x-axis at query level or MC level?
Becouse at MC level in time variable there is no week period.
Please this is very very very urgent.
Can u give your contact no.?
Thanks in advance.
Regards/Hari
Answer:
Sanju,
Yes you can get week wise data on MC frame graph dinamically,
Hari