Oracle Fusion Data Intelligence

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

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

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.