Oracle Fusion Data Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Ago Function not displaying data for Prior Year Periods

Received Response
33
Views
2
Comments
Vaigu_27
Vaigu_27 Rank 3 - Community Apprentice

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.

Answers