I have a cube created in MS Analysis Services that has calculated members. When I use Crystal Reports to report over the cube I cannot see the calculated members, just the measures. I found out that you can use MDX in CR so tried to do that but I get an error message.
The formula for the calculated member has been edited to reflect the different structure of the cube to the data source. But it complains about the formula syntax. The formula is
Sum(PeriodsToDate([GLBalances].[Period].[(All)]), [GLBalances].[Period Amount])
[GLBalances] is the name of the cube, [Period] and [Period Amount] are the period and measure fields.
The message I get highlights the PeriodsToDate function and says the ')' is missing.
I can't see a missing ')' so wondered if this is an instance of an error message getting it wrong.
Can anyone see why CR doesn't like this formula?
Thanks,
Flybridge
The formula for the calculated member has been edited to reflect the different structure of the cube to the data source. But it complains about the formula syntax. The formula is
Sum(PeriodsToDate([GLBalances].[Period].[(All)]), [GLBalances].[Period Amount])
[GLBalances] is the name of the cube, [Period] and [Period Amount] are the period and measure fields.
The message I get highlights the PeriodsToDate function and says the ')' is missing.
I can't see a missing ')' so wondered if this is an instance of an error message getting it wrong.
Can anyone see why CR doesn't like this formula?
Thanks,
Flybridge