Creating a drill-down dimension

When adding a dimension, you can select between creating a single or a drill-down dimension.

The following description explains how to create a drill-down group from the Create new dimensions dialog.

Do the following:

1. Select Drill-down as dimension type.

2. Click at least two fields from the fields list on the left-hand side to insert them as the referenced fields.

   Tip noteYou can filter which table to select fields from in the drop-down list.
   Tip noteYou can rearrange the order of the fields you have selected by dragging them to new positions in the list of selected fields.

3. Optionally, add labels for the fields added to your drill-down dimension.

   Click in Label to add an expression for the label. The expression must start with =.

4. Type a name for the dimension.

5. Type a description for the dimension (optional).

   If you do not add a description and then link a glossary term to your master item as a definition, the term definition will be used in the description.

6. If you want to specify a color, click in the color drop down and select a color through one of the following methods:

   • Click one of the colors in the palette.
   • Type a 6 character color code in the Hex input field: #.
   • Click at the bottom of the dialog, select a color in the color wheel, and optionally adjust the saturation slider.

7. Add tags (optional).

8. Optionally, if you have access to a glossary, link the dimension to a glossary term.

   Linking terms to master items

9. Click Create.

10. Click Close.

The drill-down dimension is now saved in the Dimensions category among the master items.

When you click the dimension in the panel on the left-hand side, the preview displays the dimension type and which fields are included in the drill-down dimension.