David,

Thanks for the help!  It worked.  I now have a nice clean view of the hierarchy structrue I need.

Ed

David,

Thanks for the suggestion.  I will modify the dimension table and set it up that way.  But I understand what you're saying - essentially, because I have the account name...

As background, this is in SSAS 2005, and I am building and displaying thru BIDS.

As a general schematic of the dimension table:

GL_Account_Key   GL_Account_Name       GL_Rollup_1            GL_Rollup_2    GL_Rollup_3             GL_Rollup_4   ... GL_Rollup_8

101                      1001...