"Live, Learn, Apply & Educate!": July 2013

Wednesday, July 31, 2013

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...

Monday, July 22, 2013

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;

Tuesday, July 9, 2013

Success...

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

Monday, July 8, 2013

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.

Wednesday, July 3, 2013

OBIEE: Enable Log-Level from Report / Analysis

To get OBIEE generated SQL in an environment where LOG is disabled, you can enter below statement in Advanced tab of the report/analysis and click Apply.

SET VARIABLE LOG_LEVEL = 2;

Now you will be able to view Log from Administration > Manage Sessions.