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 12.2.1.2.0 and laterInformation in this document applies to any platform.
Symptoms
On: Oracle Business Intelligence Enterprise Edition
- When using Period rolling function in RPD it shows [nQSError: 27002] Near <,>: Syntax error [nQSError: 26012] .
- when ever uses the fourth optional parameter which is documented.
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.
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 |