Migrating cubes

  • 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.


  • 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]

  • Was this resolved?

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply