My Oracle Support Banner

Ago Function Not Working With Time Level (Doc ID 1334081.1)

Last updated on DECEMBER 13, 2023

Applies to:

Business Intelligence Suite Enterprise Edition - Version [1905] and later
Oracle Fusion Application Toolkit - Version to [Release 1.0]
Information in this document applies to any platform.


On : [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)


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.