My Oracle Support Banner

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

Last updated on DECEMBER 22, 2020

Applies to:

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


On : version, Analytics


How to use the time series functions such as AGO, TODATE function in BI Answers?

When using AGO function, receiving [nQSError: 27037] Unresolved level: "Time"."Year" when trying to run:

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


When using TODATE function in "Sales - CRM Opportunities and Products Real Time":

TODATE("Pipeline Facts"."Opportunity Revenue", "Time"."Year")

and got this error :
"Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. (HY000)
[nQSError: 43113] Message returned from OBIS. (HY000)
[nQSError: 27037] Unresolved level: "Time"."Year". (HY000)
SQL Issued: SELECT TODATE("Pipeline Facts"."Opportunity Revenue", "Time"."Year") FROM "Sales - CRM Opportunities and Products Real Time"
OK (Ignore Error)"


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.