looking for solution to the following problem encountered with MS SSAS 2005
using Adventure Works sample database and RowsetViewer:

- Connect to SSAS Server, Catalog Adventure Works DW;
- Press Ctrl-S or select Session->IDBSchemaRowset->GetRowset
- In IDBSchemaRowset dialog choose MDSCHEMA_MEMBERS from the pull-down list
- Enter restrictions:
Adventure Works for CUBE_NAME
[Geography].[Geography].[City] for LEVEL_UNIQUE_NAME
Columbus for MEMBER_CAPTION (or MEMBER_NAME)

Only one row is returned in the MDSCHEMA_MEMBERS Rowset (the one with
MEMBER_UNIQUE_NAME
[Geography].[Geography].[City].&[Columbus]&[GA]).

However, there are two members with the caption (or name) Columbus on
[Geography].[Geography].[City] level. Their unique names are:
[Geography].[Geography].[City].&[Columbus]&[GA]
and
[Geography].[Geography].[City].&[Columbus]&[OH]

Two rows (one for each of the above members) should be returned.