SSAS Dimension Settings

• rka

  SSCommitted

  Points: 1599

  More actions

  February 15, 2012 at 7:39 am

  #253096

  I have a table with Data as

  EmployeeID EmployeeType Department

  1 Permanent HR

  2 Permanent Sales

  3 Permanent Marketing

  4 Part-Time Customer Services

  5 Permanent Finance

  When I create EmployeeType dimension, I set the attribute for Key as EmployeeID and Name as EmployeeType. But I get the results for the dimension as:

  Permanent

  Permanent

  Permanent

  Part-Time

  Permanent

  This is occurring because I have used the Key as EmployeeID instead of EmployeeType. I can always go back and change the Key column to be EmployeeType and Name column to be EmployeeType.

  But, is there any other way of removing the duplicate attribute values by configuring the settings and still able to optimize the dimension (Note: primary Key is on the EmployeeID column)

• Koen Verbeeck

  SSC Guru

  Points: 259015

  More actions

  February 16, 2012 at 12:13 am

  #1447678

  So you want a dimension just about EmployeeType?

  Then indeed set the key to EmployeeType and the name also.

  Discard the rest - EmployeeID and Department - as they have a lower grain then the dimension you want to create.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP