Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
WEEK_OF_YEAR in OBIEE11g always adds one additional week

WEEK_OF_YEAR function always adds one additional week number in OBIEE11g.
When I evaluate the function WEEK_OF_YEAR(CURRENT_DATE) it provides the value as 17.
Ideally i should be 16.
Is there a local settings I can change to display the correct value.
Since we moved from OBIEE10g to OBIEE11g it is impacting all our existing reports.
Please note this is not due to start of the week parameter.
Answers
-
I haven't used 10g version before, but what was the range of values it returned? Was it 0-52? In 11g, the range is from 1-53.
0 -
This is precisely why these types of attributes should be built into your Time dimension ... since you have to go and modify/update your reports, you might as well get a fully formed Time dimension and do it once.
0 -
Both the versions provide week numbers in the range of 1-53.
Actually this is nothing to with OBIEE10g to OBIEE11g.
What I see here is that it is not matching the ISO week number
0 -
This is one of the legacy system. We need to migrate it immediately.
For our new system we will definitely consider this suggestion.
I understand start of the week can be modified by using locale settings config file.
Any such configuration change can make this happen?
0