Friday, 31 August 2012

Changing the background color on hovering in OBIEE

When there is a requirement to have background color to appear on hovering over the text then the below code will help you out.
Use the below code in the Text inside the section with the HTML check box enabled.

<script type="text/javascript">
function changeColor(id, color) {
element = document.getElementById(id);
event.cancelBubble = true;
oldColor = element.currentStyle.background;
element.style.background = color;
}
</script>
<div id="left1" onMouseOver="changeColor(this.id, '#81DAF5');" onMouseOut="changeColor(this.id, '#FFFFFF');"><font size=2>Sample Text</font></div>

The use of div here is to restrict the color change on the particular section only. If we use Body bgcolor, it will  change the color for the whole page.
And in conditions where there are multiple sections, just add the above code and change the div id values.
Hope this will help many people out there. Thanks to javascript :)

Comments are always welcome...
 

Thursday, 23 August 2012

Customizing in OBIEE 11g

Found good materials for customizing OBIEE 11g/ 10g.

One from Rittman-
http://www.rittmanmead.com/files/biforum2012/masterclass/RM_BIForum12_Cust2.pdf

and also material from Oracle-
http://www.oracle.com/technetwork/middleware/bi/customizing-oracle-biee-11g-176387.pdf

http://docs.oracle.com/cd/E25178_01/bi.1111/e10541/answersconfigset.htm#BABBDHHD
http://docs.oracle.com/cd/E25178_01/bi.1111/e10541/answersconfigset.htm#CIHJDHGI

For removing 'Preparing for Guided Navigation' Text in 10g
http://obiee1000.blogspot.in/2012/01/hide-message-preparing-guided.html?showComment=1347426536087

Sub Tabs in OBIEE 10g
http://www.eeblog.org/index.php/obiee-10g-nested-tabs-by-embedding-a-dashboard-into-a-page/#more-502

Currency change options
http://docs.oracle.com/cd/E21764_01/bi.1111/e10541/configcurrency.htm#BABFDFIC

Hope this helps all.


 

Tuesday, 7 August 2012

Changing the Date Format from Presentation Variable

In OTN forum I came across a requirement, where the user wanted to change the date format of a presentation variable value.

Assuming the presenatation variable value is acquired through a prompt, I am proceeding by creating a report with a column which is filtered with this presentation variable.


The column in a report which is having a default value with the presentation variable.

Next is to change the data format of the date column, so that we change the format of the date column on receiving the value from the prompt.



Final result.


Comments are always welcome...