I have a cube with a couple of measures and I want to aggregate these
measures from the first period in the cube. The time dimension, Period, has
four levels Year, Half year, Quarter and Month, the time dimension has no All
level. I have tried to create a calculated member with the following formula:

Sum(PeriodsToDate([Period].CurrentMember.Level.Members.Item(0):[Period].CurrentMember))

In the Calculated Member Builder I receive “Formula error-syntax error-Token
is not valid” but I can’t figure out how to change it. Can anybody give me
a hint?

Many thanks in advance

--
Not a Guru