SAP Knowledge Base Article - Preview

1700823 - Why connectivity of the OLAP connection to the SQL Server Analysis cubes has been changed to XMLA from ODBO in BI4.0

Symptom

Not able to connect to the SQL Server Analysis cube by providing the machine name of the SQL Server while creating the OLAP connection in BI4.0.

  • Error: "Failed to get connections for connection [servername] using session locale [English]".


Read more...

Environment

  • SQL Server 2005/2008/2012
  • SAP BusinessObjects Business Intelligence Platform BI4.0
  • SAP BusinessObjects Business Intelligence Platform BI4.1
  • SAP BusinessObjects Business Intelligence Platform BI4.2

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2

Keywords

xml, ole de, odbo, olap connection, connectivity, sql server analysis, cube, 4.0, AOLAP, A-OLAP, OLAP, Advanced Analysis for OLAP, BI, 4.0, 4.1, 4.2, 40, 41, 42, BI4.0, BI4.1, BI4.2, BI40, BI41, BI42, MDAS, multidimensional analysis services, MSAS, Microsoft Analysis Services, XMLA, datapump, data pump, ADO OLEDB, SSAS, IIS , KBA , BI-RA-MD , OLAP Intelligence, multidimensional databases , 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.