Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics & AI Challenge
- Find Partners
- For Partners
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
