My Oracle Support Banner

OBIEE: Periodrolling Function Shows nQSError: 27002, Syntax Error [nQSError: 26012] When Using The Fourth Optional Parameter (Doc ID 2326057.1)

Last updated on JUNE 25, 2023

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Information in this document applies to any platform.


On: Oracle Business Intelligence Enterprise Edition

Document says the following

The PERIODROLLING function includes a fourth optional hierarchy argument that lets you specify the name of a hierarchy in a time dimension such as yr, mon, day, that you want to use to compute the time window. This option is useful when there are multiple hierarchies in a time dimension, or when you want to distinguish between multiple time dimensions. See PERIODROLLING in the Logical SQL Reference Guide for Oracle Business Intelligence Enterprise Edition.



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.