- 3 Minutes to read
- Print
- DarkLight
- PDF
Setting Up Attributes for Attribute Hierarchies
- 3 Minutes to read
- Print
- DarkLight
- PDF
Attributes must be defined before creating the attribute hierarchy. Attributes are used to report and aggregate leaf-level dimension data based on traits. For example, a Department dimension is associated with the division attribute dimension where members are categorized based on profits.
List of Attribute Types
Whenever you are creating attributes, you can see the following types of attributes:
Reference to Segment
Select to assign the attribute to a defined segment. Used when the attribute is linked to another dimension in the reporting area.
Text
Attribute value expects alphanumeric values which change from one member to another in the hierarchy.
Date
Attribute value changes from one member to another and the valid input is the date.
Month
Attribute value changes from one member to another and the valid input is the month.
Year
Enables the default year field.
List
Specify allowed values. Enter the number and select Add to insert rows.
Float
Enables the Default Value field which may be used to enter precise numerical values.
Integer
To enter a number without a decimal to associate with the attribute.
Dimension
Available when “Reference to Dimension” is selected so that the attribute may reference a dimension.
Attributes
Attributes are created in Hierarchy Management and can be added within the Finance Hierarchies Setup page. Attributes may be used in the budget entity hierarchy as well as in Dynamic Reporting.
- Leaf-level members of one dimension can be used as the attribute value on another dimension. For example, if Countries is a dimension, the leaf level members of the Countries dimension can be used as an attribute for the Customer dimension. A Reference to Segment attribute type could be used and referenced to the Customer.
- User-defined attributes are optional but highly useful for tailoring reports to specific needs.
- For Financial Segments, you can define up to 25 attributes across 8 dimensions, depending on your application configuration.
How to Navigate to Attribute Setup?
To navigate to Attribute Setup, follow these steps:
- Navigate to Maintenance and Hierarchy Management.
- Click Edit Hierarchy to open the Hierarchy Management interface in Edit Mode.
If your Default View is set to Edit Mode, the interface will automatically open in Edit Mode. - From the Hierarchy Selection screen, select the Hierarchy and Dimension to which you want to add the Attribute (for example, Department).
- Select Show and then Setup.
- On the Finance Hierarchies Setup page, click Attribute Setup. The Finance Attributes page appears.
- On the Finance Attributes page, you will see the following options:
- Add: To add a new attribute.
- Edit: To edit an existing attribute. Note that you can edit an attribute ONLY if Used in Reporting is set to No.
- Delete: To delete an existing attribute.
- Move Up / Move Down: To reposition attributes on the page.
- Save Display Order: Saves the position of the attributes on the page.
- Attribute Member(s): To access the Attribute Members List page. This allows you to view, delete, and export attribute members (for attributes with an attribute type of Text). You can also click Output to export the Attribute Members List to Excel for printing, viewing, or reporting purposes.
- Filter and Export: To apply filter and narrow down the search results using the Filter option and to export the Attribute Members List to Excel for printing, viewing, or reporting purposes.
How to Add Attributes from Attribute Setup in Hierarchy Management?
To add a new attribute, do the following:
- Navigate to Maintenance and Hierarchy Management.
- Click Edit Hierarchy to open the Hierarchy Management interface in Edit Mode.
If your Default View is set to Edit Mode, the interface will automatically open in Edit Mode. - From the Hierarchy Selection screen, select the Hierarchy and Dimension to which you want to add the Attribute (for example, Department).
- Select Show and then Setup.
- Click the Add button to add a new Attribute.
- Enter a Name. For example, Reporting_Manager. Optionally you can also add a Description.
- Select the attribute Type. Enter the Values for the attribute. For the Reporting_Manager attribute here, the attribute type is selected as List. So enter the values accordingly.
- Click Save.