OBIEE Default colour Title border

Good a quick question on how to set the default Titleborder colour in OBIEE to red.

Go to your view.css directory in ..s_MyCompagny\b_mozilla_4

Locate this part and change the colour:

/* ***** */
/* Title */
/* ***** */

.TitleTable {
    font-family: arial, helvetica, sans-serif;
    border-width: 0 0 4px 0;
    border-style: solid;
    border-color: #FF0000;
}

If you are on OC4J don't forget it to copy to applications directory: ...oc4j_bi\j2ee\home\applications\analytics\analytics\res\s_MyCompagny\b_mozilla_4

Till Next Time

OBIEE Title View

In one of my earlier enrties: http://obiee101.blogspot.com/search/label/NARRATIVE%20VIEW I told that you are restricted in the in the usage of variables of in Title views.
On searching the net I found this document: http://blogs.oracle.com/siebelessentials/oracle%20bi%20ee%20variables%20overview.pdf which triggered me to revisit the subject.
It seems that using the biServer.variables prefix gives you a far more control, allowing you to use all your repository and sessions variables.

@{biServer.variables['NQ_SESSION.USER']}
@{biServer.variables['BI_EE_HOME']},

Till Next Time

OBIEE Adding session variables to the report title / using a narrative view

A lot of times we find in the request for reports "please put the value of the used report variables in the title".
But when you try that you quickly run into trouble. By default you are confined to only the predefined ones:

From the OBIEE documentation:
To show your own defined variables (repository/session/presentation) in OBIEE you have to use the narrative view.
First you have to add the variable(s) to your query:

Then alter the column properties, set the column hide property.

Next open a Narrative view, set your descriptive text, the variables are referenced by there a @ and there column number (in this case 2)

Set the rows to display to 1

Reorganize your compound lay-out so that your narrative view is directly below your title

Till Next Time

Sometimes you stand corrected see: http://obiee101.blogspot.com/2008/09/obiee-title-view.html

OBIEE referencing session variables in report title

After spending way to much time figering out the exact lingo, I decided to blog them for futher reference:

• currentTime => @{system.currentTime}
• system.productVersion => @{system.productVersion}
• session.locale => @{session.locale} = en-gb
• session.language => @{session.language} = en
• rtl =>@{session.rtl} = false
• session.loginTime => @{session.loginTime}
• session.logoutTime =>@{session.logoutTime }
• session.lastAccessTime =>@{session.lastAccessTime}
• session.currentUser => @{session.currentUser.id} = administrator
• user.homeDirectory => @{user.homeDirectory} = /users/administrator
• user.id => @{user.id} = administrator
• user.displayName => @{user.displayName} = administrator