Ago Function not displaying data for Prior Year Periods

Question

Hi,

We have created a AGO function in FDI semantic layer using it in OAC Classic view(OTBI). with Fiscal Period as Column Prompt.

On selecting Jan-24 as Fiscal Period, Column with AGO function for Dec-23 doesn't show any data.

Here is the syntax used for AGO - AGO(,Activity Amount,Fiscal Period,1)

Won't AGO function work for the last year periods.

Please share your thoughts on this.

Vaigu_27 · Answer

@Silvio Garber-Oracle,

I have created AGO function with the above mentioned steps, if i try to pull created column in report, select Jan-24 in the column prompt , Dec-23 column shows empty in the report.

Thanks,

Vaigu

Silvio Garber-Oracle · Answer

I´ve seen this similar question last week

https://community.oracle.com/products/oracleanalytics/discussion/22246/query-error-with-ago-function