Categories
- All Categories
- 168 Oracle Analytics News
- 34 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.8K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 13 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- 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
