OBIEE 10g High Availability

.

Sometimes there is a need to have OBIEE system operating during planned or unplanned downtime. Because of this reason OBIEE provides a high availability capability: it is possible to configure all OBIEE components in order to offer high availability. In this entry I am going to describe the process of configuring a high available OBIEE 10g system.

Before going to the configuration I want to clarify some concepts:

Availability is the degree to which an application, service, or function is accessible on demand. Based on this concept we can conclude that High Availability is a system continuously operational as long as possible.

High availability systems can be categorized into local high availability systems which are configured in a single data center and disaster recovery solutions systems which are usually geographically distributed. OBI Server only can be configured in the first case; all components of the BI Cluster Server feature must reside on the same LAN.

High availability comes from redundant systems and components. Local high availability solutions can be categorized, by their level of redundancy, into active-active where two or more active instances are working at the same time and active-passive where only one instance is active and others are in standby.

OBIEE provides for high availability through the use of native clustering, failover and load balancing capabilities. Let’s analyze the OBIEE 10g components and how they are communicated in a clustered environment.

Continue reading this post >

Happy Christmas Holidays 2011!

.

The ClearPeaks Team would like to wish you a Merry Christmas and Best Wishes for a Happy New Year!

 Christmas

OBIEE 11g: Avoiding duplication in a date range fact table

.

Sometimes you find yourself dealing with a fact table consisting of an event with an effective start date and an effective end date. Some typical examples of these cases are employee absences (an absence has a start date and end date), salaries (a salary has a period when it was effective) or item in a warehouse (date in and date out of the item).

In these situations, the following reporting need can arise: “how many employees were on leave in Aug 15th?”, “what was the salary of employee X last month?”, “how many units of item IT1 were there in warehouse W2 in Nov 30th?”.

Continue reading this post >

OC4J as a Windows Service

.

Some Oracle Application like BI Publisher 10g uses OC4J, which is an Oracle Application Server which enables J2EE applications to run. These set of containers, API and services have to be started manually at system start up and after system downtime.

It is annoying for system administrators to have manual task to take care of. So, if we are in a Windows environment, these tasks can be avoided if they are defined as an automatic start-up process within the MS Windows Service.

Installing OC4J as a MS Windows Services we will solve that inconvenience we will take a step further in automation wise and we will decrease the services downtimes.

Continue reading this post >

Managing the ins and outs of an end-to-end BI Solution

.

United Carton Industries was founded in 1990 and with a manufacturing capacity of 265,000 metric tons is the leading supplier of corrugated packaging in the Middle East.

Efficiency is a necessity in such a demanding manufacturing environment. In order to manage and control their day-to-day functions and thus allow effective decision making, UCIC realized the importance of implementing a Business Intelligence Solution and aware of their unbeaten track record contacted ClearPeaks.

Continue reading this post >

privacy policy - Copyright © 2000-2010 ClearPeaks

topnav