Table of Contents

How To use Dimension Editor

Under this link you will find video that shows how to use Dimension Editor. Here you will find Documentation.

Step by step

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

pic

  1. 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:

pic

  1. Add Properties (this step is optional):

pic

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

pic

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

pic

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

pic

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

pic

  1. Paste data:

pic

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

pic

  1. Save and publish:

pic