Creating Sections on Reports That Access SAP BW Data Sources

SAP BW data sources may have problems with sections in reports under different circumstances:

If a section in a report uses the lowest-level query item in a ragged hierarchy, such as the children of the not assigned node, the following BAPI error may appear:

BAPI error occurred in function module BAPI_MDDATASET_SELECT_DATA. Value <valueName> for characteristic <cubeName> unknown

Lowest-level Query Item in a Ragged Hierarchy

The solution is to remove the section from the lowest-level query item.

Several Multicubes with SAP Variables

The solution is to use one SAP multicube when creating sections in reports.