Create Dimensions HELP ME

• Victor-230790

  SSC-Addicted

  Points: 474

  More actions

  May 5, 2005 at 11:30 am

  #164200

  I CREATE A DIMENSION on Microsoft SQL Server 2000 Analysis Services BUT IT SHOW TO ME A MESSAGE OF ERROR:

  Analysis Server Error: Surpassed the maximum of 64,000 secondary elements of member of dimension for a single primary element.

  WHAT I CAN DO, HELP ME, IS A EMERGENCY. THANKS

• mdaniel

  SSCarpal Tunnel

  Points: 4616

  More actions

  May 5, 2005 at 2:14 pm

  #557223

  That's a limitation of AS, you can redesign the dimension by making groups of data.

  Also, you can set the GROUPING setting of each level to Automatic, this will cause AS to group the members whenever it surpasses the limit.