Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

To get week ending dates from week number in obiee report

2791486Aug 21 2017 — edited Aug 24 2017

I have a report which shows calculated data in pivot tables for last four weeks i.e, 30,31, 32, 33 (week number as heading ). I just have week number column in the presentation folder .

I do not want to

* Make any changes in repository or ETL

* Also, I do not want to put CASE statements with 52 statements for 52 weeks as it will affect the performance.

Please let me know if anyone has the solution. I have a week starting from Monday to Sunday. So I would need Sunday's date as week ending dates in my OBIEE 12c report.

Thanks

This post has been answered by Martin van Donselaar on Aug 22 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 21 2017

Added on Aug 21 2017

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

25 comments

3,644 views