Error after adding Calculated Members in OLAP Cube

Answered
Nikolay Petrov asked on November 17, 2017

We get very strange error after adding Calculated Members in our OLAP cubes, we get  "Value cannot be null. Parameter name: key"
is there support for Calculated Members in flexmoster?  we getting the error just by adding the Calculated Member without actually displaying or using it.
 
best regards,
Nikolay

4 answers

Public
Tanya Gryshko Tanya Gryshko Flexmonster November 17, 2017

Hello, Nikolay,
Thank you for writing to us.
Flexmonster supports Calculated Members defined in OLAP cubes. Could you please check that you are adding such Calculated Members correctly? For example, you can use Excel to see whether you get an error after adding the Calculated Member.
If you see that such error appears only in Flexmonster, please share with us steps how exactly you add Calculated Members and other related information. Then we will try to reproduce the error on our side.
Waiting for your reply.
Regards,
Tanya

Public
Nikolay Petrov November 20, 2017

found the problem, we did not have "Associated measure group" set, now reports are opening.
We have new issue now, if we add the calculated member in the SELECT part of the MDX we get "A set has been encountered that cannot contain calculated members." error
 
best regards,
Nikolay

Public
Nikolay Petrov November 21, 2017

we found the problem in our JSON config, thanks for the help
 
best regards,
Nikolay

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster November 21, 2017

Hello Nikolay,
We are glad to know that everything works fine for you.
Let us know if there is anything else we can help you with.
Regards,
Dmytro.

Please login or Register to Submit Answer