MicroStrategy ONE

Using drilling on MDX cube reports

You can drill in reports to obtain additional information after a report has been executed. For MDX cube reports, drilling is supported within the MDX cube. This means that you can drill up or down within the dimension that the attribute belongs to, as well as in other directions to dimensions included in the same MDX cube.

When you drill on attributes that are part of the relational project schema, drill paths enable you to drill up and down to other attributes that are part of the same hierarchy. The up and down drill paths are based on the system hierarchy.

In MDX cube reports, you can drill across from any attribute to any other attribute available in the MDX cube, but up and down drill paths may not be available. The drill paths available in MDX cube reports are determined by whether attributes are mapped directly to characteristics, or whether attributes are mapped to attributes that are part of a hierarchy.

If your report uses an SAP BW MDX cube source, up and down drill paths for an attribute are only available for attributes mapped to levels of an SAP BW hierarchy. In SAP BW, hierarchies can be created to organize and logically relate a group of characteristic data (represented as attributes in MicroStrategy). When these hierarchies are imported into MicroStrategy, up and down drill paths are created for the hierarchy's attributes.

For examples and further explanation of how you can use drilling on MDX cube reports, see the MDX Cube Reporting Help.

  • Drill paths are automatically generated based on the definition of the MDX cube. For information and best practices for drilling on hierarchies on MDX cube reports, see Drilling on hierarchies on MDX cube reports.

  • You cannot drill down into the elements of SAP BW structures. For more information on structures, see Sorting structure elements and preserving order.

  • When you run an MDX cube report in MicroStrategy Web, it is recommended that you use the sub-menu display option to view your drilling options in MDX cube reports. This option allows you to drill in other directions to all available hierarchies within the MDX cube rather than only allowing you to drill up and down within the current hierarchy. For steps to display all available hierarchies as drilling options in MicroStrategy Web, refer to the MicroStrategy Web Help.

Related Topics