Measure Hierarchy

When you select Measure Hierarchy, the Hierarchy Sub Type is selected as Non Business Intelligence Enabled by default.

To define a Measure Hierarchy in the Add Business Hierarchy window, do the following:

1. Click the View Attributes button in the Entity field. The Entity and Attribute window is displayed.
   • You can either search for a specific Entity using the Search field or select the checkbox adjacent to the required Entity in the Available Entities list. The list of defined Attributes for the selected entity is displayed Available Attributes list.
   • You can either search for a specific Attribute using the Search field or select the checkbox adjacent to the required Attribute in the Available Attributes list.
   • Click Save. The selected Entity and Attribute is displayed in the Add Business Hierarchy window.

     Note:

     Ensure that the values present in Attribute column do not contain new line characters. Because the hierarchy node descriptions in the hierarchy browser are considered as text fields and do not permit new line characters.
2. In the Add Business Hierarchy window, select the Hierarchy Type as Measure.
3. Click the View Attributes button in the Entity field. The Entity and Attribute window opens.
   • A list of all the available entities will be listed under Available Entities. Select the required entity. The attributes for that entity will be listed under Available Attributes.
   • Select the required Attribute and click Save. Click Cancel to quit the window without saving. After saving, the Entity and Attribute will be displayed in their respective fields.
4. Click the Add button from the Business Hierarchy tool bar. The Add Node Values window is displayed. Enter the details in the Node Details section as tabulated.
   The following table describes the fields in the Business Hierarchy too bar.

   Table 8-29 Fields in the Business Hierarchy Tool bar and their Description

   Field	Description
   Node	The Node value is auto-populated and is editable.
   Short Description	Enter the required short description for the node.

   • In the Node Attributes section, do the following:
     • Select Storage type from the drop-down list. For more information, see Storage Types reference in the Non Business Intelligence Enabled Hierarchy section.
     • Select the TB Type as First, Average, or Last from the drop-down list.
   • Click Save. The Node values are displayed in Add Business Hierarchy window.
5. Click Save in the Add Business Hierarchy window and save the details.

In the Business Hierarchy tool bar, you can also do the following:

• Click the Add button to Add subsequent Node/Measures. For the second node or subsequent node, you can also define the Hierarchy Tree and Consolidation Type details as explained below.
  The following table describes the fields in the Business Hierarchy too bar.

  Table 8-30 Fields Business Hierarchy Tool bar and their Description

  Field	Description
  Select Hierarchy Node	Click the View Attributes button adjacent to Child of field and select the required Member in the Hierarchy Browser window. Click OK.
  Consolidation Type	Consolidation Type option is available to Essbase MOLAP. There are six consolidation types such as Addition, Subtraction, Product, Division, Percent, and Ignore. Select the required option from the drop-down list.

• Click the Edit button by selecting the required Node level checkbox to edit the Node details.
• Click the Delete button to delete the defined Node details.