problems limiting the amount of data in my cube

• winston Smith

  SSCoach

  Points: 19500

  More actions

  June 14, 2006 at 2:53 am

  #153040

  ive been trying to limit the amount of data getting into my cube from the database.

  in cube editor, in advanced properties, in source table filter i placed this query:

  "InvoiceData"."InvoiceCreatedDate" between '2005-01-01 00:00:00.000' and GetDate()

  i keep getting an error though and my cube isnt processed. anyone see whats wrong?

  i not sure if  it makes any difference but in the InvoiceCreatedDate column, there are

  not all date entries, there are some nulls, could this cause the problems?

   

  im not in anyway an expert on analysis services. i just am using a system i inherited from a previous employee in my place of work

• jsqldba

  SSChampion

  Points: 11257

  More actions

  June 16, 2006 at 7:03 am

  #644238

  use a view as your source table and put the filter in the where clause.