Creating Hierarchies with Oracle BI Cloud Service Data Modeler

Creating Hierarchies with Oracle BI Cloud Service Data Modeler :

  1. In Data Modeler, click Lock to Edit button.

lock to edit button

  1. The Information dialog box displays confirming that you have successfully locked the model for editing.

information dbox

  1. Click OK. The model is locked by the current user for editing.

locked by current user

  1. After creating dimension tables, you can add hierarchies and levels to those tables. A hierarchy is a system of levels in a dimension that are related to each other by one-to-many relationships.

Expand the Data Model accordion and click the dimension table in which you want to add a hierarchy. For example, Products.

Hier1

  1. In the Products dimension table, click the Hierarchies tab.

The default hierarchy is displayed. A hierarchy typically begins with a total level and then has child levels, working down to the lowest level. To make the hierarchy not visible in analyses, deselect the Available option.

hier2

  1. Click the Detail level to display a dialog box in which you can specify the level name, the key column, and the display column for the level.

hier3

  1. Change the display column to Item Description, and click OK.

hier4

  1. Click Add Level, and select the column that corresponds to that level. For example, select PRODUCT.

hier5

  1. The Product column is added as a new level before Detail in the hierarchy.

hier6

  1. Click the Product level to display a dialog box in which you can specify the level name, the key column, and the display column for the level. Change the level name to Products, and click OK.

hier7

  1. The new name is displayed.

hier8

  1. Right-click Total, select Add Level, and then select Product_Type.

hier9

hier10

  1. The selected column is displayed in the hierarchy.

hier11

  1. Change the PROD_TYPE level name toType.

hier12

  1. Repeat steps 12 to 14 to add two more levels, Brand and LOB, to the hierarchy.

hier13

  1. In the Hierarchy 1 toolbar, click the Hierarchy Actions icon model actions icon, and select Rename.

hier14

  1. In the Rename Hierarchy dialog box, enter Products, and click OK.

hier15

  1. The hierarchy name is displayed.

hier16

  1. Here you can add more hierarchies according to you requirement.

Leave A Reply

Your email address will not be published. Required fields are marked *