Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error(1260052):in ASO MDX member formula

SomRanjanDec 9 2021 — edited Dec 9 2021

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

Added on Dec 9 2021

#business-intelligence-applications, #epm, #essbase, #fdmee, #hyperion, #performance-management-applications, #planning, #planning-and-budgeting

0 comments

519 views