Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 106 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Week number configuration
922901
Rank 1 - Community Starter
Hi,
There is a reporting requirement for weekly report and we are using the obiee week number functionality. The way obiee calculates week is from Sunday to Saturday but our requirement is to calculate week from Monday to Sunday. Is there any way to change that in obiee or do you recommend any other solutions?
Thanks
Julie
0
Answers
-
Use of information drives data model design ... you need to put the 'configuration' of your calendar into your Time dimension table and model it for how you are planning on using it. You can 'house' more than one calendar in a Time dimension as the grain is the same (a date is a date is a date) ... fiscal calendar, ad calendar, event calendar, Gregorian calendar all resolve to grain of date.
0