Webintelligence - Calendar format

[vishal_p3]

Hello All,

I have a requirement where I need to show the forecasts of sales and revenue for the coming days of the month which the data is coming from BEx query as shown in the table(Figure 1).

I would require to represent the same in a calendar format shown in the image attached.

Please suggest how to achieve.

Figure 1:

Datesales ForecastRevenue Forecast5th March200$100$6th March250$110$7th March240$115$8th March255$100$9th March200$120$10th March180$100$11th March200$90$---31st March220$120$

Figure 2: Attached

[vishal_p3]

Attaching the table details as an image.image-1.png

[kohesco]

with objects like 0calweek(rows) and 0weekday(columns) with keyfigure-strcuture you can create a matrix

[vishal_p3]

Hi Hesters,

Can you please elaborate your comments.

Thanks!

[kohesco]

Hi

I see you have date in your CUBE/MULITPROVIDER so derive 0calweek and 0weekday from it.

0calweek will give you all the weeks of the year

0weekday will give you all the days of the week (1->7) (Mon-> Sun as text)

so this info should give you a matrix like

day 1 2 3 4 5 6 7

Week 1 X X X X X X X

Week 2 X X X X X X X

Week 3 X X X X X X X

Week 4 X X X X X X X

....