Guidelines and Constraints When Working with SAP BW Cubes

You must use CSV files when importing metadata from SAP BW cubes. For performance reasons, we recommend that you filter on geography, time periods, or some other dimension that limits the amount of data retrieved. Remember to apply your dimension filter to the related dimensions and their fact tables (measures).

For more information, see "Create a Filter" in the Framework Manager User Guide.

Because SAP BW cubes are multidimensional, rollups are applied at the source. If you change the rollup type after importing the data into Cognos® Transformer, your results will not be valid.

Missing data or metadata that is out-of-scope for a particular measure may yield different results, depending on the context. You may see:

NULL values
# symbols
REST_H
Not assigned

Because such duplicate tokens can cause problems in Cognos Transformer, in unique levels for example, we recommend that you assign filters to the dimension so that they do not appear in the imported data.

Finally, remember to select only those query items needed to generate your filtered data.