Categories
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Query Error with AGO Function

Quinn Thacker
Rank 3 - Community Apprentice
When trying to use the AGO function I am recieving the below query error with the Financials - AR Revenue subject area.
0
Best Answer
-
Hi @Quinn Thacker
AGO Function need an time level Attribute, so you need to select from hierarchy instead of direct selected column.
Regards,
Arjun
1
Answers
-
@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)
0 -
@Ashish-Oracle seeing this error when trying to use Fiscal Year instead.
0 -
@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?
0 -
@Mallikarjuna Kuppauru-Oracle this worked thank you!
0