When you create dimensions you must also create values. The name of the dimension is the container or category for the dimension values. The dimension values are the options you and your team use to enter data.
After you create dimensions and values, add them to standard, cube, and modeled sheets. You and your team can select the values as you enter data. Then you can build reports and charts using the dimensions.
There are several ways to create dimensions and dimension values:
- In Modeling > Dimensions, use the toolbar to create one at a time.
- In Modeling > Dimensions, use the toolbar to import and choose the Append option. See Import Attributes and Custom Dimensions.
- In Integration use the dimensions loader.
- In Integration use the updateDimensions API.
With the appropriate settings, you can also create dimension values with the Integration loaders and APIs for:
- Levels if the dimension is a level dimension.
- Data imports.
Before You Begin
How You Get There
From the nav menu, select Modeling. From the Levels and Dimension menu, select Dimensions.
List Versus Hierarchical Dimensions
1 List dimensions have flat values. Each value rolls up to the dimension name.
2 Hierarchical dimension values roll up to other dimension values. All dimensions, including custom dimensions, are hierarchical by default.In the example, Geography is an hierarchical dimension. Menlo Park rolls up to 650, which rolls up to California. You cannot assign attributes to hierarchical dimensions.
From the toolbar, click Create New Dimension.
Enter a unique name. It must not be the same as any other dimension or attribute.
Select the settings that fit your goal:
Select the Use on Levels to tag levels. See Create Level Dimensions and Attributes.
Select List Dimension to tag the dimension values with attributes. See Create Attributes and Attribute Values.
Select List Dimension to hide or show the dimension values on each version. See Hide Dimension Values from Versions.
Uncheck both List Dimension and Use on Levels to create hierarchical values that don't tag levels.
- (Optional) Select Data import automatically creates dimension values. This lets you add new dimension values when you import data. If you also selected Use on Levels, this setting lets you add new dimension values when you import updates to the level structure through:
- Modeling > Levels.
- The Integration level loader.
- The updateLevels API.
- (Optional) Check Keep sorted. This keeps the attribute values in alphabetical order. Uncheck it if you want to arrange the order yourself.
- In the Custom Properties section, you can add properties to your dimension. The properties appear as numeric text fields in the settings of the dimension values. You then enter informational data in for each dimension value. This informational text doesn't show up in reports and charts. You also can't reference it in formulas.
For Sales Planning only, use the custom properties to Create a Geo Map.
Change Hierarchical Dimensions to List Dimensions
You can change custom dimension to list dimensions with the List Dimension setting:
You must select this setting if you want to:
Tag the dimension's values with attributes.
Control the dimension values available on each version.
You must not select this setting if you want to tag levels with the dimension values.
The List Dimension checkbox is not available when the dimension is hierarchical. To enable the List Dimension checkbox:
- Flatten the hierarchy:
- Select each value.
- From the Parent drop-down, choose the main dimension name, not one of its values.
- After you flatten the list, select the main dimension.
- Uncheck Use on levels if it's selected.
- Select the List Dimension checkbox and save.
Create Dimension Values
If you plan to tag the dimension with attribute values, create the attribute and attribute values before you create the dimension values. See Create Attributes and Attribute Values.
- Select a dimension from the list.
- From the toolbar, click Create New Dimension Value.
- In the Details section:
- (Hierarchical dimensions only) Choose an existing value from the Parent drop-down. The new value rolls up to the parent.
- Enter a unique name.
- (Optional for list dimension only) In the Version Settings section, choose to hide or the dimension value from any or all versions. See Hide Dimension Values from Versions.
- (Optional for list dimension only) In the Attributes section, select an attribute value from the drop-down to tag the dimension value. This section only appears if you created dimension attributes for this dimension.
- (Optional) If you added custom properties to the dimension, they appear in the Custom Properties section as text fields. Enter information data in the fields. For Sales Planning only, you may use these fields to create geo maps.