Show weekends in Calendar view

Koen G-Oracle

Hi,

I need to created an OBIEE analysis that shows (This is based on BI Apps on Peoplesoft, but the question is not BI Apps related):

Per Month (Dashboard prompt):

- Row: Person Name

- Column: Gregorian Calendar Date

- Fact in Cell: # Absence Occurrences

And the columns that correspond to a weekend should have grey background.

Note: If I create an analysis with only "Person Name" and "Gregorian Calendar Date" then only records are shown for Person/Date combinations for which absences exist.

I added a field with: DAYNAME("Gregorian Calendar"."Date")

I have a pivot table and I use conditional formatting on "# Absence Occurrences" and verify DAYNAME("Gregorian Calendar"."Date") in (Sat;Sun).

But this will only change the formatting of the weekends if there is an absence for the person on that date. If the person did not have an absence in the weekend then the formatting is not changed.

For the customer it is important that the complete columns are grey for Saturday and Sunday.

Any suggestion to achieve this?

Thanks,

Koen