Year Over Year Comparison Calc for Custom Subject Areas

Question

Trying to take revenue amounts and create a calculation and dynamic filter that allows you to take a filter selected period and compare it to a trailing period either MoM or YoY.

The native functions like AGO do not work with the custom subject areas we have developed.

JohnW-Oracle · Answer

Hi Quinn,

Under some circumstances, there are alternatives to using the AGO function or Time Series Functions. Filter functions have some advantages including performance as described here:

https://blogs.oracle.com/analytics/post/oracle-analytics-performance-tuning-times-series

Regards,

John

Mallikarjuna Kuppauru-Oracle · Answer

Hi @Quinn Thacker

If you have an proper time dimension , AGO Function should work.

I am not sure below is work for you but for your reference we have one MOS doc  related to time series .

FDIP: Inconsistent Values Returned When Using YTD And AGO Across Reports (Doc ID 3011686.1)

Regards,

Arjun