18.2.3 Custom Hierarchies

AFCS supports the definition of hierarchies based on dimension attributes and their use in the reporting layer. Users will be able to specify display names for hierarchies in the user interface which will enable alternate hierarchies in the BI Catalog. This will allow users to define custom reports in the 'Balance Computation' Subject Area.

To define a name for a hierarchy, complete the following steps:

1. On the AFCS Home page, click the My Profile icon and select Administration.
2. Click Hierarchy Management.
3. Select the hierarchy table from the Choose Dimension drop-down for which you want to define a name and click on the hierarchy.

   Note:

   When you expand the custom hierarchy, the code and name is displayed.
   The Definition section is displayed.
4. Enter the name and description for the for the hierarchy and click Save.
   The hierarchy name is saved and the same will be displayed in the Reports.

   Note:

   Following are the number of custom hierarchies for OOB tables supported in the current release.

   • Branch Code - 1
   • General Ledger Account Code - 5
   • Legal Entity Code - 1
   • Organization Unit Code - 4
   • Product Code - 1
   • Acquisition Channel Code - 1
   • Business Unit Code - 1
   • Intercompany Identifier - 1
   • Location Code - 1
   • Project Code -1

   Login to the application and execute the process Reporting Parent Child Relation Data Population. Select Dimension Hierarchy Entity (Single/Multiple) and select the DataSource value as NA.

   Note:

   Prior to viewing the Dashboard reports, you must run the Reporting Parent Child Relation Data Population PMF pipeline.