Oracle Analytics and AI

Child Item

Query Error with AGO Function

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

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

Regards,

Arjun

@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)

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

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

Regards,

Arjun

@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?