Oracle BI and DWH

Oracle  Siebel nquire Software

History of what is now called as Oracle Business Intelligence Enterprise Edition (OBIEE)

Oracle bought Siebel Analytics in 2005 for close to $6 billion. And that is once of the reason some to script file in OBIEE installations has sbl as prefix .

Here is the example.

Go to <Home>\OracleBI\server\Scripts\Common and you will the screen as below.

sbl Prefix

And we go more deeper into the history Siebel bought nQuire Software was specialized in Internet-based business analytics capabilities.

Thomas Siebel, ex chairman and CEO of Siebel Systems bought nQuire Software in late 2001.

That is the reason some of the file in OBIEE installation still as NQ as prefix. like log files , config file ( NQSConfig.ini) etc

NQ Prefix

One will definitely come across requirement where he/she needs to merge two repository.

There will happens when we need to merger two entirely different repository or when we want to move incremental changes to production.

OBIEE does support 2 online repository ( However you can have 2 repository online but by doing so one will lose the oracle’s product support). In this case merging two repositories into one and making it online is the solution!

Let me discuss that aspect first.

We will two standard repositories  paint.rpd with UsageTracking.rpd so that we can get the usage information in paint repository.

Steps  1  Background

You can mergr two repository in one ,when one is online. However I would not suggest you to do that.

Make sure while merging you are working offline in Administrator tool.

Merging originally designed to work with three repositories. As we have just two repositories we will create a dummy repository.

Go to Administration — > File — > New and create a new repository call dummy.rpd

Creating Dummy.rpd

( Save this to this default location <Home>\ OracleBI\server\Repository however this is not necessary)

Now close this repository with doing anything. Just save when prompted.

Step 2 Open the paint.rpd in offline

Open pain.rpd

paint.rpd

Step 3 Merger paint.rpd with dummy.rpd

Go to File — > Merge and select dummy.rpd

open dummy.rpd for Merge

You will see the screen as below:

Merge Screen

step 4 Click select for the Modified Repository and select UsageTracking.rpd

Selecct usage tracking for merging

In decision you can either select Modified or Current. As we are merging 2 different repository it ok. select merge. You will see an error message called : Delete Failed. Just ignore that message.

And you will see both the repository merged as below.

Merged Repository Paint and UsageTracking