Create a Dimension
Click the New Dimension button. You can create an unlimited number of dimensions.
Specify the dimension details. For more information, see Dimension Administration.
Once the dimension is created and saved, its values can be added. Select the dimension in the list, and click New Value. Dimension values can be created in hierarchies. However, dimensions with hierarchical values cannot be assigned dimension attributes.
To reorder a dimension value, click the dimension value to select it, then click again to drag and drop it to its new location in the tree. Dimension values, including parents, are listed on sheet drop-down menus and in the reporting elements in the order in which they appear in this screen.
Once a dimension and its values have been established, you can always add new values to an existing dimension in this screen. Repeat step 4 above to add new values to an existing dimension.
Create a Dimension Value
Click a dimension or dimension value with the same parent the new value should have.
Click New Value in the toolbar above the dimension tree.
Enter the value's details:
Parent: Selects the dimension value in this dimension to which this value rolls up. The default is the parent value of the last value created.
Name: Give the value a descriptive name.
Description: Enter a more detailed description of the value to make its usage clear.
Import a Dimension Structure
If you are going to add multiple dimensions and dimension values at once, it is generally faster to use the import function rather than create each one manually. To do this, you need to create a spreadsheet containing the new dimension and dimension value information in the correct format, then import it.
If you don't see the Import Dimension Structure button, the Structure Import permission needs to be added to your role or you need to be given a role with Structure Import Permission.
When importing a dimension structure, you have three options for import:
Update Structure: This option updates the existing properties for the elements found in the uploaded spreadsheet. Typically you would download a Printable View, update its contents, then upload the resulting spreadsheet to apply the updates.
Append Structure: This option inserts all items found in the uploaded spreadsheet as new items in the dimension being imported. The uploaded spreadsheet cannot contain listings for any existing elements in the structure being imported. Append Structure Import cannot be used to change attributes or re-parent existing elements in a structure.
Reload Entire Structure: This option deletes all the items of that type, as well as all their associated data in Cube Sheets, and builds an entirely new tree from the specified import. Any data previously tagged with this dimension will become uncategorized in this dimension.
WARNING: Reload Entire Structure erases all existing dimension values of the dimensions you are importing, be sure to pick the right option!
To download a template for creating an importable dimension structure, do the following:
- Go to Modeling > Model Management and click Dimensions.
- If you plan to use the Update option, click Printable View to download the existing structure. BEST PRACTICE: Remove the rows you do not want to change.
- Click Import Dimension Structure in the toolbar.
The Import Dimension Structure Dialog appears.
- Click Download Template.
A dialog letting you save or open the template appears. The template itself contains instructions for entering the information you are going to import. Open it in Microsoft Excel and follow the instructions.
- For Append or Reload, populate the import template with the desired entries you want to add.
- For Update, make changes to the Printable View spreadsheet you downloaded in step 2. WARNING: Only include the rows in the spreadsheet for the dimensions you are intending to update to reduce the risk of accidentally changing the properties of other dimensions.
- Save the template to a convenient location on your computer.
- In the structure import popup window, click Choose File to locate and select the import file.
- Click Upload.
If the import file contains dimension names that are already in use and Reload is being used, an error message appears. Reload cannot be used to replace existing dimensions that are in use.