Introduction

The SAP BPC NetWeaver HANA connector uses SAP .NET Connector which the SAP HANA Data Provider for Microsoft ADO.NET which creates a direct connection to the a SAP BPC NetWeaver HANA cube. The following architecture picture shows the system components:Image Removed

Image Added

MDX

This connector generates internally MDX queries to retrieve the data from SAP BPC NetWeaver, which are translated into ABAP function callsHANA. Read more on MDX trouble shooting here: Turn on MDX Logging to investigate data or performance issues

Connectivity

The connection to SAP BPC NetWeaver HANA is managed in the /wiki/spaces/CXO/pages/2806776143 specify the following fields:

Image RemovedImage Added

• ServerHana server / SystemNumberrport: the IP address or the server name of the NetWeaver HANA server and the open port from the range 3300-3399.

• Client: The client number

• Cube: The technical name of the SAP BPC NetWeaver cube
• Username & Password: The name and password of the user on SAP BPC NetWeaver system.port. /54 refers to port 35415.
• Schema: the Schema on the HANA server where the proper OLAP Views are stored
• Cube: the Cube-name
• Username: HANA db user authorized to access the Cube
• Password: the password for this user

Use the check button to check if the connection can be made.

it is also possible to connect to a BW Message Server. This enables load-balancing of sessions which prevents queuing of MDX-queries in case of a high load of reporting requests.
Image Removed

Configure CXO

to run on SAP

HANA

In order to successfully run CXO -Cockpit on an SAP BPC NetWeaver HANA application the following additional configuration is required.

• Dimension Mapping: all of the CXO Core Dimensions need to be mapped
• Sometimes it is required to use Dimension Splits in order to get all required dimensions. Specify dimension splits first then map the dimensions.
• Set the Period Frequencies table
• Correct any Dimension Variable errors

Installation Prerequisites

You can find the Installation Prerequisites file for SAP BPC NetWeaver in this article.

See also