Tuesday, August 20, 2013

OBIEE: Changing Default Chart Colors

To change default chart color series navigate to (difference is highlighted):

OBIEE 11.1.1.7.x
<ORACLE_HOME>/Oracle_BI1/bifoundation/web/msgdb/s_FusionFX/viewui/chart/dvt-graph-skin.xml
Older versions:
<MW_HOME>\Oracle_BI1\bifoundation\web\msgdb\s_blafp\viewui\chart\dvt-graph-skin.xml

Add the following <SeriesItems> tag before </Graph>
Note: You can add as many <Series id="n" color=.... /> as you wish.

<SeriesItems>
<Series id="0″ color="#ff0000″ borderColor="#ff0000″/>
<Series id="1″ color="#00ff00″ borderColor="#00ff00″/>
<Series id="2″ color="#0000ff" borderColor="#0000ff"/>
</SeriesItems>


</Graph>

Save your changes and exit. ALWAYS make sure to take a back-up of the original file.

Note 2: Changes are effective immediately; however make sure to clear your browser cache and there is no need to restart any OBIEE services.

Hope this helped!

Monday, August 5, 2013

OBIEE 11g: Data-Level / Object-Level Security - Query Limit

To set query limit and number of minutes a query can run per physical layer database connection, follow the below steps:

1. Login to Repository using OBIEE Admin Tool
2. Go to Manage > Identity
3. Go to Application Role tab, choose the role and double click on it to open.



4. Click on Permissions tab



5. Set the Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege.



Hope this helped!

OBIEE 11g: Query Tuning / Friendly Alternative for CURRENT_DATE

Using in Analysis:
"Date_Column" IN (TIMESTAMPADD(SQL_TSI_DAY,-1,CURRENT_DATE))
This will return yesterday's date - it is an alternative to CURRENT_DATE - 1.

Using Dashboard Prompt:
SELECT TIMESTAMPADD (SQL_TSI_DAY,-1,CURRENT_DATE) 
FROM "Subject_Area_Name"