Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OBIEE 11g: How to calculate No.of days between dates excluding frinday
user6536648
Rank 1 - Community Starter
HI,
How to calculate no.of days between two dates excluding Friday if Friday comes between the dates.
Regards,
MIT.
0
Answers
-
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.
0 -
Assuming you have a Date Dimension, you can do something along the lines of:
In your column formula: COUNT("Time"."T00 Calendar Date")
0
