OBIEE Logo and Message Customization

Customize Brand Name

We have few changes in productmessage.xml and common.xml file for customize the Brand name

Changes in productmessages.xml:

we need to edit the productmessages.xml file for brand name change, which file is placed below specified path.

Obiee installation folder\Oracle_BI1\bifoundation\web\msgdb\l_en\messages

Before edit the productmessages.xml file:

<WebMessage name="kmsgHeaderBIBrandName"><TEXT>Business Intelligence</TEXT></WebMessage>

After edit the productmessages.xml file:

<WebMessage name="kmsgHeaderBIBrandName"><TEXT>Management Reporting</TEXT></WebMessage>

Changes in common.xml:

we need to edit the common.xml file for change the font size and color, which file is placed below specified path.

Path :

E:\apps\OBIEE11g\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\analyticsRes\sk_sapient\b_mozilla_4

Changes in common.xml file:

We have to change below script in common.xml

Before change the script

HeaderBrandName

{

font-size:14px;

font-weight:bold;

font-family:Tahoma;

position:absolute;

left:130px;top:2px;

color:#0d4a8b;

font-size:17px;

white-space:nowrap;

overflow:hidden;

text-overflow:ellipsis;

display:inline-block;

}

After change the script

HeaderBrandName

{

font-size:14px;

font-weight:bold;

font-family:Tahoma;

position:absolute;

left:130px;top:2px;

color:#F15D22 ;

font-size:17px;

white-space:nowrap;

overflow:hidden;

text-overflow:ellipsis;

display:inline-block;

}

Save it.

Restart the opmn services

Note: Before do changes, We should take backup of xml file and css file. We should take care of all changes. These are very sensitive changes.

Agent / BI Scheduler information are stored in OBIEE 11g tables

Configuring iBot in OBIEE 10G

OBIEE 10G - BI Scheduler / iBots are configured in RPD under Scheduler Configuration.

Under Scheduler tab > Database you will enter DB details to connect schema.

System table will be as below

For Storing Jobs                          : S_NQ_JOB

For Storing Instance Information          : S_NQ_INSTANCE

For Storing Error Messages         : S_NQ_ERR_MSG

For Storing Parameters               : S_NQ_JOB_PARAM

Configuring Agent in OBIEE 11G

In OBIEE 11g at the time of installation we install Repository Creation Utility (RCU), it will create BI Scheduler database called BIPlatform tables will be same as in 10G.

For Storing Jobs                          : S_NQ_JOB

For Storing Instance Information          : S_NQ_INSTANCE

For Storing Error Messages         : S_NQ_ERR_MSG

For Storing Parameters               : S_NQ_JOB_PARAM

Login to enterprise manager in and go deployment tab and then click on Scheduler tab.

Enter the information to connect with schema and your agent is configured now.

Configuring Mail Server:

Now go to Mail tab and enter mail server (SMTP) details, this server will be used to send reports through OBIEE Agent.

how to use presentation vaiable in direct db request for date in between

 Use presentation variable in direct db request for date in between


Use below format for between filter in direct db request in OBIEE.
Here v_date is presentation variable

to_char(trunc(day_dt),'YYYY-MM-DD') between substr('@{v_date}{2001-01-01}',1,instr('@{v_date}{2001-01-01,}',',')-1)
AND SUBSTR('@{v_date}{2020-01-01}',INSTR('@{v_date}{2020-01-01}',',')+1 )

Disable Case sensitive search features in prompt –OBIEE

1. Disable Case sensitive search features in prompt –OBIEE :

Requirement:

Whenever a user selects some parameter from the Dashboards Prompt, the filters are applied to the report accordingly. The case of the parameter is also taken in to consideration while filtering the report. However, the users want to disable case sensitive search in obiee

The CASE_SENSITIVE_CHARACTER_COMPARISON parameter in the NQConfig.ini file controls the case sensitive search within OBIEE. The CASE_SENSITIVE_CHARACTER_COMPARISON parameter is only meant to describe the BI Server case sensitive setting not the Database. In other words it doesn't affect the DB queries, only data that has been cached by the BI Server is affected by this parameter.

Hence we can include the following command in the connection pool of the repository.

Alter session set NLS_SORT=BINARY_CI

Alter session set NLS_COMP=LINGUISTIC

write above script in 'Connection Script'

 2.Custom Error Messages –OBIEE :

 

Requirement:

           

            If a report shows any error, user wants a custom error message to be displayed instead of OBIEE default message. Also this message will contain a link to a help portal where user can raise a ticket for the incident.

Solution:

            The default OBIEE messages are stored in the directory <InstallDirectory>:\OracleBI\web\msgdb (on windows machine). The msgdb folder contains many subfolders different languages. The folder l_en contains web messages for the language English. The folder l_en\messages contains a file odbcaccessmessages.xml. We can modify this file in order to include our custom error message.

The screenshots are given below

1.            The default English UI messages are stored in the folder <InstallDirectory>:\OracleBI\web\msgdb\l_en

2.            Open the file odbcaccessmessages.xml in notepad.

3.            Change the content of the WebMessage kmsgOdbcAccessOdbcException with the custom error message. In order to add a link (HTML Anchor Tag), we have to put one more tag i.e. <HTML> immediately after the WebMessage opening tag as shown in the screenshot. This way the anchor tag will be treated as HTML content while showing on the UI.

Clear selected filters from prompt in OBIEE (clear button)

Below HTML will clear selected filters from OBI prompt except default selection.

<div class="XUIPromptEntry minibuttonOn"><a href="#" onclick="return PersonalizationEditor.removeDefaultSelection(false)">Clear</a></div>

Open Report on Criteria tab when click on analyze or edit button in OBIEE 11g

Open report on criteria tab when we click on edit/analyze button

In OBIEE 11g when we Edit / Analyze the report by default we land up to Result tab which takes long time for big reports. And it’s time consuming when we doing  R&D in report.

We have option under My Account to change this setting. Some of you might be knowing it, but just wanted to share.

Go to My Account > Preferences and change  Analysis Editor option to Start on Criteria tab when editing Analysis. See below sanpshot.

Cheers!!

Ashish

Hide headers / Menu in OBIEE 11g

Just wanted to share some findings with you all.

If you want to hide headers in OBIEE 11g then here some good content for you.

Sometimes user want to embed OBIEE page content in some kind of web application.

localhost.com:9704/analytic/saw.dll?PortalPages&PortalPath= (path of your dashboard page)

For example: For weblogic user My Dashboard – Page1 path will be

localhost.com:9704/analytic/saw.dll?PortalPages&PortalPath=%2fusers%2fweblogic%2f_portal&Page=page 1

Cheers!!
Ashish