How to create connections in SAP BI 4.0
In this blog I want to share my knowlegde about “How to create connections with BI 4.0”. If you are interested in how to create a connection between SAP BW and SAP BusinessObjects BI 4.0, you must reed this article. A step-by-step guide can be downloaded!
In the mid of August 2011, BI 4.0 will be general available. I hope when BI 4.0 is available for every customer, you can start directly creating connections with this blog as reference.
When using SAP BW as a source system, the BICS connection is preferred by SAP. Other connections are possible, for example the JCO-connection. This connection can be used when you want to combine data from SAP BW and non-SAP. The JCO-connection connects directly on the SAP BW InfoProvider, BEx query’s are not allowed. SAP BusinessObjects will setup automatically the relational schema, this is called the data foundation layer.
The dimensional semantic layer can be used to access multidimensional databases, such as Microsoft Analysis Services or Hyperion (no Cognos!).
The relational single source layer can be used to access relational databases, for example Microsoft Access or MySQL.
Update 4 October 2012:
Note: If you want to use the BICS connection (via SAP NetWeaver platform ) in Dashboard Design and wants to publish the dashboard in the SAP BO 4.0 Enterprise Platform, there is one thing to know –> this doesn’t work! Since the release of FeaturePack 3, the BICS connection is supported via the SAP BusinessObjects 4.0 platform. From this release you’re able to bind your SAP BW query results directly to charts. To use this funciontality, you must first create your SAP BO query via the query browser on top of SAP BW.
Connections in BI 4.0 need to be created with the Information Design Tool, download the step-by-step manual to see how connections can be created with SAP BusinessObjects BI 4.0.