Create a Parent-Child Dimension
Learn how to create and configure a parent-child dimension.
Overview
To modify the structure of a parent-child dimension, such as how many levels it contains, you can customize a dimension. Customization is done before configuration because it defines the levels in the dimension and any custom properties. After you define the dimension's levels, you can then configure how the levels are displayed, such as changing their display names.
Create a parent-child dimension
Who can use this feature?
Users with this profile:
-
Basic Model Developer
-
Advanced Model Developer
Not sure if you have this feature or capability? Reach out to your administrator.
You can create a dimension in the Dimensions room or by selecting a specific analytic object on which to create the dimension.
Model > Dimensions steps
In this workflow, start by selecting the dimension type to create and then select its associated analytic object.
- In a project, on the navigation bar, click Model > Dimensions.
- Click Create Dimension.
- Selected Parent-child, and then click Next.
- Select an analytic object and then click Next.
This is the object associated with the dimension; for example, if you're creating a dimension for your employees' hair color, the analytic object is Employee.
- Type a display name and description.
- When finished, click Create.
Result: The dimension is created and can now be customized and configured.
Model > Analytic Object steps
In this workflow, start by selecting the analytic object and then select the dimension type to create.
- In a project, on the navigation bar, click Model > Analytic Objects.
- Select an analytic object.
- In the Attributes tab, click Add Attribute > Dimension.
- Select Parent-child, and then click Next.
- Type a display name and description.
- When finished, click Create.
Result: The dimension is created and can now be customized and configured.
Customize a parent-child dimension
Who can use this feature?
Users with this profile:
-
Basic Model Developer
-
Advanced Model Developer
Not sure if you have this feature or capability? Reach out to your administrator.
Turn on large dimension search
If your parent-child dimension has more than 300,000 members, such as in the supervisory hierarchy, Visier's default doesn't allow searching for specific members to help with performance. You can bypass the default if your hierarchy has fewer than 20 million members by turning on Large dimension search.
-
In a project, on the navigation bar, click Model > Dimensions.
- Select a parent-child dimension.
- In the Customize tab, turn on Large dimension search.
Rename a default level name or add additional levels
Each parent-child dimension has a different number of levels depending on the hierarchy. When viewing a visualization, users can select a specific level of the parent-child dimension to view all attribute values at that level. For more information about parent-child levels in visualizations, see Change the level of the group by attribute.
Each level has a default name, starting with Level 1, Level 2, and so on. You can rename a default level name to a custom name to help users understand what level they are selecting in a visual.
To determine what levels you want to rename, preview the parent-child dimension in the solution, as described next.
-
In a project, on the navigation bar, click Model > Dimensions.
- Select a parent-child dimension.
- In the upper-right corner, click Preview.
- In the visualization preview, click the Group By picker in the visual title, and then click Select level of.
- In the list of levels, select a level to view its data. The following screenshot is an example of the default list of levels.
Now that you know how many levels the parent-child dimension has and what data each level contains, you can rename the levels by adding levels to the dimension, as described next.
-
In a project, on the navigation bar, click Model > Dimensions.
- Select a parent-child dimension.
- In the Customize tab under Levels, click Add Level.
- Type a display name and description.
- Select a data type from the list.
- Click Add.
Note: The order of the levels in the list determines the mapping of the levels in the hierarchy. For example, the first level in the list is applied as the first level in the hierarchy.
- Repeat steps 3 to 6 for each level you want to rename or add.
- Optional: Use Reorder to change the order of the dimension's levels.
Add custom properties
Add custom properties to modify your parent-child dimension and provide additional information for each member within the parent-child dimension.
Example: In a Cost Center parent-child dimension, use custom properties to include information about who runs the cost center and its location.
-
In a project, on the navigation bar, click Model > Dimensions.
- Select a parent-child dimension.
- In the Customize tab, click Add Custom Property.
-
Select a data type from the list.
-
Type a display name and description.
- Click Add.
Configure a parent-child dimension
This configuration includes changing the display names for the hierarchy and mapping unknown values from the data to the dimension's Unknown Value setting.
To configure a parent-child dimension:
-
In a project, on the navigation bar, click Model > Dimensions.
- Select a parent-child dimension.
- In the Configure tab, do any of the following:
- To set an unknown value, beside Map unknown value, click Edit and select a value from the list. You can Save this selection or Clear it and choose another.
- To change the display name of a member, click the row in the Custom Name column and type a new display name.
Change a local dimension to a shared dimension
Who can use this feature?
Users with this profile:
-
Basic Model Developer
-
Advanced Model Developer
Not sure if you have this feature or capability? Reach out to your administrator.
Convert a dimension so it is shared among multiple analytic objects.
Tip: If a dimension is shared, it has the Shared icon , as shown next.
Because the object name for the dimension may change, any dependencies for the local dimension will update automatically and appear in the project's changelist. For more information about changelists, see Manage and Commit Project Changes.
Content such as analyses and charts will update to reflect the new object name for your converted shared dimension.
- On the navigation bar, click Model.
- Navigate to a dimension, either through Analytic Objects or Dimensions.
Note: You can convert leveled dimensions or parent-child dimensions to shared.
- In the upper-right corner, click the More actions button > Make shared.
- Select the analytic objects you want this dimension to be shared with.
- When finished, click Make Shared.
Caution: You cannot revert the dimension back to local after conversion.
Troubleshoot "Data is not available"
You may see a "Data is not available" note in the Customize tab. To investigate data availability, check:
- The Data Transfers room in the global workspace. There must be a data file that contains data for the object.
- The Sources room in the global workspace. The data file containing your object data must be connected to a source. For more information, see Sources.
- The Mappings room in a project. The source that contains your object data must be mapped to the associated property. For more information, see Mappings.
- The data version. After mapping your source data to a property in Visier, you must generate a new data version. For more information, see Data Categories and Run a Job.
Publish your changes
When finished configuring and customizing the dimension, publish the project to production. For more information, see Publish Project Changes.
To see your changes, run a data version in production or wait until your next scheduled data load to make the data available to users. For more information, see Data Versions.