Creating Hierarchies with Oracle BI Cloud Service Data Modeler :
- In Data Modeler, click Lock to Edit button.
- The Information dialog box displays confirming that you have successfully locked the model for editing.
- Click OK. The model is locked by the current user for editing.
- 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.
- 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.
- 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.
- Change the display column to Item Description, and click OK.
- Click Add Level, and select the column that corresponds to that level. For example, select PRODUCT.
- The Product column is added as a new level before Detail in the hierarchy.
- 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.
- The new name is displayed.
- Right-click Total, select Add Level, and then select Product_Type.
- The selected column is displayed in the hierarchy.
- Change the PROD_TYPE level name toType.
- Repeat steps 12 to 14 to add two more levels, Brand and LOB, to the hierarchy.
- In the Rename Hierarchy dialog box, enter Products, and click OK.
- The hierarchy name is displayed.
- Here you can add more hierarchies according to you requirement.