Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error using summation in MDX query

Summary:

I'm trying to pull data from Essbase using a group of members that I need to sum up. To do it, I'm using WITH statement that looks something like that:

With 

Member [Risk] As '([Risk Type A] + [Risk Type C] + [Risk Type F])'

Then this [Risk] member will be used in a SET statement, together with other standard members of the hierarchy.


When I run this query through SmartView "Manage and Execute Queries" option, I'm getting this error message:

What am I doing wrong? I also tried to use SUM function but got the same result.


Thanks!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!