Inheriting subtotals and defining join type

You can determine whether a subtotal in the original report is displayed in the destination report (after the drill). By default, whether the subtotal is kept is determined by the drill path.

You can select the attributes that appear in the destination reports while drilling, as well as specify the join types for these attributes. The join type defines how the attributes in the destination reports are joined, and thus it affects how data is calculated on the drilled-to report. For details and examples showing how attribute joins affect report results, see the Advanced Reporting Guide.

These options must be set using MicroStrategy Developer.

To inherit subtotals and define join type when drilling

In MicroStrategy Developer, open the document in the Document Editor.
Double-click the Grid/Graph to enter Edit mode.
From the Data menu, select Grid Data Options.
On the left, expand General and select Drilling.
Select the Enable report drilling check box.
The Inherit subtotals from parent option determines whether the subtotal is inherited from the original report. Select one of the following:
- Default: Whether the subtotal is inherited from the parent is determined by the drill path.
- Yes: Inherits the subtotal from the parent report unless all of the following are true:
  - The subtotals are calculated by group.
  - The object being drilled from is the same as the group being subtotaled.
  - The Keep parent while drilling option is not selected.
Setting the join type allows you to place conditions on the data selected for display in the report. An inner join includes only the data common to all the elements in the join, whether that data is tables or metrics. An outer join includes all of the data in all of the elements.

To select the attributes that appear in the destination reports while drilling, and to specify the join types for these attributes, click Drill Attributes Join Type. For details, click Help.
Click OK to save your changes and return to the document.