Skip to main content

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.

  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 Expression 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 Arrow down 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 Show options 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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!