Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 182 Oracle Analytics News
- 39 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 62 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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