Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Business Intelligence Foundation
Business Intelligence Suite Enterprise Edition
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jan 25, 2013 12:08 AM by
How to Calculate Leap Year ago in OBIEE 11g
Jan 24, 2013 3:02 AM
I have one fact table and having one measure column. I have to calculate current year and Last year.
Using Time series function (Todate,Ago) have calculated current year as well last year also.
The problem is Current year is showing correct value only but Last year was showing wrong data.
We found the problem is Leap year, last year FEB month is having 29 dates. Due to this we are getting wrong date.
Kindly suggest me how to achieve this requirement.
This content has been marked as final.
Show 1 reply
Re: How to Calculate Leap Year ago in OBIEE 11g
Jan 25, 2013 12:08 AM
in response to
How to resolve Leap Year calculation in OBIEE 11g.
The problems is Year Ago column.
Please suggest me how to resolve this.