Forum Stats

  • 3,814,253 Users
  • 2,258,850 Discussions
  • 7,892,637 Comments

Discussions

Error(1260052):in ASO MDX member formula

SomRanjan
SomRanjan Member Posts: 40 Red Ribbon
edited Dec 9, 2021 12:56PM in Planning and Budgeting

Hello Gurus,

I am working on the below period (Dim Type:TIME)member formula but getting the error and need your assistance.

FORMULA:

CASE

WHEN(IsChild( ([YEAR].CurrentMember), ([YEAR].[CALENDARYEAR])))

THEN

(StrToMbr(Concat ("FY", Right (([YEAR].CurrentMember),1)))),([PERIOD].[P01])

END


There are two hierarchy under Year dimension i.e FINCIALYEAR(eg:FY2022) & CALENDARYEAR(eg:CY2022). If the current member of YEAR dimension is a child of [CALENDARYEAR] then the year member has to be changed to FY2022 instead of CY2022 and the period member will get the data from FY2022 & period 01.


ERROR:

Error(1260052) - Syntax error in input MDX query on line 4 at token ',' Jan

Jan com.essbase.eas.essbase.defs.outline.EditorCommands.VerifyMemberFormula December 9, 2021

Error(1260052) - Syntax error in input MDX query on line 4 at token ',' Jan