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

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

Active

Type:	Bug
ID:	779808
Opened:	2/22/2013 9:03:47 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

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.

Details (expand)

English

SQL Server 2012 SP1

Analysis Services

Windows Server 2008 R2 Enterprise (SP1)

US English

Run mdx command to create a session member.

Call GetSchemaDataSet with the Members guid and the hierarchy+level as restrictions.

Will attach a sample project.

Exception thrown, message:

AdomdErrorResponseException
Error Code:-1056964586
Message:Internal error: An unexpected exception occurred.
Stack: at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, String requestNamespace, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling)\r\n at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, IDictionary adomdRestrictions, Boolean throwOnInlineErrors)\r\n at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(Guid schema, Object[] restrictions, Boolean throwOnInlineErrors)\r\n at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(Guid schema, Object[] restrictions)

Members metadata returned.

X64

Hyper-V (On-Premise)

File Name	Submitted By	Submitted On	File Size
ParentChildTesting.zip	Colin8098207	2/22/2013	20 KB
ParentChildTesting.zip	Colin8098207	2/22/2013	20 KB
TestParentChildHierarchies.zip	Colin8098207	2/22/2013	34 KB

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.

Thanks,
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.