How to Add an Attribute-Based Budget Entity?
- 2 Minutes to read
- Print
- DarkLight
- PDF
How to Add an Attribute-Based Budget Entity?
- 2 Minutes to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Creating a Budget Entity based on attributes allows more dynamic financial reporting and management. By associating attributes such as Reporting_Manager with the Budget Entity, you enable precise control over budget allocations and expense tracking for specific departments, like Travel Expenses.
- 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. - Go to the Hierarchy Selection section on the left pane of the Hierarchy Management interface.
- Select Finance Hierarchies and the Department Dimension.
- Select Show and then Setup. The Finance Hierarchies Setup page appears.
- Click Attribute Setup. The Finance Attributes page appears.
- Click the Add icon.
- Create the Reporting_Manager attribute by adding the Name, selecting the Type, and adding the Values to it.
- Map the attribute to the reporting area in Maintenance > Reports > Cube Settings. Click here to learn more.
- Now, you need to map the attribute to the budget entity. So, return to the main hierarchy area.
- 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.
- Go to the Hierarchy Selection section on the left pane of the Hierarchy Management interface.
- Select Entity Hierarchy as the Type.
- Select Budget Entity Hierarchy from the dropdown for the Dimension and Hierarchy fields.
- Click Show and then Setup. The Entity Type Setup page appears.
- Click the + button to create a new one. The Add Entity Type page appears.
- To add the Entity Type, provide the following:
- Name > Travel Expense
- Basis > Based on Attributes
- Description > Optional
- Select Enable Default Member Selection
- Map the Reporting_Manager attribute.
- Click Save and return to the main hierarchy area.
- 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.
- Select the main Budget Hierarchy member.
- Click Add to add a new member.
- Select the following for the new member:
- Node Type > Leaf
- Node Sub Type > Travel Expenses
- Click Add.
- Enter the Member Code.
- Scroll down to User-Defined Attributes and for Reporting_Manager, click the browse icon and the Select Reporting_Manager window appears. Note that the window name is derived from the attribute but it's not the default window name.
- Select the VP Administration attribute and click Save.
You can see the VP Administration value added to the Reporting Manager attribute. - Similarly, for Default Member, select the browse icon and the Select Default Member window appears.
- Select Department 500 Ops Mgmt.
- If you cannot find the default member you are looking for, click on the Apply Filter icon.
- Use the Department Code or Department Name fields to refine your search.
- Enter the Department Code, i.e. 500 here. The member appears.
- Select the member and click on Save. You will now see 500 - Ops Mgmt as the selected value for the Default Member.
- If you cannot find the default member you are looking for, click on the Apply Filter icon.
- Now, click OK.
- Confirm settings for Budget Entity member VP Admin.
- Click Save to publish the updated hierarchy.
Was this article helpful?