Drilling on hierarchies on MDX cube reports

You can drill on hierarchies included on your MDX cube reports using most of the standard techniques available for drilling on attributes in MicroStrategy reports.

MicroStrategy recommends the following best practices for drilling on hierarchies in MDX cube reports:

• Drilling up to a higher-level attribute in a hierarchy is disabled. This is because the highest level attribute is always included on the report since hierarchies must display attributes sequentially from the highest level attribute down to the lowest level defined for the hierarchy.

• You can drill down from a hierarchy to any attribute within the hierarchy not already included on the report.

• You can drill from a hierarchy to attributes within different hierarchies as long as the hierarchy is in a different dimension. This is a requirement of SAP BW's definition of hierarchies and dimensions, which affects what hierarchies can be included on the same report.

• If you choose to keep the hierarchy on the report you drill to, the hierarchy object is replaced with the attribute objects that were displayed for the hierarchy in the original report. For example, consider an MDX cube report that includes a Geography hierarchy with the attributes Country, Region, and City. In this example your original report includes Country and Region as part of the Geography hierarchy.
  
  
  
  When you drill down to City and select to keep the hierarchy on the report you drill to, the Geography hierarchy is replaced with the Country and Region attributes that were displayed on the original report, as shown below.
  
  
  Since the attributes are included in the drilled to report, you can then use them individually as you can use any attributes on reports. For example you can pivot them on the grid, or move them to the page-by area.