Pages

Creating simple rpd basic


Creating simple rpd basic

Step 1:Open OBIEE Administration Tool.

Step 2:Goto File > New Repository or Press Ctrl and N

Step 3:Give RPD Name..

Select RPD Location, (Where you want to save the RPD.)
and give RPD password.

Click Next

Step 4: Select Connection type.

here I am selecting OCI10g/11g. (Database is installed in local system.)

Give Data Source Name:

localhost:1521/orclnew

Note: localhost is hostname.
1521 is port number of oracle db installed in local system.
orclnew is db instance name.

now give user name and password of schema for which you want to create RPD.

click Next

Step 5:Import the tables or views.

Step 6:Give the physical joins in Physical Layer.

Step 7:Creating Business Model in BMM layer.

right click on BMM layer > New BMM Model >
give name of BM Model > Click ok

Drag and Drop the tables from physical layer to BMM Model.

Step 8:Check the joins.

if not, give the joins.

Step 8: Rename table name, column names as per your Project Naming conventions.
use Rename wizard to rename.

Step 9: Create Subject area in Presentation layer.Right click on presentation layer > New Subject area
Give the name > click ok.

Step 10:Drag and Drop the tables you want in presentation layer.

Step 11:Click save.
click yes for Global consistency check.

Watch the below video

 


Featured post

Snowflake - Creating warehouse in Snowflake

Creating warehouse Login to Snowflake and click on warehouse and click on Create fill the necessary details and click Finish We can also c...