SSAS : Date dimension issue with future years

• oussama.dinia

  Old Hand

  Points: 306

  More actions

  January 6, 2015 at 2:04 am

  #314325

  Hello,

  The issue is wether to fill the date dimension with 5 years in advance can be an issue for the queries.

  In fact, the previous team on the project, processes the date dimension everytime we add data, in order to add only dates for which we have data.

  This works, but for the case of the new year, it is an issue. In the business logic, we have to manage the absence of data for 2015 as an error, since the year has not been processed yet.

  I hope this is clear.

  to make sure my question is simple : Can I add the next five years to the date dimension; will there be any related integrity or performance issues ?

  Thanks

  Oussama Dinia
  .NET Solutions Architect
  http://devmeetsbi.ghost.io/
  http://www.devmeetsbi.io/catalog/3079

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  January 6, 2015 at 2:21 am

  #1767999

  There won't be performance issues. It's about 1500 extra rows. I think SSAS can handle it.

  The only thing is that in Excel you have now more years to choose from in filters.

  I think slicers will not display the years for which there is no data.

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

• oussama.dinia

  Old Hand

  Points: 306

  More actions

  January 6, 2015 at 3:13 am

  #1768011

  Perfect, thanks.

  We are actually testing this today.

  We do not use Excel for this project, We use adomd.net with C# and asp.net.

  I will update the thread with additional information on the resolution.

  Thanks again.

  Oussama Dinia
  .NET Solutions Architect
  http://devmeetsbi.ghost.io/
  http://www.devmeetsbi.io/catalog/3079