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 NOVEMBER 15, 2023

Applies to:

Goal

On : 11.1.11.1.0 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)"

Solution

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