OBIEE 11g - Migration steps in OBIEE11g

 I used the SampleAppLite application in OBIEE 11g. In my Dev environment, I created some new content. I added a new Presentation Layer subject area called SampleAppLite, which represents a change to the RPD file that will have to be migrated to Prod

I also created a new dashboard page on the main Quickstart dashboard called Revenue, and added a new graph report view to the dashboard page:

At the same time, on the production environment, I created a new revenue report (I’m really interested in Revenue) and saved it to My Folders, and added it to My Dashboard:

So to sum it up: I have new standard reports in the Dev environment that need to make their way to the Prod environment… but at the same time, I have my own reports in Prod that I have saved in my own folder structure that need to maintain through the migration.

The easiest way to support this new requirement with the fewest changes to their current process is to simply “save” all the content on the Prod server before moving the entire web catalog over. Though, from a pure SCM perspective this might seem like “cheating”, I would argue that this is not the case. These adhoc analyses should not be seen as development artifacts in the standard SDLC methodology, but instead, as “content”: the usual residue that get’s generated from standard interactions with an application of any kind. This is the whole reason OBIEE supports the My Folder and My Dashboard paradigms.

We have some new options for doing migrations in 11g, but for this test case I’ll simply use Catalog Manager to save the “users” folder on Prod before wiping the entire Prod web catalog and replacing it with a new version from Dev. I have to connect to the web catalog in offline mode because the contents of the users folder is only available that way: even the super user account, in my case “weblogic”, cannot see the contents of My Folders for another user while connecting online:

After I Archive the users folders, I’m free to to do the filesystem-level copy in exactly the same manner that my customer was doing it. To do this in 11g, I use the Overview tab of the Fusion Middleware Control (FMC) to stop all the BI services. I then delete the entire contents of the SampleAppLite directory in the web catalog path, and then copy the contents in from the SampleAppLite directory on the Dev server. After the filesystem copy is complete, I use the Catalog Manager to Unarchive the users directory from Prod back into the web catalog.

I then use the Deployment tab of FMC to upload the RPD file from the Dev server, and then restart the services:

When the services start again, I can see the new dashboards from Dev, as well as the content on My Dashboard that was developed in Prod:

I probably wouldn’t prescribe this approach to an organization starting from scratch; I demonstrated it because it was the easiest way to add permanence to the users folder for a client that was already doing filesystem copies as a method for migration. Another easier, more attractive approach is to abandon the filesystem copy altogether and use the Catalog Manager to facilitate the movement of only the shared folder, or some portion of it, from Dev to Prod. A new enhancement in 11g is the ability to do web catalog Archive and Unarchive operations from within Answers. I choose the “Catalog” option and then highlight the portion of the Shared Folders that I want to Archive: in this case, only the SampleAppLite folder. I then select “Archive”, and I can see the download file very easily in Chrome:

Once I have the archive file, I can connect to Answers in Prod and Unarchive the file. As you can see from the screenshot below, we have quite a few options around matching artifact names, and also around permissions migration with this method.

Read More

Column Indent Background Color Changing in Pivot Tables

1. open your report --> Go to Criteria --> Click Result --> Add Static text view and apply the below html code and click the html option in the static view.

 

<style>.PTCC {background-color:white;border-top:white;border-bottom:white;border-left:white;border-right:white}</style>

 

  

 

Save the Dashboard and see the output like below.

 

Read More

Oracle Data Integrator 11.1.1.7 installation on Linux

Installation of Oracle Data Integrator  is similar as ODI 11.1.1.6 . The only difference is now we have 64 bit RCU( Repository Creation Utility).

Creation of  RCU :

I was installing RCU for OBIEE & ODI. If you just want ODI, select ODI only.

ODI Installation :

Starting Oracle Data Integrator on LINUX

Read More

OBIEE 11g -- Daily Catalog Backup Script Linux

As a best practice we take backup of catalog  daily, weekly, monthly.

So here I am gonna  tell you how to create a script to take a backup of catalog.

1) Create empty file and rename it as  catalog_backup with extension  "sh" as shown above.


2) Edit the catalog_backup with " Emacs Text editor " (or)  GEDIT what ever text editor you have.

put the following text as shown below

where  xxx  ;  is your catalog name

Code Explanation : 
cp  -avr    /sourcefolder                   /target folder


cp  : Copy
-avr :  a= Archive
           v = verbose [Explain's what happens]
          R =  Recursively


$(date '+%d_%m_%y_%H_%M')_xxx    : This will add the date to the folder with the extention of _xxx

which means nothing but adding you catalog name as suffix


3) After you input the code save your file.  Once you save it, do the following

Right click on the file > properties > Go to " Permissions Tab" and click on the check box  which says

" Execute"  to make it a executable  file

That's it  run this script it will take a backup of your catalog as shown below

Read More

Disabling Right Click on OBIEE with javascript

I had disabled the right click button of mouse in obiee

<script language=JavaScript>
<!--
var message="Function Disabled!";

function clickIEbrowser4(){
if (event.button==2){
alert(message);
return false;
}
}
function clickNSbrowser4(e){
if (document.layers||document.getElementById&&!document.all){
if (e.which==2||e.which==3){
alert(message);
return false;
}
}
}
if (document.layers){
document.captureEvents(Event.MOUSEDOWN);
document.onmousedown=clickNSbrowser4;
}
else if (document.all&&!document.getElementById){
document.onmousedown=clickIEbrowser4;
}
document.oncontextmenu=new Function("alert(message);return false")
</script>

Read More

DAC Error Message – No Physical folder information found for PLP

Working on a OBI Apps project, I was getting the DAC configurations ready and bumped into the following error message, stating “Error whle calculating build information!”.  The message stated “MESSAGE:::No physical folder information found for PLP”.   This occured when I was trying to build my newly created execution plan.

Solution

I had created a new execution plan and added my subject area(s) but forgot to click the “Generate” button on the Parameters sub-tab after I had selected the subject areas that I wanted built for that particular execution plan.  To fix the error, I just highlighted the newly created execution plan, clicked the Parameters sub-tab and clicked “Generate ”

Read More

Informatica PowerCenter Server Status URL

Here is a really easy way to verify information about an Informatica PowerCenter’s current status.  You need not be an administrator or even logged into any part of the Informatica PowerCenter environment.  Using the default or custom port of Informatica PowerCenter, enter the following URL:

• http://localhost:6001/coreservices/DomainService
  • i.e.: http://<INFA_SERVER>:6001/coreservices/DomainService

The result will be similar to the image below:

Read More

Informatica Error Calling PMREP or PMCMD – Libraries Issue

Recently digging into the strategy and best practice of installing the OBIEE Applications, mainly the DAC and Informatica  components, I see two common issues arise more often that any others.  One has to do with the Informatica Integration Service not matching the correct locale such at UTF-8 or MS Windows Latin, etc. preventing it from starting and the other has to do with the Informatica or DAC user not able to call the core integration tools pmrep and pmcmd.  This issue is common on Linux/Unix environments but not so much on a Windows server environment.

Basically these are installation concerns but they cause a lot of newbies to waste time on really straightforward pieces of the puzzle, especially when there is a deadline and the rest of the team is waiting on the installation to be completed.  This blog will take a quick look at how to resolve the following error that you may get when attempting to access the pmrep or pmcmd line either from the command line or from the DAC call to the server:

pmrep: error while loading shared libraries: libACE.so.5.4.7: cannot open shared object file: No such file or directory

pmcmd: error while loading shared libraries: libpmasrt.so: cannot open shared object file: No such file or directory

Solution

Ensure that the Informatica Library (../server/bin/) Path variable is available in both the LD_LIBRARY_PATH and the PATH variables is really the key.   I gave a brief mention of this solution on an older Oracle Forum post and wanted to do a little more with it so here is the full solution with some loose conversation around the topic.

A few steps need to be accomplished after installing the DAC and Informatica Server.

1. Ensure that your Informatica user can correctly execute the pmrep or pmcmd from the home directory or any directory outside of the INFA_HOME/server/bin directory.  If the Informatica user cannot then chances are the DAC user will not be able to either.  Either way for the DAC or Informatica user verify or create the next two items.

2. Ensure that the the full path to the INFA_HOME/server/bin directory is placed in the PATH variable.

3. Ensure that the the full path to the INFA_HOME/server/bin directory is placed in the LD_LIBRARY_PATH variable.

Edit the bash_profile, etc. profile file for each respective user needing access to these Informatica commands and then execute each profile file as that user (if sudo’d or logged in as that user) after saving the file by executing,

. ~/.bash_profile

or similar from the command line.  If using a different user to modify the file then the next time the user in question logs in the profile file will take affect.

Re-attempt the execution of pmrep or pmcmd and you should have no more issues.

In addition, if the DAC user is having this problem, the user profile file or the dac_env.sh file may require the above profile var settings as well to correctly connect to pmrep and pmcmd.  If you edit the profile file you will need to re-execute it.  If you modify the dac_env.sh file you will need to restart the DAC server if it is/was running while you were making changes.

Read More