Welcome to the Oracle Analytics Online Forum!
We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
Ago Function not displaying data for Prior Year Periods
Vaigu_27
✭✭✭
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