SQL Server Performance

Dimension time outs in cube and excel

Discussion in 'Analysis Services/Data Warehousing' started by samcneal, Jun 9, 2006.

  1. samcneal New Member

    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?
  2. ranjitjain New Member

    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.

Share This Page