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
Showing posts with label Oracle BI. Show all posts
Showing posts with label Oracle BI. Show all posts
Thursday, July 14, 2011
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
Subscribe to:
Posts (Atom)