November 16, 2006 at 10:53 am
im in the process of testing how to upgrade from analysis server 2000 to analysis server 2005. i have migrated my cubes to a test 2005 server and created a project out of them. when i try to deploy this project i get these two errors:
Error 1 OLE DB error: OLE DB or ODBC error: The multi-part identifier "PrintDimensionTransactionDate.TransactionDate" could not be bound.; 42000. 0 0
Error 2 Errors in the OLAP storage engine: An error occurred while processing the 'Print' partition of the 'Print' measure group for the 'Print' cube from the testSRDBProj database. 0 0
these cubes worked fine before i migrated them. does anyone know what could be going wrong?
November 17, 2006 at 8:21 am
Was PrintDimensionTransactionDate a dimension with multiple hierarchies in 2000? In 2005, these will most likely be migrated as separate dimensions, and post-migration, the 2 part name used in 2000 will be invalid. You will need to edit references to the 2 part name in calculated measures and members (and partitions).
Is the PrintDimensionTransactionDate dimension used to define partitions in the 'Print' cube? If so, and it was a dimension with multiple hierarchies, you will need to change the definition of the partition, per my answer above.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply