Guidelines for Working with SAP BW Data for Use in Transformer

Starting with Transformer version 8.4, you can use Framework Manager packages published to Content Manager to leverage your SAP BW data. The SAP-based packages can be used as data sources to create Transformer models. As result, Transformer PowerCubes can be used as high speed data access cache methods for distributing smaller or focused areas of your business information. This is the recommended method for leveraging your SAP BW data.

There are special considerations when using SAP-based packages created in Framework Manager. For detailed information about creating your SAP queries, creating the SAP-based packages in Framework Manager and using them in Transformer, see the section about working with SAP BW data using a package in Framework Manager. For general information about creating packages in Framework Manager, see "Create or Modify a Package" in the IBM Cognos Framework Manager User Guide.

Transformer versions 7.x, 8.1, 8.2 and 8.3

In Transformer versions 7.x, 8.1, and 8.2, you can leverage your SAP BW data using a Framework Manager package in which the query subjects and dimensions are externalized using CSV files. Transformer can use the CSV files as a data source to create a model and generate PowerCubes. This method should only be used in a IBM® Cognos® environment when you want to leverage data in IBM Cognos Analytics to build PowerCubes for IBM Cognos Analytics.

In Transformer version 8.3, use published packages for dimensions and use CSV files for facts.

There are special considerations when using externalized CSV files with SAP data in Framework Manager. For more information, see Working with SAP BW Data Using Externalized CSV Files in Framework Manager. For general information about externalizing query subjects and dimensions using the CSV method, see "Externalizing Query Subjects and Dimensions" in the Framework Manager User Guide.