Microsoft KB Archive/915855

= All member relationships are returned when you set the AttributeRelationship Visible property of an attribute to true or to false in SQL Server 2005 Analysis Services =

Article ID: 915855

Article Last Modified on 4/13/2006

-

APPLIES TO


 * Microsoft SQL Server 2005 Analysis Services

-





SYMPTOMS
Consider the following scenario. In Microsoft SQL Server 2005 Analysis Services, you set the AttributeRelationship Visible property of an attribute to true or to false. Additionally, you request the MDSCHEMA_MEMBERS rowset for a member of a dimension. In this scenario, all member relationships are returned.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



Steps to reproduce the problem
 Start Business Intelligence Development Studio. On the File menu, click Open, and then click Analysis Services Database. In the Connect to Database dialog box, click Connect to Existing Database. In the Server box, type the name of the server. In the Database list, click Adventure Works DW, and then click OK. In Solution Explorer, expand Dimensions, and then double-click Customer.</li> In the Hierarchies and Levels pane, under Customer Geography, expand City, and then click the State-Province attribute relationship.</li> In the Properties window, under State-Province AttributeRelationship, click Visible, and then click False.</li> To process the database, click Process on the Database menu.</li> Start SQL Server Management Studio.</li> In Object Explorer, expand Databases, right-click Analysis Services Tutorial, click New Query, and then click XMLA.</li>  In the XML for Analysis (XMLA) query window, run the following XMLA query. <Discover xmlns=&quot;urn:schemas-microsoft-com:xml-analysis&quot;> <RequestType>MDSCHEMA_MEMBERS</RequestType> <Restrictions> <RestrictionList> <CATALOG_NAME>Adventure Works DW</CATALOG_NAME> <CUBE_NAME>Adventure Works</CUBE_NAME> <MEMBER_UNIQUE_NAME>[Customer].[Customer Geography].[City].&amp;[Alexandria]&amp;[NSW]</MEMBER_UNIQUE_NAME> </RestrictionList> </Restrictions> <Properties> <PropertyList> <Catalog>Adventure Works DW</Catalog> <Format>Tabular</Format> </PropertyList> </Properties> </Discover> You receive the following results. <CATALOG_NAME>Adventure Works DW Standard Edition</CATALOG_NAME> <CUBE_NAME>Adventure Works</CUBE_NAME> <DIMENSION_UNIQUE_NAME>[Customer]</DIMENSION_UNIQUE_NAME> <HIERARCHY_UNIQUE_NAME>[Customer].[Customer Geography]</HIERARCHY_UNIQUE_NAME> <LEVEL_UNIQUE_NAME>[Customer].[Customer Geography].[City]</LEVEL_UNIQUE_NAME> <LEVEL_NUMBER>3</LEVEL_NUMBER> <MEMBER_ORDINAL>80</MEMBER_ORDINAL> <MEMBER_NAME>Alexandria</MEMBER_NAME> <MEMBER_UNIQUE_NAME>[Customer].[Customer Geography].[City].&amp;[Alexandria]&amp;[NSW]</MEMBER_UNIQUE_NAME> <MEMBER_TYPE>1</MEMBER_TYPE> <MEMBER_CAPTION>Alexandria</MEMBER_CAPTION> <CHILDREN_CARDINALITY>1</CHILDREN_CARDINALITY> <PARENT_LEVEL>2</PARENT_LEVEL> <PARENT_UNIQUE_NAME>[Customer].[Customer Geography].[State-Province].&amp;[NSW]&amp;[AU]</PARENT_UNIQUE_NAME> <PARENT_COUNT>1</PARENT_COUNT> <IS_PLACEHOLDERMEMBER>false</IS_PLACEHOLDERMEMBER> <IS_DATAMEMBER>false</IS_DATAMEMBER> <State-Province>New South Wales</State-Province> Note You expect to receive the following results. <CATALOG_NAME>Adventure Works DW Standard Edition</CATALOG_NAME> <CUBE_NAME>Adventure Works</CUBE_NAME> <DIMENSION_UNIQUE_NAME>[Customer]</DIMENSION_UNIQUE_NAME> <HIERARCHY_UNIQUE_NAME>[Customer].[Customer Geography]</HIERARCHY_UNIQUE_NAME> <LEVEL_UNIQUE_NAME>[Customer].[Customer Geography].[City]</LEVEL_UNIQUE_NAME> <LEVEL_NUMBER>3</LEVEL_NUMBER> <MEMBER_ORDINAL>80</MEMBER_ORDINAL> <MEMBER_NAME>Alexandria</MEMBER_NAME> <MEMBER_UNIQUE_NAME>[Customer].[Customer Geography].[City].&amp;[Alexandria]&amp;[NSW]</MEMBER_UNIQUE_NAME> <MEMBER_TYPE>1</MEMBER_TYPE> <MEMBER_CAPTION>Alexandria</MEMBER_CAPTION> <CHILDREN_CARDINALITY>1</CHILDREN_CARDINALITY> <PARENT_LEVEL>2</PARENT_LEVEL> <PARENT_UNIQUE_NAME>[Customer].[Customer Geography].[State-Province].&amp;[NSW]&amp;[AU]</PARENT_UNIQUE_NAME> <PARENT_COUNT>1</PARENT_COUNT> <IS_PLACEHOLDERMEMBER>false</IS_PLACEHOLDERMEMBER> <IS_DATAMEMBER>false</IS_DATAMEMBER> </li></ol>

Keywords: kbtshoot kbprb KB915855

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.