Extra Pages

▼

Wednesday, April 1, 2009

OBIEE Image prompt

Just a nice gimic, the OBIEE image prompt. First get a image, I used this one: http://www.faqs.org/docs/htmltut/images/testmap.gif

Create a image prompt:

image

image

Next use the HTML SHAPE tag to add the coordinates: http://www.faqs.org/docs/htmltut/images/_AREA_SHAPE.html

<MAP NAME="map1"> <AREA HREF="contacts.html" ALT="Contacts" TITLE="Contacts" SHAPE=RECT COORDS="6,116,97,184"> <AREA HREF="products.html" ALT="Products" TITLE="Products" SHAPE=CIRCLE COORDS="251,143,47"> <AREA HREF="new.html" ALT="New!" TITLE="New!" SHAPE=POLY COORDS="150,217, 190,257, 150,297,110,257"> </MAP>

image

Press Extract Image Map from HTML

image

add the column and value.

Till Next Time

at

13 comments:

  1. Christian BergApril 1, 2009 at 9:28 PM

    Gotta say it: LOL ;-)

    ReplyDelete
  2. kartAugust 31, 2009 at 3:28 PM

    Hi john,

    I need to create prompt from the pie chart. If a user clicks on a particular section of pie chart it should open up another report and the corresponding value needs to be passed as a prompt value.

    ReplyDelete
  3. AnonymousSeptember 3, 2009 at 9:11 PM

    lets,

    It sounds like what you want to do here is create the pie chart as a view in your request. Then on the Interaction tab under Additional Charting Options, select Navigate and indicate which request you want the user to be sent to. Just make sure the appropriate column has an "is prompted" filter on it in the target request.

    ReplyDelete
  4. UnknownNovember 6, 2009 at 2:14 PM

    Hi John,
    Would it be posible to go from one image prompt to a new image prompt, lets say show a world map and user clicks on North America it would then show the user a US and Canada map to select on. Let me know if this is possible.

    ReplyDelete
  5. John MinkjanNovember 8, 2009 at 3:03 PM

    @ronald.maus,

    Sounds more like Oracle Spatials or even better wait for OBIEE 11G.

    Regards

    John

    ReplyDelete
  6. AnonymousJune 3, 2010 at 12:01 AM

    Hi John,

    First of all thanks a lot for your blogs!

    I know we can do map drill down with Oracle Mapviewer and Spatial, or as you said OBIEE 11g. But is it possible to do some of the same functionality with javascript and using Navigation command?

    I tried putting a narrative view on a map as IFRAME
    src=http://40.110.140.230:7777/dashboardfiles/map.gif height="600" width="100%" href=http://40.110.140.230:7777/analytics/saw.dll?GO&NQUser=Administrator&NQPassword=Administrator&Path=/shared/Dashboard+Mockups/DistrictEastern&Action=Navigate></IFRAME

    I can see the map image but upon clicking on the map image it doesn't navigate to the target report.

    ReplyDelete
  7. CoquesJune 3, 2010 at 5:47 PM

    Is there a way to make the colors of the image change according to the conditional formats of the report?

    ReplyDelete
  8. John MinkjanJune 17, 2010 at 8:01 AM

    @Anonymous check out Venkat blog on integrating mapviewer

    ReplyDelete
  9. John MinkjanJune 17, 2010 at 8:02 AM

    @Coques,

    Not that i'm aware of....

    Regards

    ReplyDelete
  10. CoquesFebruary 7, 2011 at 9:28 PM

    Hi John, i am working on this same issue for the 11g version. Can you please help me figure out how or where to put the image on the weblogic server, rather than on the oc4j, it seems different!

    ReplyDelete
  11. debMay 25, 2011 at 12:41 PM

    thank you for your post! Very useful

    ReplyDelete
  12. Hari PrasadApril 27, 2012 at 10:13 AM

    This comment has been removed by the author.

    ReplyDelete
  13. Hari PrasadApril 27, 2012 at 10:16 AM

    I wanted to implement the Geo and struggled to get map view and then again struggled to get the data to map it with. It is pain here in OBIEE. Now you can achieve this thing easily with image prompt by having appropriate column in your data set(Say continent mapped with Geo). And also images can be customized easily for user needs. Might not suffice for deep down analytics, but believe me. Most of our requirements can be solved by this.

    ReplyDelete

Note: Only a member of this blog may post a comment.