Using Presentation variables in dashboard

We can use presentation variable to assign values in dashboard prompts. To refer these variables in answers following syntax should be used:

'@{PresentationVariable}{Default}'

The benefit of using this is we don't have to make a RPD change. Besides by specifying a default value, the report returns value even when users edit the report in answers. This should be used if business users will edit the reports.

Adding a custom image on dashbaords

save logo as jpg, then copy to \OracleBI\web\app\res\s_oracle10\images\ on server, then you can use it like any other report logo. Code for the same is;

We use following code to embed logo besides the report name and report description:

<table class="TitleTable" cellspacing="0" style="" width="100%"><tr><td class="TitleLogo" style="" rowspan="4"><img border="0" src="res/s_oracle10/images/report_salesVolume.jpg"></td><td class="TitleCell" style="" title="">Sales Summary</td></tr><tr><td class="TitleNameCell" style="" title=""></td></tr><tr><td class="SubtitleCell" style="">Provides a summary of both direct and indirect sales dollars & units for selected customer and time period.</td></tr></table>

OBIEE Sawserver Memory Issue

Many times BI sawserver memory keeps increasing but is not released once reports are not run. To manage force release of unused memory following parameter in instance config file is useful:

<AutoFlushThreshhold>262144</AutoFlushThreshhold>

PDF download Issues

We had an issue with downloading PDF files which were large. By increasing default PDF cache size in instance config file as below we were able to download large PDFs too.

File to be changed is located at:

d:\OracleBIData\web\config\instanceconfig.xml


Lines to be added:

<JavaMinHeapPDF>200000000</JavaMinHeapPDF>
<JavaMaxHeapPDF>200000000</JavaMaxHeapPDF>


The min java heap size can be reduced, but we kept this just to verify if this change is helping PDF to download.