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?
Hi Winston,
It looks like it has deployed the cube, but is failing in processing it. Is there a table called PrintDimensionTransactionDate with a column of TransactionDate? This doesn't sound right. Also when processing the cube you can get the SQL query that Analysis Services is using, that may lend a clue to what is wrong with this Dimension or measure group.
David
|||yea, there is a table called printdimensionTransactionDate and there is a column called transactiondate. the table contains the full date, and also a break down of the date ( i.e fiscal month num of the date, fiscal week num of the date, etc). how do you get the query? is that by right clicking the error in the processing window? if that is the case, then it shows no SQL , just the error messages i specified previously.|||the sql that is causing the error is shown below. is it possible to edit this sql in business intelligence development studio?if not, then where is it stored?
SELECT [dbo_PrintFactData].[Total] AS [dbo_PrintFactDataTotal0_0],[dbo_PrintFactData].[InvoiceVolume] AS [dbo_PrintFactDataInvoiceVolume0_1],[dbo_PrintFactData].[CountryDimensionID] AS [dbo_PrintFactDataCountryDimensionID0_2],[dbo_PrintFactData].[CurrencyDimensionID] AS [dbo_PrintFactDataCurrencyDimensionID0_3],[dbo_PrintFactData].[CustomerDimensionID] AS [dbo_PrintFactDataCustomerDimensionID0_4],[dbo_PrintFactData].[EngagementNameDimensionID] AS [dbo_PrintFactDataEngagementNameDimensionID0_5],[dbo_PrintFactData].[InvoiceNumberDimensionID] AS [dbo_PrintFactDataInvoiceNumberDimensionID0_6],[dbo_PrintFactData].[PONumberDimensionID] AS [dbo_PrintFactDataPONumberDimensionID0_7],[dbo_PrintFactData].[ReportDimensionID] AS [dbo_PrintFactDataReportDimensionID0_8],[dbo_PrintFactData].[SAPMessageDimensionID] AS [dbo_PrintFactDataSAPMessageDimensionID0_9],[dbo_PrintFactData].[SystemTypeDimensionID] AS [dbo_PrintFactDataSystemTypeDimensionID0_10],[dbo_PrintFactData].[TransactionDateDimensionID] AS [dbo_PrintFactDataTransactionDateDimensionID0_11],[dbo_PrintFactData].[CaseDimensionID] AS [dbo_PrintFactDataCaseDimensionID0_12],[dbo_PrintFactData].[ContractDimensionID] AS [dbo_PrintFactDataContractDimensionID0_13],[dbo_PrintFactData].[ResolutionTypeDimensionID] AS [dbo_PrintFactDataResolutionTypeDimensionID0_14]
FROM
(
SELECT "Total", "InvoiceVolume", "CountryDimensionID", "ResolutionTypeDimensionID", "ContractDimensionID", "CaseDimensionID", "TransactionDateDimensionID", "SystemTypeDimensionID", "SAPMessageDimensionID", "ReportDimensionID", "PONumberDimensionID", "InvoiceNumberDimensionID", "EngagementNameDimensionID", "CustomerDimensionID", "CurrencyDimensionID" FROM "dbo"."PrintFactData" WHERE "PrintDimensionTransactionDate"."TransactionDate" >= '1/1/2004' --problem here, table printdimensiontransactiondate not mentioned in query before this
)
AS [dbo_PrintFactData]
