BI Publisher java.lang.reflect.InvocationTargetException

When I was doing some crazy experiments with XSL variables in BI Publisher,
came across the error "java.lang.reflect.InvocationTargetException".
The error was generated by the MS Word Addin of BIP while creating a pdf preview. as shown.

The error screen was the following.

A little googling saved me!!! the reason for this error in java is mainly due to incorrect datatype.
Say a variable of type "Number" is getting assigned with a value of type "Text".

Bingo... the error might be in the variable I decalred as below..!!!

<?xdoxslt:set_variable($_XDOCTX,'V_NA',0)?>

and what generated the error should be,

<?xdoxslt:set_variable($_XDOCTX,'V_NA',NAME)?>

The error was resolved by changing the code to

<?xdoxslt:set_variable($_XDOCTX,'V_NA','xyz')?>

And tried again to get a preview.... Ta..da... It Worked.

Best Visualization and Recommended Visualization for - OBIEE 11.1.1.7

Why developers love Oracle products? Answer is pretty simple, they stand with the developer and makes their life easier. "Best Visualization and Recommended Visualization for" might be the result of such a thought.
Through the steps and screenshots below I wish to show you how it is.

1. Login to your OBIEE, then go to New Analysis> Your Subject Area (Here am using vanilla rpd)
2. Pull in some dimensions and facts.

3. Click Results tab.
4. Click New View>Best Visualization

   For my selection of dimensions and facts this was the result

 5. We can also try with the "Recommended Visualization for" if we are not satisfied with the best !!!!

Here oracle is helping the developer without putting hands into their freedom. This is a very exciting feature in 11.1.1.7. Hope you will enjoy it....!!!

Performance Tiles with OBIEE 11.1.1.7

In this post we are going throuugh an obiee 11.1.1.7 feature, that is performance tiles.
Performance Tile is a single aggregate measure value displayed in a simple way. It further simplifies the view of aggregated measures.
Feeling interested? Eager to create one?? then follow the steps!!!

1. Login to your OBIEE, then go to New Analysis> Your Subject Area (Here am using vanilla rpd)
2. Pull in some dimensions and facts.

3. Click Results tab.
4. Click New View>Performance Tile

 5. So here is your Performance Tile !!!

 6. You can customize your Tile  As Usual with "Edit View" Button

 7. Its interesting that oracle gave us some really good Performance Tile styles

Thank you for visiting intelbusi

ORA-01922: CASCADE must be specified to drop 'username'

Hi, this is a common issue when you try to delete OBIEE11G Schema (DEV_BIPLATFORM and DEV_MDS) from Database. The best way to avoid it is by using RCU itself. But if you want to delete it manually, read further.

This error is issued if someone tries to drop a user when the user to be dropped still has objects. In order to drop the user and all his objects, use key word cascade.
Like,

drop user DEV_MDS cascade;

drop user DEV_BIPLATFORM cascade;

Make sure that you have Admin privileges. Or connect as sys user and delete the user.  

BI Publisher Parameters in the URL

Through this post am discussing about the parameters specified in the report link / URL

Consider a URL like this

http://<ip/address>:<Port>/xmlpserver/Sales/Sales+Report/Sales+Report.xdo?_xpf=&_xpt=1&_xdo=%2FSales%2FSales+Report%2FSales+Report.xdo&Id=1-104x&_xt=Standard&_xf=html

The URL after the report name consists of:

?_xpf=&_xpt=1&_xdo=%2FSales%2FSales+Report%2FSales+Report.xdo&Id=1-104x&_xt=Standard&_xf=html

Note the following standard URL syntax:

? - The first parameter is added with a question mark in the beginning.

& - Additional parameters have to be specified like this.

The BI Publisher parameters are as follows:

_xpf - Its an application internal string. Not to be used by the developer.
_xpt - Chooses the report rendering way or style.

    0 - uses the BI Publisher window (iFrame)

    1- renders just the document

_xdo - Provides the path to the current report. To be note that it is not mandatory to give this parameter.

dept - Report specific parameter that we created in the report.

_xt - Specifies the template to be used. Usually for the reports which have more than one templates.

_xf - Controls format of the output file. Accepted values are: pdf, html, excel, rtf, or data.

ODBC not showing Oracle DB Driver, Windows 7

Most of the Win 7 users go for the 64 bit OS. Here in this OS let us install Oracle DB 32 bit. After the install go to run then type "odbcad32".

While trying to create an odbc connection to our db we wont be able to see the driver of our Oracle db.
The reason is that, its a naming convention in windows that ODBC should be called by "odbcad32". Even though you type odbcad32 its pointing to the 64 bit version of it. You can see this 64bit odbc from "c:\windows\system32". Since our driver is only 32 bit it wont get listed here.

The solution to this issue is go to your "C:\Windows\SysWOW64\odbcad32.exe" (Here I assume you have installed OS in C drive itself).This is the path to the 32 bit version, in this odbc you can see your 32 bit driver.