Article ID: 947510 - View products that this article applies to.
Consider the following scenario. In an instance of Microsoft SQL Server 2005 Analysis Services, you have a parent/child hierarchy in a dimension. You set the ValueColumn property of the key attribute. However, you do not set the ValueColumn property of the parent attribute. Then, you use the Rowset Viewer sample to obtain the MDSCHEMA_PROPERTIES rowset of the dimension. In this scenario, you receive the following error message:
If you use the Discover method to retrieve the metadata of the MDSCHEMA_PROPERTIES rowset for the cube that contains the dimension, you obtain the following information:
Source: "Microsoft OLE DB Provider for Analysis Services 2005"
Result: 0x80004005 = E_FAIL
IErrorInfo: [0xc10f0011] "The " string cannot be converted to the unsignedShort type."
When Analysis Services determines the data type of the MEMBER_VALUE property of the key attribute, Analysis Services looks up the ValueColumn property of the parent attribute. Because you do not set the ValueColumn property of the parent attribute, Analysis Services obtains a NULL reference for the data type of the MEMBER_VALUE property of the key attribute.
To work around this problem, set the ValueColumn property of the parent attribute to the same value as the ValueColumn property of the key attribute. To do this, follow these steps:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about the Rowset Viewer sample, visit the following Microsoft Developer Network (MSDN) Web site:
Contact us for more help
Connect with Answer Desk for expert help.