Monday, July 30, 2012 11:09 PM
I am working on a BIDS SSIS solution to perform a process incremental update to three partition in our cube (running in SQL Server 2008 R2). I have already performed successfully two of the incremental updates the third one is displaying the following error:"[Analysis Services Execute DDL Task] Error: OLE DB error: OLE DB or ODBC error: The multi-part identifier "dbo.TransactionsHistory.MerchantProcessorId_FK" could not be bound.; 42000; The multi-part identifier "dbo.TransactionsHistory.TerminalNumber" could not be bound.; 42000."
I have a Analysis services processing Task that is performing a process incremental on a partition called TransactionHistory. I am using the following query to update the fact table:
SELECT A.TransactionHistoryId, A.ProcessedFileId_FK, A.MerchantProcessorId_FK, A.InstitutionId_FK, A.PaymentMethodId_FK, A.BankMerchantNumber, A.MerchantZipcode, A.LottoNumberPrefix, A.LotteryNumber,
A.LotteryCalendarId_FK, A.LotteryParticipationNumber, A.TerminalNumber, A.TerminalBatchNumber, A.TransactionSequence, A.POSEntryModeId_FK, A.CardNumber, A.TransactionDateTime, A.TransactionAmount,
A.IVUTaxableAmount, A.StateTaxAmount, A.CityTaxAmount, A.AdditionalAmount, A.AdditionalAmountTypeId_FK, A.AuthorizationCode, A.MerchantCategoryCode, A.IsBuyerMerchant, A.BuyerExemptInd,
A.TransactionTypeId_FK, A.ControlNumber, A.TraceNumber, A.ReceivingDFIIdentification, A.DFIAccountNumber, A.ConfirmationNumber, A.TaxPeriodEndDate, A.TaxAmount, A.VerificationCode,
A.ConfirmationDateTime, A.VirtualTerminalChannel, A.ErrorLevel, A.ErrorNotes
FROM dbo.TransactionsHistory AS A INNER JOIN
dbo.ProcessedFile AS B ON A.ProcessedFileId_FK = B.ProcessedFileID
WHERE (CAST(FLOOR(CAST(B.ProcessedDate AS float)) AS datetime) = DATEADD(day, - 1, CAST(FLOOR(CAST(GETDATE() AS float)) AS datetime)))
The idea is to load into the fact table, every record that was processed the day before. Similar queries have been used on the other two partitions and they are working fine.I believed that this is probably cause by something on the query above. I have done some reseaerch on this with no luck
I will appreciate your help on this matter.
Tuesday, July 31, 2012 12:14 AMModerator
are you sure that you didn't had structural changes in underlying database where cube data populated from?
and this question is much more related to SSAS forum here:http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/threads/