I was running SQL 2000 Standard with the Analysis Services
repository in a SQL database.
I upgraded SQL to Enterprise. When a user tried to create
a partitioned cube he got: user-defined partitions are
available only if you install Analysis Services SQL Server
2000 Enterprise Edition
I "upgraded" to Analysis Services Enterprise - actually
all it did was reinstall. Since I had already migrated
the repository to SQL, my cubes did not exist.
Here is probably where my mistake occurred: I "re-
migraded" the repository to SQL ... my cubes are still not
there.
I have since restored the repository database from a pre-
upgraded Analysis Services version ... my cubes are still
not there.
I have a large project that is waiting for these cubes.
Please tell me I have a chance of getting these cubes back!
Does anyone have any suggestiongs?
TIA
WadeIf you were using SQL Database A as repository before upgrading and
migrating repsitory to SQL Database B after upgrading, then restore the
backup to Database A won't help. You need to edit the repository connection
string so it points to the database holds the right meta data for OLAP.
Thanks
Wei Zhang
Microsoft OLAP Support
No comments:
Post a Comment