Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Error(1260052):in ASO MDX member formula
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