Creating Presentation Layer of SH Repository
The main purpose of building the Presentation catalog in Presentation Layer is to provide the useful and necessary data from the end-users perspective i.e. different view of data for business measures are provide for different type of users.
Steps for making Presentation catalog in Presentation Layer are as follows:
1)In case you closed the rpd file, use the following steps to open the repository.
...
Wednesday, June 1, 2011
//
Labels:
OBIEE 10g
//
0
comments
//
Building the Business Model & Mapping Layer
The main purpose of the business model is to capture how users think about their business using their own business terms. The business model simplifies the physical schema and...
Wednesday, June 1, 2011
//
Labels:
OBIEE 10g
//
0
comments
//
In this post, we will learn How to create the relation between the
tables using Physical Layer Diagram.
Using the Physical
Diagram approach you can define both Primary and Foreign keys in one step.
In SH Schema, the following is the key that you are going to join
between the table.
PROMOTIONS. PROMO_ID = SALES. PROMO_ID
TIMES. TIME_ID = SALES.
TIME_ID
CUSTOMERS. CUST_ID =...
Wednesday, June 1, 2011
//
Labels:
OBIEE 10g
//
0
comments
//
Importing Data source from SH Database:
Open the Administration Tool and create New Repository by following the below steps:
1. Select Start > Programs > Oracle Business Intelligence > BI Administration
2. Click...
Monday, May 30, 2011
//
Labels:
OBIEE 10g
//
1 comments
//

Hi All,
Through this post I'm explaining how to create the RPD for Sample SH schema in OBIEE 11g. This will be a good starting point for someone who wants to learn OBIEE10g. It covers the following,
1. Building Physical Layer
2. Buiding BMM layer
3. Building Presentation Layer
Business Scenario:
Sales history schema comes with Oracle database as one of the sample schema. It explains a business scenario where...
Monday, May 30, 2011
//
Labels:
OBIEE 10g
//
0
comments
//
NQSConfig.INI file is the first file you have to know when you are started working with Administration Tool.This file contains the information that which rpd is currently running in online, cache information, authentication types and etc.,After the installation you can see two folder in the installed path.i.e 1. Oracle BI - Related Administration Tool 2. Oracle BIData - Related to Presentation Server.you can edit and can change the NQS confiq.INI file whenever you want...
Sunday, May 29, 2011
//
Labels:
OBIEE 10g
//
0
comments
//