Strategy ONE
Supporting SAP BW Structures
Structures in an SAP BW query cube define the two axes of a query (rows and columns). The two types of SAP BW structures are:
- Key figure structures, which are mapped to unique metrics in the Strategy environment.
-
Characteristic structures, which are represented as a single, flat dimension with one level mapped to a unique attribute in the Strategy environment. This representation is consistent with how characteristic variables are represented in SAP BW through the OLAP Business Application Programming Interface (BAPI).
In a Strategy MDX cube report, you cannot drill down into the elements of characteristic structures.
When characteristic structures are imported into Strategy as attributes, the structure element orders are preserved. This maintains a consistent view of your data across your SAP BW MDX cube source and Strategy. Once imported into Strategy, you can sort reports based on the structure element order. For information on sorting reports on structure element orders, see Sorting Structure Elements and Preserving Order.
Characteristic structures imported as attributes in Strategy can also affect the value formats of metrics on MDX cube reports. For information on how you can specify that the metric values in Strategy MDX cube reports inherit value formats from an MDX cube source, see Inheriting MDX Cube Source Formats for Metric Values.