Query Error with AGO Function

Quinn Thacker · Jul 17, 2024 3:56PM

When trying to use the AGO function I am recieving the below query error with the Financials - AR Revenue subject area.

Mallikarjuna Kuppauru-Oracle · Jul 17, 2024 4:20PM

AGO Function need an time level Attribute, so you need to select from hierarchy instead of direct selected column.

Regards,

Arjun

Ashish-Oracle · Jul 17, 2024 4:11PM

@Quinn Thacker Please try to use Fiscal Year from Fiscal Calendar Hierarchy and let me know if it helps.

Refer: OAC: Ago Function In DV Fails With nQSError: 27037 "Unresolved level" (Doc ID 2585569.1)

Quinn Thacker · Jul 17, 2024 4:17PM

@Ashish-Oracle seeing this error when trying to use Fiscal Year instead.

Ashish-Oracle · Jul 17, 2024 4:21PM

@Quinn Thacker I used the Fiscal Year from Fiscal Calendar Hierarchy and it works well for me.

Can you refer my screenshot and try this?

Quinn Thacker · Jul 17, 2024 4:22PM

Oracle Fusion Data Intelligence