OBIEE 11g: How to calculate No.of days between dates excluding frinday

Question

HI,

How to calculate no.of days between two dates excluding Friday if Friday comes between the dates.

Regards,

MIT.

Joel Acha · Answer

Assuming you have a Date Dimension, you can do something along the lines of:

In your column formula: COUNT("Time"."T00 Calendar Date")

[Deleted User] · Answer

You can't really easily do this with TIEMSTAMPDIFF but you can do it with a time dimension containing day names and joining that to your fact - effectively kind of snowflaking it to get a COUNT of days between 2 dates is a subquery.