I am defining a Chart of Accounts for General Ledger in MS AS 2000 as a
Star Schema dimension. The hierarchy can be 8 levels deep therefore my
raw dimension table has 8 fields (level0name, level1name, ...,
level7name). The hierarchy is ragged so I have set "Hide Member If" to
"No Name" for all 8 levels. Only leaf-level members have account
numbers, all other members are parent members that are only there to
facilitate the hierarchy for grouping and reporting. The account
number is a member property of all levels.

Here is my problem: The account number member property should be NULL
(AS puts a 0) for all parent/rollup-levels but some parent/rollups are
picking up the LAST child of their family.

simplified example
Acct Level0 Level1 Level2
123 "Profit" "Sales" "Acct 123"
456 "Profit" "Sales" "Acct 456"
"Profit" "Sales"
777 "Profit" "Expenses" "Acct 777"
888 "Profit" "Expenses" "Acct 888"
"Profit" "Expenses"
"Profit"

The parent member "Sales" is showing up with member property Acct of
456 and "Expenses" with 888. The member property for these parent
levels should be NULL.

Any thoughts as to why? This is not happening for all parents, only
some. Thanks in advance for your help. Please let me know if you need
further explanation to help me.

Regards,
Sean