Importing Cube SQL2000 to SQL 2005

• Tiago Rente

  Default port

  Points: 1403

  More actions

  September 23, 2004 at 9:57 am

  #162819

  Hi,

  Does any one successfully imported a cube from SQL 2000 to SQL 2005?

  I tried but the Cube needed to be re-processed. When I process the cube the Dimensions do not process because there were some sintax errors.

  Any help is welcomed.

  Thanks in advance.

• jimcush

  Grasshopper

  Points: 13

  More actions

  February 28, 2005 at 9:36 am

  #544453

  I am trying to do this as well - Can anyone give some insight?

• Gary Billins

  SSC-Addicted

  Points: 454

  More actions

  January 19, 2006 at 11:21 am

  #615883

  I am experiencing the same issue. How did you resolve your

  problem.

   

  I use the wizard to validate and migrate the cubes to 2005.

  When I attempt to reprocess some of the cubes I notice

  that the SQL Statement that extracts the information from the fact

  table has changed. It has some new columns called

  TImeid 1 and  Store Id 1 which do not exist.

  Please advise

  Thanks