Error(1260052) - Syntax error in input MDX query on line 1 at token ')' YTD.
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:
- YTD à Sum(PeriodsToDate([Ledger Date].Generations(2), [Ledger Date].CurrentMember), [Year to Date].[Load])
- 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.