Categories
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

Vaigu_27
Rank 4 - Community Specialist
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.
Tagged:
0
Answers
-
I´ve seen this similar question last week
0 -
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
0