I have a Account Name dimension that groups Account Names. There over 200,000
account names, hence, the grouping.

I created a view with indexed to help with pulling the account names but I
don't see a difference. It time out both in the Cube and Excel Pivot table
when I added the Account Name dimension. If I am successful in adding the
dimension to the data area, it times out when I click the drop down menu to
choose one.

Any suggestions to improve the performance of this dimension? I also set Top
level only in the dimension settings but no change.