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:
-
Select Cyclic as dimension type.
-
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. -
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 =.
-
Type a name for the dimension.
-
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.
-
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.
-
Add tags (optional).
-
Optionally, if you have access to a glossary, link the dimension to a glossary term.
- Click Create.
-
Click Close.