Oracle Fusion Data Intelligence

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!

Ago Function not displaying data for Prior Year Periods

Received Response
27
Views
2
Comments
Vaigu_27
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.

Answers