Display Data Base Images on report

Inspired by one of post in OTN forum on how to populate data base images on a native report, here assumptions are database having image URL, images are residing in image resource folder.

To do that first keep all images files in OracleBI\web\app\res\s_oracle10\images i.e fmap:images\xyz.jpg

Keep all image file names (with file extn) in database as required.

Exp: Suppose geo dimension with

South as south.jpg

West as west.jpg

East as east.jpg,

North as north.jpg

To display images on report:

Add image’s column to report

(Just to illustrate example I have added image file names in ERROR_TEXT in Usage track Schema.)

Click on Column Properties, go to Data Format tab

Check “Override Default Data Format” and from drop down choose “Custom Text Format”

In Custom Text Format edit box place following script.

@[html]" < !-- img src="\\analytics\\res\\s_oracle10\\images\\""@H""" -- > "(Please uncomment html tags)

Browse report, images url's will be fetched from database appended with resource file displayed on report.

Here is a good example on how to embed image on a web page with various options.