Same Member in Multiple Hierarchies

OLE DB Programmer's Reference

The MEMBERS rowset has two columns that indicate the member's position in the hierarchy: LEVEL_UNIQUE_NAME and LEVEL_NUMBER. However, it is possible for the same member to belong to more than one hierarchy. OLE DB for OLAP requires the MEMBERS rowset to contain a row for each occurrence of a member in a different hierarchy. For example, if the member "January" belongs to two different hierarchies, Quarters and Months, the MEMBERS rowset has two rows, for which MEMBER_UNIQUE_NAME is "January.Quarters" and "January.Months." Because the member name "January" has been qualified here, to make it unique compared to the hierarchy name, the MEMBER_CAPTION for both rows will be the same.

1998-2001 Microsoft Corporation. All rights reserved.