OBIEE
[OBIEE Solution]Deployment of OBIEE 11G BI Publisher reports
Before we start discussing about the method on deploying OBIEE 11G BIP reports. Let us firstly look back to the 10g deployment of BIP reports. For example, we have two servers A and B. And we are trying to deploy the “BIPreports” under the xmlpserver repository on Server A to Server B. Usually on 10g BIP, [...]
[OBIEE Issue] Template upgrade for 10g BIP reports to 11g
The sample xml file generated by 10g data model is a little bit different from what 11g has offered. Let us look at the difference below: So in the templates of 10g if you have used tables. It might have something similar like this, if you look at the table properties through BI Publisher plugin. The [...]
[OBIEE Issue]11g BIP Error Code:InvocationTargetException
After I upgraded my 10g BIP reports to 11g, I was thinking of linking to the reports from the 11g BIF like what I did with old 10g OBIEE BIP. Let us review what we did in 10g firstly. So basically when we we login to 10g xmlpserver and access the report, on the uppper right corner there [...]
[OBIEE Issue]Upgrade BI Publisher reports from 10G to 11G
I have to highly recommend the following blog article that talks about the upgrade of 10g BI Publisher reports to 11g. Blog link: http://bipconsulting.blogspot.com/2011/07/10g-users-lets-upgrade-to-bi-publisher.html Kan explains the process in detailed steps and I followed his steps to perform the upgrade. The upgrade was successful as he showed in the last picture of publisher reports upgrade section. I have [...]
[OBIEE Issue] OBIEE 11g Deinstall Q&A
In order to get rid of the failed installation of the my last OBIEE 11G installation with the simple install. I performed the following tasks:( The reason that I did not use the uninstall wizard is there existed failure during my last installation and prevented the uninstall wizard from working correctly. I will cover the [...]
[OBIEE Issue] How to remotely connect to online RPD
Step 1. Set up your system DSN. Go to “Start” at the left corner of your windows system and click to expand the panel. And then click “Control Panel” on the right. Step 2. Click “Administrative Tools“, and then click “Data Sources (ODBC)” . Step 3. Click “System DSN” and then click “Add” to add [...]
[OBIEE Issue] SSO server version v3.0 is not supported
Background: I made an upgrade on SSO Server 1 from 10.1.2.x to 10.1.4.x ,while for SSO Server 2, I kept the older version. Here is the version number comparison that you could easily found out from the setupinfo.txt under the software installation folder. and then I tried to register the same partner application server with the same syntax I [...]
[OBIEE Issue] XMLP Server Cache Control
1. Login to BI Framework with the user account which has the XMLP_ADMIN privileges on BI Publisher. Click Admin Tab from this page. 2. Click Server Configuration on Admin Page. 3. If you have never set up the Caching for publisher, by default,it should be all blank for this section. Input the numbers for [...]
[OBIEE Issue] Roll back Selection Security to be Enable
Recently, I was asked about a question that how to roll back the Selection Security to be Enable again. It looks like on the Dashboard Properties page, you could change the Selection Security from Enable as shown by the graph above to the two new icons below which offer more flexibility of setting up the selection [...]
[OBIEE Issue] Whole Cache Purging Scripts
Be sure to set your Oracle BI home in the ‘.profile’, as the base installed directory of OBIEE, on the OBIEE Server. The following script would reference it as ORACLEBI I will create a temporary “purge-log“ folder under Oracle BI Home that would store the log information of the cache purge. 1.You need to put [...]

