5.1.5.1 Create Multi Dimensional Balance Sheet Summary

Before creating a new Multi Dimensional Balance Sheet Structure, you need to first consider your organization's goals. This will help you realize the full potential of the MDBSS system and achieve your objectives. You can create more than one MDBSS, with each designed to achieve a specific objective.

Note:

Different MDBSS structures will slot existing data differently, even if they all use the same dimensions. While an MDBSS can place your organization's data at any node, this does not mean all data will necessarily be placed successfully depending upon the MDBSS organization. You should always carefully evaluate what organization data will and will not be included in a particular MDBSS. Ongoing maintenance of your MDBSS is highly recommended.

The MDBSS has organizational rules in place that allow you to maximize its full potential and prevent the possibility of duplicate data being loaded into the Structure.

To create the Multi Dimensional Balance Sheet, do the following:

1. Navigate to the Multi Dimensional Balance Sheet summary page.
2. Click Add icon. The Multi Dimensional Balance Sheet page is displayed.

   Figure 5-13 MDBSS Rule

   
   

   

   
   
3. Enter the following details:

   Table 5-12 Create MDBSS Rule

   Fields	Description
   Name	Enter the name of the Multi Dimensional Balance Sheet Rule.
   Description	Enter the description of the Multi Dimensional Balance Sheet Rule. This is an optional field.
   Folder	Select the Folder where the Multi Dimensional Balance Sheet Rule needs to be saved.
   Access Type	Select the Access Type as Read-Only or Read/Write.
   Dimension	Select the Dimension of the Multi Dimensional Balance Sheet Rule.
   Folder	Select the Hierarchy Folder of the Multi Dimensional Balance Sheet Rule.
   Hierarchy	Select the Hierarchy of the Multi Dimensional Balance Sheet Rule.

   Note:

   Based on the selected Dimension from Dimension drop-down list, the Dimension Source selection options will vary. For example,
   • If Dimension is selected as “Product”, then Product Folder and Product Hierarchy fields will be available.

     Figure 5-14 MDBSS Rule

     
     

     

     
     
   • If Dimension is selected as “Adjustable Type”, then only list of Adjustable Types will be available.

     Figure 5-15 MDBSS Rule

     
     

     

     
     
4. Select the Source of Dimension from Dimension drop-down list. You can click Source option to Select All or Unselect All.
5. Select the Target Node of Dimension. Here, You can select more than one Nodes at a time.
6. Click Drop. You can use Revert option to reverse the selection.
7. Click Target option to Select All or Unselect All.
   • When you select a Node from Source section, then following options are available:

     Figure 5-16 MDBSS Rule

     
     

     

     
     
     • Single node and all its descendants: Allows to select node itself along with its descendants.
     • Single node and its first-generation child nodes: Allows to select node itself along with its child nodes
     • Single node and all of its siblings: Allows to select node itself along with its siblings nodes
   • When node is moved to Target section, then following options are available:

     Figure 5-17 MDBSS Rule

     
     

     

     
     
     • Single node and all its descendants: Allows to select node itself along with its descendants.
     • Single node and its first-generation child nodes: Allows to select node itself along with its child nodes
     • Single node and all of its siblings: Allows to select node itself along with its siblings nodes
     • Autobalancing Leaves Setup: Allows you to setup the Autobalancing for selected node as Asset, Liability, or Retained Earning.
8. Click Save.

Note:

If you are using Dimension Loader to modify members and hierarchies that have been used in MDBSS, follow below steps to refresh it with latest dimension data. These steps must be performed after dimension is loaded successfully.

1. Navigate to Operations and Process from LHS, then select Scheduler.
2. Create a Batch, and then click Define Task.
3. Add below two tasks in batch.

   Task Code	Task Name	Component	Parameters
   1 *	Task Name One *	MDBSS_Hierarchy_Refresh	Dimension Name: Select ‘ALL’ or specific dimension where data has been modified. This parameter is mandatory. Hierarchy Name: Select hierarchy where data been modified. This is mandatory or optional. If any hierarchy is not selected, then all hierarchies will be considered during batch execution. If any single hierarchy is selected, then only given hierarchy will be considered during batch execution. Note: Hierarchy drop-down will populate the hierarchies based on the dimension selected in Dimension Name drop-down.
   2 *	Task Name Two *	Member_Browser_Refresh	Dimension Name: Select ‘ALL’ or specific dimension where data has been modified. This parameter is mandatory. Hierarchy Name: Select hierarchy where data been modified. This parameter is mandatory or optional. If any hierarchy is not selected, then all hierarchies will be considered during batch execution. If any single hierarchy is selected, then, only given hierarchy will be considered during batch execution. Note: Hierarchy drop-down will populate the hierarchies based on the dimension selected in Dimension Name drop-down. Browser Type: This is an optional parameter and can be left NULL. Service Name: This is an optional parameter and can be left NULL. API: This is an optional parameter and can be left NULL.

   * Task Code and Task Name in the above table are for illustration purpose only. You can name them as per your requirements.

4. Execute the Batch. For more information, see the Scheduler Service.

A seeded batch MDBSS_HIERARCHY_REFRESH has been provided to refresh MDBSS hierarchy. ‘Member_Browser_Refresh’ is an optional task but it is suggested to execute it for search functionality in Member Browser to work properly.

Above two components can be put in the batch you may be using for Dimension Loader.