MicroStrategy 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 MicroStrategy environment.
-
Characteristic structures, which are represented as a single, flat dimension with one level mapped to a unique attribute in the MicroStrategy environment. This representation is consistent with how characteristic variables are represented in SAP BW through the OLAP Business Application Programming Interface (BAPI).
In a MicroStrategy MDX cube report, you cannot drill down into the elements of characteristic structures.
When characteristic structures are imported into MicroStrategy as attributes, the structure element orders are preserved. This maintains a consistent view of your data across your SAP BW MDX cube source and MicroStrategy. Once imported into MicroStrategy, 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 MicroStrategy can also affect the value formats of metrics on MDX cube reports. For information on how you can specify that the metric values in MicroStrategy MDX cube reports inherit value formats from an MDX cube source, see Inheriting MDX Cube Source Formats for Metric Values.