Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Ago Function not displaying data for Prior Year Periods

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
-
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