Blog

Key Notes

In this document the information is customized to reflect a step-by step approach to the installation and configuration of the OBIEE 11g software.

 Software Downloads

 1. OBIEE11g

 http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/business-intelligence11g-240521.html

 2. RCU (Repository Creation Utility)

 http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/business-intelligence11g-240521.html

 3. Essbase Client

    http://edelivery.oracle.com/

 Installing and Configuring a Database

Installation of Oracle Business Intelligence requires the availability of a database. The database must be up and running, and does not have to be on the same computer where you are installing the components. The database must also be compatible with the Repository Creation Utility (RCU), which is used to create the schemas required by Oracle Business Intelligence. Oracle Business Intelligence requires that certain schemas exist in the database before installation. You must run the Repository Creation Utility (RCU) to create the schemas in the database.

Below is the path for the Repository Creation Utility.

 Run rcu.bat file on windows environment from the below path: rcuHome\BIN\rcu.bat

 To create the Oracle Business Intelligence schemas using RCU:

1. Start RCU

 2. Select Create and click next

 3. Give all the required Database Connection Details

 4. Checking Prerequisites

 Press Ignore

 The Checking Prerequisites screen opens

 5. Select Create a new Prefix in Select...

Tags: essbase client install for obiee11g, obiee 11g, upgrade from 10g

Adding Few extra steps in configuring which I followd

ref: iphone Oracle Documentation, Apache configuration Doc

Oracle Business Indicators - Configuration and User Guide

• whether or not you want to run Apache for all users (installing Apache as a Service), or if you want it installed to run in a console window when you choose the Start Apache shortcut.
• your Server name, Domain name and administrative email account.
• the directory to install Apache into (the default is C:Program FilesApache GroupApache although you can change this to any other directory you wish)
• the installation type. The "Complete" option installs everything, including the source code if you downloaded the -src.msi package. Choose the "Custom" install if you choose not to install the documentation, or the source code from that package.

Tags: obiee iphone configuration

All the times the reports start loading with out selecting a prompt values, in the dashboard for all values unless other wise the promps are defaulted.

If data level securities are enables on prompt columns then defaulting is a bit trouble some.

For this use of Presentation variables and Guided navigation is the best way of handling reports in Dashboard.

I am not providing Visual explanation, please let me know if some one require, I will post

Here we go:

For suppose there are 3 columns in a dashboard prompt named as

x,y,z

assign values of x to a presentation variable a.

assign values of x to y presentation variable b.

assign values of x to z presentation variable c.

Now built a report with the same columns 'Control Report'

xyz.

Add filters to the report as

x equal to presentation variable @{a}

y equal to presentation variable @{b}

z equal to presentation variable @{c}

Now,

go to edit dashboard , Go to the report section ,

You find guided navigaion under section properties,

Select 'yes' for reference Source...

Tags: guided navigation obiee

"Please check Oracle Client is instaaled"

This is due to user.sh file not updated for OBIEE

You will find the file under [OBIEE path]/OracleBI/setup/user.sh

edit this file with all the Database variables

ORACLE_HOME and others.

run the file by

# ./user.sh

Then start the repository, everything should be fine now

Reason not know, but the Quick solution is

enable collapsible for all sections in Dashboard, and check the results. Should be fine.

Tags: collapsible, guided navigation, obiee

For suppose if you drill for some levels down a dashboard and frome there if you want to come back to first where you started and with out loosing your prompt values selected, then

Use the following script as a button :

<script>

if (typeof(onCustomNavigate) == 'undefined')
{onCustomNavigate = function(aValues, sNavPortalPath, sNavPortalPage)
{ var sURL = saw.commandToURL("Dashboard") + "&Action=Navigate&PortalPath="+saw.encodeURIComponent(sNavPortalPath) +"&Page="+saw.encodeURIComponent(sNavPortalPage);

for (var i = 0; i < aValues.length; i++)
{ sURL += '&col'+ (i+1) + '=' + saw.encodeURIComponent(aValues[i][0]) + '&op' + (i+1) + '=' + 'eq' + '&val'+ (i+1) + '=' + '\"' + saw.encodeURIComponent(aValues[i][1]) + '\"';
}
saw.runThisURL(sURL); return false;}}
</script>

<table>
<tr>
<td>

<a href="javascript:void(null)"

onclick="onCustomNavigate([], 'DashBoard Path', 'Dash Board name');

return false;"><button type="button">HOME PAGE</button></a>
</td>
<td>&nbsp;</td>

Here you go!!!!!!!!!!!!!!!!!!

Tags: home page, obiee dashboard

: O9XNZMXB.

Just go to catelog manager with administrator, delete the 'user' folder from 'users' folder , try log in again.

Other way - login with administrator

go to manage catelog

/ : users

Delete the username any any folder with that name.

Try login again.

Hope this helps.

:)

Tags: obiee login error, usersuser_namw_portal

One xml file named

writeback.xml should be missing or difference in content.

The path of the file is

[OBIEE Installation]/OracleBIData/web/msgdb/customMessages

And

[OBIEE Installation]/OracleBI/web/msgdb/customMessages

Both the places the file should exist.

WebMessage name is causing the issue for update button grayed out .

In Table view of the report, Writeback properties, the Template name should be equal to WebMessage name above in XML.

Here you see the example :

Configure SSH for User Equivalence

During the installation of Oracle RAC 10g Release 2, OUI needs to copy files to and execute programs on the other nodes in the cluster. In order to allow OUI to do that, you must configure SSH to allow user equivalence. Establishing user equivalence with SSH provides a secure means of copying files and executing programs on other nodes in the cluster without requiring password prompts.

The first step is to generate public and private keys for SSH. There are two versions of the SSH protocol; version 1 uses RSA and version 2 uses DSA, so we will create both types of keys to ensure that SSH can use either version. The ssh-keygen program will generate public and private keys of either type depending upon the parameters passed to it.

When you run ssh-keygen, you will be prompted for a location to save the keys. Just press Enter when prompted to accept the default. You will then be prompted for a passphrase. Enter a password that you will remember and then enter it...

Tags: cluster, oracle db, rac