Working with SAP BW Data Using a Package in Framework Manager

You can leverage SAP BW data in Cognos® Transformer by using an SAP-based package created in Framework Manager and published to Content Manager. This is the recommended method to leverage your SAP BW data. There are special considerations when using SAP-based packages created in Framework Manager.

  • This extract process is limited to SAP BW data sources only.
  • The data source must be a specifically constructed query defined in the SAP BW data source.

For general information about creating packages, see "Create or Modify a Package" in the Framework Manager User Guide.

Before you begin

You can use Cognos Transformer to import both dimensional and fact data from an SAP BW query source. The following instructions describe how to rebuild an SAP BW cube as an IBM® Cognos Transformer cube. To do so, the SAP BW query package must be in a specific format.

There are three stages to importing a SAP BW query to access both dimensions and facts using IBM Cognos Analytics: