Override Session Variable in Answers

If you wanted to override a session variable and disable cache hits, you would use a syntax like the following in Answers Advanced Tab
SET VARIABLE LOGLEVEL=4, DISABLE_CACHE_HIT = 1;

SET VARIABLE OU_ORG=128;

 

Performance Tuning Tips for OBIEE

1. implement caching mechanism
2. use aggregates
3. use aggregate navigation
4. limit the number of initialisation blocks
5. turn off logging
6. carry out calculations in database
7. use materialized views if possible
8. use database hints
9. alter the NQSONFIG.ini parameters

http://www.oraclebidwh.com/2010/02/performance-tuning-in-obiee/

OBIEE is not an ETL tool!

just a reminder for whom using OBIEE as Excel Extraction tool;

"OBIEE is not an ETL tool. It is NOT designed to handle large amounts of non aggregated data. It’s designed to handle dimensional structured data with sufficient aggregation tables."

Changing the Connection Pool from Answers

Keeping Leading Zero's in Answers

Nice way to keep leading zero’s when exporting to excel from within OBIEE:

Add “mso-number-format:\@” to the Custom CSS Style Options of the appropriate column in the OBIEE report.

Excel rotating style

mso-rotate:90