Creating a calculated member in a parent/child dimension breaks GetSchemaDataSet() for Members - by Colin8098207

Status : 


Sign in
to vote
ID 779808 Comments
Status Active Workarounds
Type Bug Repros 1
Opened 2/22/2013 9:03:47 AM
Access Restriction Public


If you have a dimension with a parent child dimension, you can use the "Create Member" syntax to add a member to it.

Having done this, if you attempt to retrieve members of the top level using GetSchemaDataSet() you get an exception.

Tried this with SQL2012 and SQL2012SP1.

On previous versions the metadata was returned without a problem.
Sign in to post a comment.
Posted by Microsoft on 4/19/2013 at 11:40 AM
Thanks for filing this issue. We will consider addressing this in some future release of Analysis Services. In the interim, if this is critical for your workload, and you feel you need a hotfix for this issue, please file a case with customer support.

Analysis Services Product Team
Posted by Colin8098207 on 2/22/2013 at 9:32 AM
Oops, went a bit mad with the attachments there. One is a cube backup, the other is a C# project.
Posted by Colin8098207 on 2/22/2013 at 9:22 AM
Forgot to mention, this only seems to happen if the calculated member is at the top level, if it goes under another member it seems okay.