How to use the AGO() function in BI Answers? Why receiving [nQSError: 27037] Unresolved level: "Time"."Year" ? (Doc ID 2251933.1)

Last updated on APRIL 05, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

On : 11.1.11.1.0 version, Analytics
How to use the AGO function in BI Answers?

Why receiving [nQSError: 27037] Unresolved level: "Time"."Year" when trying to run:

 

SELECT AGO("Pipeline Facts"."Opportunity Revenue","Time"."Year", 1) FROM "Sales - CRM Pipeline"

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms