We have used Adventure Works DW 2005 database and now we want to update Adventure Works DW 2008 database to the BIDS current project. But there is some problem in the cube TIME and DATE dimensions. Please suggest.
The problem we are facing:
Error 64 OLE DB error: OLE DB or ODBC error: Invalid object name 'dbo.DimTime'.; 42S02. 0 0
PřesunutýAaron AltonModerator30. dubna 2009 4:28AWDW Question (From:Getting started with SQL Server)
Howdy, Sanjana. I'm not sure I follow what you're trying to do. The 2005 cube design is NOT compatible with the 2008 data warehouse; you need to use the 2008 cube design.David Reed - MSFT - Microsoft Certified Architect|SQL Server - http://blogs.msdn.com/reedme/