OBIEE Year Ago Sum of Points

Nikhila reddy

Hi There,

report has prompt to date and from date.

here my report requirement to get Sum(points) for the selected range and the same range date exact last yera.

for example FromDate: 13th sep 2017  ToDate: 15th Nov 2017

Current Year should display Sum(points) between FromDate: 13th sep 2017  ToDate: 15th Nov 2017 these dates.

Year Ago should display Sum(Points) between FromDate: 13th sep 2016  ToDate: 15th Nov 2016 these dates.

Can anyone Help me out from this.

Thanks in advance

Nikhila

ArijitC

Read these blog about time series analysis in OBIEE. Hope this will help.

Thanks

Arijit

OBIEE in IL: OBIEE and Time Series Calculations in analysis (Ago‎, Period Rolling‎, To Date‎)

OBIEE in IL: OBIEE - Few options to compare data to previous month, Year or something...

ArijitC

Here is oracle documentation about how to set up time series function.

https://docs.oracle.com/middleware/1221/biee/BIEMG/dimensions.htm#BIEMG348

Thanks

Arijit