Recently, I came across interesting blog in crystal reports space from Jamie where he designed a report to display data in calendar format. So I took this same idea and wanted to reproduce this in Webi. So, lets start on how to do this in webi.
Step # 1: You need have date field from your DB and create a four variables Viz.. Day, Month, Week.Day in text
Day : FormatDate([date];”d”) (Create as measure)
Day in text: FormatDate([date];”Dddd”)
Step 2: Lets drop a cross tab and assign the above four variables.
Horizontal axis: Day in Text
Vertical axis: Month and Week
Body axis: Day
Step # 3: Just do some sorting on Month,week and day in text as needed and you will see now that crosstab looks like a calendar