Hyperion Essbase (MOSC)

MOSC Banner

Error(1260052) - Syntax error in input MDX query on line 1 at token ')' YTD.

edited Jul 30, 2014 5:03AM in Hyperion Essbase (MOSC) 1 commentAnswered

I am getting a very peculiar error while changing the name of the member, which supposedly is a very easy task.

Issue 1# :

If I  rename the member Year to Date to Time Series, then there are MDX formula for YTD and MTD which also needs to be changed, since:

  1. YTD à Sum(PeriodsToDate([Ledger Date].Generations(2), [Ledger Date].CurrentMember), [Year to Date].[Load])
  2. MTD à CASE WHEN IsLevel ([Ledger Date].CurrentMember, 0)

THEN

Sum(PeriodsToDate([Ledger Date].Generations(4), [Ledger Date].CurrentMember), [Year to Date].[Load])

ELSE Missing

END

The moment I change the member name and click on the edit properties of these two child members, YTD and MTD, the outline freezes and I cannot change the formula.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center