Thursday, June 16, 2011

Image Prompts in OBIEE

We will see how to create image prompts in OBIEE with an example of our AP MAP.


In our example, our aim is to display the district details when we click on a particular district in MAP.


We use the following image in our prompt..



1. Create a folder "images" in the following location and copy the above image in "images" folder.
    D:\OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics


2. Restart oc4j


3. Check whether you are able to access the image using the following URL
    http://localhost:9704/analytics/images/AP-Map.png


4. Consider the following criteria using the MAP table(in my example):


5. Goto "Prompts" tab and select image prompt



6. Enter the details as follows


Use the following map code and click "Extract Image Map from HTML"
(We are doing image prompt only for 3 districts in the map in this example)



<MAP NAME="map1"> 
<AREA HREF="Krishna.html" ALT="Krishna District" TITLE="Krishna" SHAPE=RECT COORDS="214,192,272,210"> 
<AREA HREF="East Godavari.html" ALT="East Godavari District" TITLE="East Godavari" SHAPE=RECT COORDS="301,153,373,175"> 
<AREA HREF="Chittoor.html" ALT="Chittoor District" TITLE="District" SHAPE=RECT COORDS="117,397,168,419"> 
</MAP>


7. You will get the image map as follows:


8. As you want to see the district details while clicking on each district, enter the columns and values as follows:


 9. Click Ok, Test Prompts and save it.


Now you can see the image prompt will navigate us to the details of specific district, we click on..