Custom Dimensions

AFCS supports total 15 custom dimension in the Balance Computation Results, Balance Reconciliation and Results subject area. Users will be able to add the custom dimension, custom attributes in OOB table and Alternate Hierarchy in the user interface which will enable in the BI Catalog. Users can use the Report configuration window to map the custom dimension and the attribute mapping window to map the custom attributes.

To define a custom dimension, complete the following steps:
  1. On the AFCS Home page, click the My Profile icon and select Administration.
  2. Click Report Configuration.
  3. Select the dimension and click the Add icon.
  4. Select the dimension from the dropdown and click Save.
    The Dimension name is saved and will be displayed in the BI Catalog.

    Note:

    In the Report Configuration window, the mapped and available flag is displayed to show the availability of custom dimensions. Edit, Delete and View link will be disabled for the Available flag.
    Using the dimension mapping window, the user can perform the following:
    • Add: Click on Add icon to add the custom dimension.
    • View: Click on View icon to view the mapping for custom dimension.
    • Edit:Click on Edit icon to Add or Delete the custom attribute in the custom dimension in the BI Catalog.
    • Delete:Click on the Delete icon to delete the custom dimension from the BI Catalog.
    • Refresh Metadata: Click on Refresh Metadata button to refresh the staging and results reporting metadata objects.

    Note:

    Following are the number of custom dimension for subject area supported in the current release.

    Table 23-10 Number of Custom dimensions supported for each subject area

    Subject Area No of Custom Dimensions No of Custom Attributes
    Balance Computation Results 15 NUMBER – 20, VARCHAR – 60, DATE - 20
    Reconciliation 15 NUMBER – 20, VARCHAR – 60, DATE - 20
    Results 15 NUMBER – 20, VARCHAR – 60, DATE - 20
    Accounts 15 NUMBER – 20, VARCHAR – 60, DATE - 20
    Transactions 15 NUMBER – 20, VARCHAR – 60, DATE - 20

    Note:

    The following attributes are added by default in each custom dimension.
    • CODE
    • ID
    • LRI
    • SKEY
    • RECORD START DATE
    • RECORD END DATE
    • CLOSED FLAG

Add Custom Attributes in Custom Dimension

Once the custom dimension is mapped, User can map the custom attributes to the mapped custom dimension. To Define the custom attributes in custom dimension, complete the following steps

  1. Select the mapped custom dimension and click Edit . This will open a new Attribute Mapping tab for the selected dimension.
  2. Using the attribute mapping window, the user can perform the following:
    • Add Custom Attribute: Select the Attribute and click Edit. Select the Attribute Name from the dropdown and click Save
    • Delete Custom Attribute:Select the attribute and click delete