Dimension time outs in cube and excel | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Dimension time outs in cube and excel

I have a dimension table to stores account names. I had to create a group level because it over 200,000 members. I need to know what to do to overcome the performance issue with this dimension. Can you setup multiple group levels for Account number to help with performance?
Hi,
Even we had the similar kind of dimension.
For performance we used the autmatic grouping and partitioning the cubes where we used that dimension.
]]>