Ago Function Not Working With Time Level
(Doc ID 1334081.1)
Last updated on OCTOBER 03, 2022
Applies to:
Business Intelligence Suite Enterprise Edition - Version 11.1.1.3.0 [1905] and laterOracle Fusion Application Toolkit - Version 11.1.11.1.0 to 11.1.11.1.0 [Release 1.0]
Information in this document applies to any platform.
Symptoms
On : 11.1.1.3.0 [1905] version, Analytics
When attempting to use the AGO function in Analytics the syntax of the function reads "AGO(expr, time_level, offset)".
When it is used accordingly (i.e. AGO("BatchFacts"."#Batches", "Time"."YearNr", 1)) and the OK button is pressed, the following error occurs:
Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27037] Unresolved level: "Time"."YearNr". (HY000)
SQL Issued: SELECT AGO("BatchFacts"."#Batches", "Time"."YearNr", 1) FROM "VPA Batch Statistics"
When the parameter Time Level is removed from the function it works: AGO("BatchFacts"."#Batches", 1)
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |