Creation of Hierarchy in OBIEE

Dimension Hierarchy:Display the data in different levels is called as hierarchy.We can create the hierarchies by using dimensions only.For example time dimension, geography, customers etc.Hierarchy can be created either manually or by using wizard.This is the one of the most useful feature available in OBIEE for data analysis at different levels.

Pre-requisites for dimension hierarchy:

• Creation of Levels
• Assigning columns
• Defining Keys

Time Dimension Hierarchy is the one of the most useful hierarchy in real-time application.Lets work on that:
Creating hierarchy using Wizard:

Right click on the table->create dimension

 Automatically it will create the dimension

 We get only two level s one is total n other is detail level.

Creating a dimension hierarchy Manually 

right click on the schema sh -> new object -> Dimension

Give the name of the dimension(times dim)

Click OK.

Creating levels(right click on hierarchy(times dim)  -> new object -> logical level

give the name for level as year 

Click OK.

Right click on level(year) -> new object -> child level.

Give the name (quarter)

Click OK.

Same process for creating the levels on month,week and day.

Assigning columns (double clcik on the colunm(CALENDAR_YEAR)-> levels -> select year

Click OK.

The column will be added in hierarchy of year level.

Same for quarter,month,week n day.

 

 Define keys(right click oncolumn(CALENDER_YEAR) -> new logical level key.

  

  

Click ok

Same process for the quarter,month,week and day 

Save the RPD.

At Presentation Services or Answers  

 Add the columns -> click on display results

When we click on the CALENDER_YEAR -> it will display the CALENDER_QUARTER_DESC  

click on CALENDER_QUARTER_DESC à it display CALENDER_MONTH_DESC

It display till the last level of hierarchy

Difference between the OBIEE 10g and 11g while creation of Dimension hierarchy

There is no differences between OBIEE 10g and 11g while creation of dimension hierarchy but the new features are added to the latest version.The look and Feel of the wizard may change but the overview is same. 

The Advanced concepts in the hierarchy we will discuss in later posts.