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 File -> New Repository -> Click Ok
3. In the window, give RPD Name "SH", give Username "Administrator" and Password "Administrator"
after that you will get the following blank RPD and it will be saved in the following path
C:\Oracle BI\Server\Repository\SH.rpd
Before going to import the data source from SH schema, we have to create the DSN for SH Schema.
Next click on the file -> import -> from database, then will get the following screen.
Select SH DSN and enter the password of SH schema and click Ok. It will look like the screen by below:
By clicking the "OK" button from the above screen, you will get the following import popup window. so, select SH schema from that window and click import.
Once the tables are imported, we will get all the tables in the physical layer of the RPD. The screen is looking like following:
In the Next Post, we will learn how to create relation between the table by making join between the table using physical layer diagram.
Keep Rocking!!!
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
Sales history schema comes with Oracle database as one of the sample schema. It explains a business scenario where company has products which are sold through multiple channels to customers with seasoned promotions to make the sales effective.
Tables of the SH Schema:
|
Table Name
|
|
COUNTRIES
|
|
CUSTOMERS
|
|
PRODUCTS
|
|
TIMES
|
|
PROMOTIONS
|
|
CHANNELS
|
|
SALES
|
|
COSTS
|
Relational Diagram between the tables:
In Next Post, we will see How to import this tables into New SH rpd and how to build all three layers of repository.
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 from the following path.
C:\Oracle BI\Server\Config\ NQS Config.INI
and same like, If you have created any new catalog in the presentation services and want to make that default, then you have change the one more file .i.e instanceconfig.xml file.
instanceconfig.xml file is available in the the following path:
C:\Oracle BIData\Config\instanceconfig.xml
We will learn How to create new RPD and New catalog one by one in the coming post.
Keep Rocking!!!
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 from the following path.
C:\Oracle BI\Server\Config\ NQS Config.INI
and same like, If you have created any new catalog in the presentation services and want to make that default, then you have change the one more file .i.e instanceconfig.xml file.
instanceconfig.xml file is available in the the following path:
C:\Oracle BIData\Config\instanceconfig.xml
We will learn How to create new RPD and New catalog one by one in the coming post.
Keep Rocking!!!
In this post, We will lear How to create new RPD. Once the Installation is over, Start OC4J from windows OBIEE Installed application.
OC4J mean Oracle Container for Java, that manages all Java and GUI components and working here as Application Server.
After Installation is completed, If you are seeing the services, three new serivces will be created.
1. Start OC4J
2. Oracle BI Server
3. Oracle BI Presentation
You can see the services, by typing "services.msc" in run command.
OC4J is the first service has to be started when you started working with OBIEE.
Oracle BI Services is the core service for Administration Tool, if this services is running you can open your rpd file in online mode.
Oracle BI Presentation Services is the service that using for accessing the Oracle Answers and BI Interactive Dashboard.
Introduction:
The core of Business Intelligence Applications is Data warehousing and the core of Data warehousing is Data Mining. If we are speaking the technical aspect, Data Mining is gathering knowledge from Data. So Knowledge of Data Discovery also part of the Data Mining.
So Data mining is the important subject to know, if we are working in data warehousing.
Definition of Data Mining:
Data mining is the entire process of applying computer-based methodology, including new techniques for knowledge discovery, from data.
Knowledge discover explains the step of process How to get the useful data from the Raw data.
From the below picture, you will know the knowledge discovery process.
Step 1:
The data is collected from various sources like spreadsheet, flatfiles, dmp, and etc., that is called Raw Data.
Step 2:
The collected raw data is integrated and cleansed to make a data warehousing. Data Integration is involving collect all the source data and making a single unit of system and cleaning Data involves removing or making Junk files and only keeping the necessary files that needed for data warehousing.
Step 3:
The real process of Data mining starts from Data warehousing. So after integration and Cleansing of data, data is transforming into various subject area called Sales, Purchase, Finance and etc.,
Step 4:
So from the separated subject area, we are applying all the knowledge i.e Domain knowledge and we are giving the specific output from the data.
Views
