Creating a cyclic dimension

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

The following description explains how to create a cyclic dimension from the Create new dimensions dialog.

Do the following:

1. Select Cyclic 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 cyclic 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. If a custom logical model is activated for the app, optionally select the Logical model group to which the master dimension will be added. If you do not select a group, the master dimension is ungrouped and therefore cannot be used in Insight Advisor interactions by any user. You can later select or change the group when editing the master dimension, or by editing the logical model of the app.

   Defining fields and groups

10. Click Create.

11. Click Close.