My Oracle Support Banner

Essbase: MDX Query is Throwing Error When Using Filter Function With UDA in Search Condition. ERROR - 1260052 - Syntax error in input MDX query on line 2 at token ')' . (Doc ID 2647939.1)

Last updated on MARCH 11, 2020

Applies to:

Hyperion Essbase - Version 11.1.2.4.037 and later
Information in this document applies to any platform.

Symptoms

The following MDX is throwing an error near UDAValue:

With
  set [_Axis1Set] as '{Filter({[Dim1].members}, [Dim1].CurrentMember.[<UDAValue>])}'
select
  {} on columns, {[_Axis1Set]} properties GEN_NUMBER on rows
from [App].[DB]


ERROR - 1260052 - Syntax error in input MDX query on line 2 at token ')' .
ERROR - 1241101 - Unexpected Essbase error 1260052.

Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.