show distinct Dimension Attribute for Date

• hpjack433

  Grasshopper

  Points: 18

  More actions

  August 28, 2014 at 10:41 am

  #145218

  Current Level

  - All

  April

  April

  April

  May

  May

  May

  June

  June

  June

  so on.....

  How do i make sure to show only distinct dimension attribute values for the Date dimension?

• PB_BI

  SSCoach

  Points: 17463

  More actions

  August 29, 2014 at 4:35 am

  #1741842

  You need to set appropriate attribute relationships and composite keys for your attributes. More here http://www.databasejournal.com/features/mssql/article.php/3792761/Introduction-to-Attribute-Relationships-in-MSSQL-Server-Analysis-Services.htm

  ---

  I'm on LinkedIn