How To use Dimension Editor

Link to the video

Under this link you will find video that shows how to use Dimension Editor. Read more about dimensions here.

Step by step

1. In the Solution Explorer, right-click a Folder and choose “Add Item”, then choose “Dimension” from the list:

2. Provide a name for the Key Field. The Key Field specifies the name of the column at the leaf (lowest) level of the wide table, optionally choose language for translations:

3. Add Properties (this step is optional):

4. Check the “Primary Dimension” in the toolbar and save changes In the Designer:

5. In the Toolbox, choose the Resources tab and drag/drop the Dimension Editor onto a page:

6. Open the Workbook and choose a dimension from the list of available ones:

7. You can either import multiple members at the same time or add a new member:

8. Paste data:

9. To organize dimension members in a hierarchical structure, drag/drop nodes between levels:

10. Save and publish: