Guidelines for Working
with SAP BW Data for Use in TransformerIn 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 Work 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 Framework Manager User Guide.
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 8 environment when you want to
leverage data in IBM Cognos 8 to build PowerCubes for IBM
Cognos 8.
Note: IQD files generated by Framework Manager will
continue to be supported in this IBM Cognos 8 release,
but will not be enhanced. Support for IQD files will remain until
the end-of-life of Transformer version 7.x.
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.
