MicroStrategy ONE

Report Data Options dialog box: Drilling: Drill Attributes Join Type dialog box

The Drill Attributes Join Type dialog box allows you to select the attributes that appear in the destination reports while drilling. Additionally, you can specify the join types for these attributes.

In the Available attributes drop-down list, the Attributes folder is displayed as the default folder. The Attributes folder includes attribute sub folders that are available in the project. These subfolders are displayed in the column below the Available Attributes drop-down list. You can navigate through the attributes subfolder tree to select the required attribute. Select the attribute from theAvailable attributeslist and click to move it to theSelected attributeslist.

To select multiple attributes, press the CTRL key or Shift key while clicking to select the attributes.

The Drill Attributes Join Type dialog box allows you to add only attributes to the Selected attributes list.

You can specify the join type for the selected attribute in the Selected attributes list. Click in the Join Type column corresponding to an attribute and select the join type as an inner join or an outer join.

The Find box lets you find an attribute in the list. Type the first few letters of the attribute name and click the Filter button to the right of the box. The list displays attributes whose names begin with these letters.