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 display data of Last 12 months in Analysis

Rai Qaiser HussainJan 30 2019 — edited Jan 31 2019

Hi All

I have a requirement to show data of last 12 months, I read following links but could not fullfil my requirement properly.

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

https://www.clearpeaks.com/retrieving-revenue-average-of-last-n-months/

https://shivabizint.wordpress.com/2008/09/19/rolling-months-data-for-year-month-prompt-in-obiee/

Final Work I did

function used to get the last 12 month MIN(TIMESTAMPADD(SQL_TSI_MONTH,-12, "Revenue"."D01 Time"."Calendar Date" ))
Created prompt and added into presentation variable-- result is ok at prompt level
Passed presentation variable into filter (@{presentation variable}) , analysis does not return any data, as per query under advance tab, presentation variable does not pass value

anyone please guide what is wrong in this solution or any better solution please

Fig.1, this is actual requirement but it is achieved after hard coding the month with between function

This post has been answered by Jerry Casey on Jan 30 2019

Jump to Answer

Added on Jan 30 2019

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

10 comments

1,266 views