Migrating cubes

• Luas Barlassina

  Newbie

  Points: 3

  More actions

  January 15, 2004 at 5:50 am

  #177836

  Hi...

  I'm Lucas from Argentina, BI developer.

  Normally we develop on a dev server and then migrate the cubes to a prod server.

  I was testing META DATA Scripter, from the Resource KIT.

  1- Generate the script for a shared dimension

  2- Change the script parameters to new server and new databas.

  3- Run the script.

  All worked, but when I edit the dimension and select the data tab, an error appears. "The dimension is not Valid. All levels after a hidden level must have unique keys"

  But this dimension in the dev cube works.

   

• Robert Davis

  One Orange Chip

  Points: 28027

  More actions

  January 15, 2004 at 4:08 pm

  #490316

  So what are the differences between the two cubes?

  ---

  My blog: SQL Soldier[/url]
  SQL Server Best Practices: SQL Server Best Practices
  Twitter: @SQLSoldier
  My book: Pro SQL Server 2008 Mirroring[/url]
  Microsoft Certified Master: SQL Server, Data Platform MVP
  Database Engineer at BlueMountain Capital Management[/url]

• rpcasey001

  SSC Rookie

  Points: 31

  More actions

  September 22, 2009 at 3:02 pm

  #1057156

  Was this resolved?

  Ryan P. Casey • www.R-P-C-Group.com