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.

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. 

Introduction:

The constant growth of Data Analysis and Business Intelligence Applications, understanding OLAP and OLTP having the important Place.

The design of Data Warehouse and Online Analytical Processing (OLAP) cubes is basically different than OnLine Transactional Processing (OLTP). 

OLTP:

Source of Data: OLTP is original Source of data that maintains the Day by Day transactions and processes for every Business.

Purpose of Data: To run and control the fundamental business task and record all the events inside.

OLTP Reveals the copy of the ongoing Business processes.

Insertion and Updation is very fast in OLTP and this operation is initiated by End Users. All the OLTP is Normalized one and Doesn't having any duplicate records in any situation.

In OLTP, the Query Processing is normally standardized and simple query that gives the result of few records.

The processing speed is very speed and the size of the OLTP  Size  (MB to GB) is very small compare with OLTP if historical data is archived.

Database design of OLTP is highly Normalized with many tables.

Backup & Recovery of OLTP:

Operation data is very critical to run the business and data loss is likely to entail and legal liablity.

OLAP:

The source of data of OLAP is OLTP, Consolidated from various OLTP Sources.

The Main aim of this data is to help reporting, Decision support, Data analyzing and for problem Solving.

This data reveals the Multi-Dimensional views of various kinds of business Activities.

Periodically Its long process to insert the data and update the data But retrieving the data from OLAP is easy.

Typicall the query processing in OLAP is long and tedious and often with complex queries involving aggregations.

The processing speed in OLTP depends upon the size of the data involved, that may batch processes and complex queries may take hours to one and query speed can be improved by creating Views ans Indexes.

The size of OLAP is very Large ( GB to TB) and It contains the consolidated data of OLTP with more aggregation structures and Historical data.

The database design of OLAP is in most cases de-normalized with the fewer tables and using Star or Snowflake schema.