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 MAY 10, 2018

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 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

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
Goal
Solution
References


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