Tuesday, December 18, 2012

OBIEE Images and Pictures

For the previous posts about Narrative, I needed to have images on my BI server, available for access via URL. 
My server names is bdahab-il, it's a simple installation, so the port is 7001. I installed OBIEE in the c:\or\bi folder.
I placed an image (Good_Morning1.jpg) on the server at C:\or\BI\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war
(INSTALLATION_FOLDER\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war) and received Error 404 when tried the appropriate URL (http://bdahab-il:7001/analytics/Good_Morning1.jpg) :

And said @#!$%%!!
Restarted the server...Then the URL http://bdahab-il:7001/analytics/Good_Morning1.jpg
worked. Please note it's case sensitive, Good_Morning1.JPG wouldn't work.

Talking about images... just a reminder: Oracle has a set of images on the server. They are placed by default at:  INSTALLATION_FOLDER\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war\res\s_blafp\images. 
You can access them using fmap:images/name. For example, the logo here: 

is referred as fmap:images/report_medicalResearch.jpg 

You usually use them in the Logo and when creating conditional format with your own images:
The result for example is:


So if you want to see the entire library Oracle prepared for fmap, visit
INSTALLATION_FOLDER\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war\res\s_blafp\images 
Here is a picture of them:
And one more reminder: if you want to add images that are not lost each upgrade, create your own skin and style as described at the white paper Customizing Oracle Business Intelligence Enterprise Edition 11g.

You might want to read Gerard Nico on the issue http://gerardnico.com/wiki/dat/obiee/image. There is one point I don't agree with him totally, and that is: picture presentation in a report. The easiest way is to have the URL for the image in a column as value (or directly at my example) and define the data format as image URL:

  
 
Results in:


2 comments:

  1. Great tip!, Only this isn't working if you have DTAP environments, you have to make the URL indipendent with a FMAP:https://gerardnico.com/wiki/dat/obiee/obips/fmap

    ReplyDelete
  2. Hello, the whole thing is going sound here and ofcourse every
    one is sharing data, that's in fact fine, keep up writing.

    ReplyDelete