Running a Report Against a Dimensional Data Source
The same behavior applies to SAP BW data sources.
In IBM® Cognos Framework Manager, you can also control the number of levels within a hierarchy from which members, or values, are extracted from the hierarchy to populate a tree prompt.
For SAP BW, you can reduce
the number of hierarchy levels to limit the number of nodes by setting
the SAP BW variable property trimHierarchyLevels
to
1. This removes the lowest level from the hierarchy prior to creating
the list of nodes.
Units of Measure Notation
When running a report against an SAP BW data source, units of measure are included in the same column as the data values, separated by one space. For example, Celsius and Fahrenheit notations are appended to the end of the value.
If you see an asterisk character (*), one of the following was detected:
- an unknown currency
- a value with an unknown or questionable unit of measure, such as a mixed currency calculation or
rollup
Mixed currency values occur when you calculate values with different currencies.
This behavior occurs when you are using an IBM Cognos cube as a data source.
This behavior also occurs for SAP BW data sources.
Unsupported SAP Variable Properties
The following SAP variable properties are not supported:
- Exclusionary ranges appear as an inclusionary prompt.
- Mandatory not initial appears as a mandatory prompt.
When using Business Explorer (BEx) to define variables in your SAP data source, avoid using exclusionary ranges and the mandatory not initial property.