Showing posts with label Oracle BI. Show all posts
Showing posts with label Oracle BI. Show all posts

Thursday, July 14, 2011

How to Bypass cache in OBIEE

Follow below steps to disable the cache of the report to get results direct from the database;

 1. Build Report with required fields,
 2. Go to Advance SQL tab check the Check Box ' Bypass Oracle BI Presentation Services Cache'
 3. Goto bottom of page and add below statement in the prefix section
     SET VARIABLE DISABLE_CACHE_HIT=1;
 4. Save the report


Wednesday, July 13, 2011

How to add images in OBIEE using local path

1. Upload the images to following two folders

D:\ORAHome\j2ee\home\applications\analytics\analytics\res\s_oracle10\images
(Oracle application server install)

D:\OracleBI\web\app\res\s_oracle10\images
(OBIEE install)

2. After adding images to the folders you need to restart the presentation services

3. In answers, edit the title view and add the following

   fmap:images/your_namename.gif

4. In dashboard you can use the same with image or link

   fmap:impages/your_gif.gif