SAP Knowledge Base Article - Preview

1797857 - Reporting Data Transformation Process fails with Errors in the OLAP Engine: The attribute key cannot be found in table dbo.xxxxxx


Image/Data is from SAP internal systems, sample data, or demo systems.  Any resemblance to real data is purely coincidental.

  • During the DTE (Data Transformation job) sometimes the jobs fail for multiple reasons
  • Some errors relate to how MS Analysis Services Environment handles the names of key attributes related  to QueueName, QueueTechincalName, DimSecondaryQueue or AgentName
  • The above causes the data processing to the OLAP database to fail and therefore no data for that period is available in the Online Reporting



SAP Contact Center 7.0


SAP Business Communications Management 5.5 ; SAP Business Communications Management 6.0 ; SAP Contact Center, on-premise edition 7.0


OLAP Update, BCM Reporting, DTE Job Failed, Step 10, Step 2, SAP Contact Center, BCM, Online Reporting , KBA , CRM-CCI , Contact Center Infrastructure , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.