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!

Unexamined life...

"The unexamined life is not worth living!" - Socrates

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"

Principle of Algorithm...

"Perhaps the most important principle for the good algorith designer is to refuse to be consent." - Aho, Hopcroft, and Ullman, The Design and Analysis of Computer Algorithms, 1974

A question we should always ask is: Can we do better?

Words of Winston Churchill came true...

"Power will go to rascals, rogues, freebooters...
All leaders will be of low caliber & men of straw...
They'll have sweet tongues & silly hearts...
They will fight amongst themselves for power & the two countries will be lost in political squabbles...
A day would come when even air & water will be taxed."

We as Society worked too hard to make his Words true...

OBIEE: Alert / Pop-up Message for Dashboard

To add alert type pop-up message in OBIEE dashboard, follow these steps:

1. Edit Dashboard and Add Text

2. Check "Contains HTML Markup"

3. Paste below code - feel free to edit/modify HTML as you wish

<html>
<head>
<script>
alert(" STRICTLY CONFIDENTIAL \n NOT FOR DISCLOSURE OUTSIDE OF COMPANY\n \nIMPORTANT NOTICE: Hello World.")</script>
</head>

Hope this helped!

SQL: How to Know / Query current Schema Privileges

If you are connected from desired schema to the database, run below query to know its granted privileges:

SELECT * FROM SESSION_PRIVS;

Success...

"If you want something you've never had, you must be willing to do something you've never done." - Thomas Jefferson

OBIEE 11g: 11.1.1.7.1 Patch is Released

OBIEE 11.1.1.7.1 patch has been released and can be downloaded here.