Users can adjust the properties of a hierarchy through the Properties panel found by right-clicking on a hierarchy in the dimension / hierarchy tree in Discover. Custom properties "overlay" the original settings for each hierarchy as they were designed in the original source data model.
Overlays allow users to edit the hierarchy caption and type. The edits are either for the current user globally, or for all users in the current report specifically. In Discover, users can apply metadata overlays to measures as well. For instance, you may want to change the hierarchy "Product Sub Category" to "Product Subcategories". Or you may want to assign a geo-location hierarchy to an appropriate geo-location type: say the State hierarchy wasn't assigned a type, you can assign it to the State type so that you can use it in mapping visualizations.
Admins have the rights, through the same interface, to set it by role for different user groups globally. This is an extension of the same functionality delivered in the Data Source Manager - where Admins can set overlays user roles in both the Admin console and in Discover.
Hierarchy Properties Dialog
To access the properties dialog, right click on the required hierarchy and click Properties from the context menu.
The dialog presents the user with the following options:
- Caption: the caption designated to the given dimension hierarchy. Edit the caption as required.
- Type: the category assigned to the given dimension hierarchy. Select a different type from the drop-down menu.
- Apply custom overlay properties: determine the scope of the overlay:
- For Report: set the overlay for the current report only.
- For Me: set the overlay for yourself only.
- For Roles: set the overlay for specified roles. This option only appears for administrators.
- Restore Defaults: restore the hierarchy's default properties.
Click OK to confirm your changes.
How to Assign Roles to Hierarchy Properties for Admins
Admins have the option to set hierarchy properties at the role level. This gives them the ability to set an overlay for the hierarchy name and type, and assign roles to that overlay. They can also view and edit that overlay from the Source Manager in the Admin console where they can add other details to the overlay, including a display folder and a description.
In this example, the caption of the ZIP hierarchy is being changed to Post Code. Open the Hierarchy Properties dialog by right clicking on the relevant hierarchy and selecting Properties.
After setting the hierarchy caption and/ or type, open the 'Apply custom overlay properties' drop-down. By default, this is set to 'For Me', and changes will be applied to you only. To set the overlay for roles, select 'For Roles'.
A list of roles will appear; select the roles that you want to assign to the overlay and click OK.
Users with the given role will see the metadata overlay:
Managing Hierarchy Properties
You can edit the hierarchy properties that you've configured from the Admin console, and from Discover. To edit properties in Discover, open the Properties dialog for the hierarchy for which you set the overlay. You can change the caption and type as usual, and change role security for the overlay.
Any role that is assigned to an overlay in the given hierarchy will display the details of that overlay: the alternative name, and type.
Restore Default Properties
Click Restore Defaults to remove the overlay and revert to the model's default caption and type.