Wednesday, January 16, 2013

[OBIEE11g]How To Find Current Quarter With Out Using Time Series Function?


Solution1

Using Dynamic Repository Variable Current_Year And Current_Date Column

Case When Year(Datecolumn)=Valueof("CURR_YEAR") Then
Quarter_Of_Year(Datecolumn) Else 4 End

Solution2

Using With Out Veriable  Using Date Column In The Report

Case When Year(Datecolumn)=Year(Current_Date) Then
Quarter_Of_Year(Datecolumn) Else 2 End



Thanks
Kishore