Friday, 7 June 2013

Oracle Transactional Business Intelligence (OTBI) - Technology Overview Part II

In Oracle Transactional Business Intelligence (OTBI) - Technology Overview Part I I explained about OTBI architecture and it's OBIEE connections details. Many of you may be wondering how to get the the RPD file and  then open it in BI Administration Tool.

Here is the link where I have explained how to get the latest copy of the RPD file from server. This file is created during installation and is a huge in size. By default this has both OBIA and OTBI. Many customers might not be using all of the product families. Depending on the product family you can trim the RPD and keep only those which you are using or which you have installed. This makes it easy for maintenance. If you use default file then it takes too much time to download to local machine, open it and then upload it in offline mode. It also takes long time to open it on-line mode. Oracle has provided way to trim this file.Here is the link for trimming the RPD. In this example I have not used trimmed file. Use any FTP tool to copy the RPD file to your local m/c.

So now you have the file but you don't have the client tool to open it. You need to install the correct version of the tool to open it. The best way to do is to download it from OBIEE Home Page. Log on to the Oracle BIEE Home using the link http://yourcompany.com:10621/analytics/saw.dll?bieehome   and then click on Download BI Desktop Tools under Get Started 
Select the right installer depending on whether your OS is 32bit or 64bit.
















Once you have installed the client tool, go to Program Files->Oracle Business Intelligence Enterprise Edition Plus Client Tools -> Administration. Copy your file in the folder e.g C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client Tools\oraclebi\orainst\bifoundation\OracleBIServerComponent\coreapplication\repository  and then open it from BI Administration Tool. It will prompt for password to open it as the file is password protected. Ask your system administrator or DBA for the same. This is the password specified during installation.


This is what you will see when you open the RPD file.










This covers Opening the RPD file from BI Administration Tool.

Cheers..................

1 comment:

  1. nice piece of information, I had come to know about your internet site from my friend vinay, delhi,i have read atleast 12 posts of yours by now, and let me tell you, your website gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new post, once again hats off to you! Thanx a ton once again, Regards, obiee training in hyderabad

    ReplyDelete