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

Last updated on MAY 16, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.3.0 [1905] and later
Oracle 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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms