Thursday, 12 April 2018

OBIEE 12c – Change the default 25 rows per page setting

Here’s how to change the default setting of 25 rows on a table and pivot table in OBIEE analyses when setting a report to Content paging.  

Yes, you can set it when you change the report to content paging, but this often gets forgotten, or you may want change to defaults for many reports that have already been created without having to edit each report individually.

To make it clear, this is what we are talking about – the ‘Rows 1 – 25’ with up/down/all icons at the bottom of a table or pivot table:

This setting is controlled by two tags in the instanceconfig.xml file, which can be located at <obiee_home>/user_projects/domains/bi/config/fmwconfig/biconfig/OBIPS/instanceconfig.xml

You will need to make two changes to this file, one each for tables and pivot tables.
Edit this file in a text editor and locate the <Table> and <Pivot> tags:

Note, this screenshot displays the default out the box contents of the instanceconfig.xml file, your file may have other tags already within these sections.
In here you need to add two more entries for the <MaxVisibleRows> and <DefaultRowsDisplayed> tags:


You can set the number to be anything you want for the default number of rows displayed, although I wouldn’t make it ridiculous…setting it to 10000 will just cause memory/display problems for your browser.  The numbers must however be the same. If they are different OBIEE will take the lower of the two numbers as the new default.

You must also include both entries, if one is missing it will default to 25 and as that will probably be lower than the entry you have included, 25 will remain the default in the reports.
Add these two lines within both <Table> and <Pivot> sections. If you only add it to one, the other will remain at the default 25 rows.

You then need to restart the presentation services component (or simply restart all of OBIEE, whichever is easier for you), then simply re-open your report:

You can still override this setting with the rows per page in the view properties window for individual reports if desired.

I’ve done this in OBIEE 12c, version, but I suspect it will probably work in previous 12c versions and possibly 11g as well.


Tuesday, 7 October 2014

Replacing the Home page within OBIEE

Replacing the Home page within OBIEE with a more friendly “Welcome to the BI System” is becoming a more popular thing to do - many of our clients now have this:


With something like this:


As well as being the first page the users see when they login, we also change the ‘Home’ link in the dashboard menu bar to point to this page as well, so the users can quickly return to it at any time.

The standard method of changing the login page for users is to use the PORTALPATH repository variable, but with some recent patches there have been problems with this so we’ve come up with an alternative method using an HTML redirect within the home page itself.

Changing the Home link is a common task and there are other blogs around which show how to do this, but I’ve included it below as well.

Changing the login page

Our new method of doing this is to use standard HTML code and embed a redirect within the home page. This home page still exists, but the redirect just prevents the users from seeing it.

To do this you need to edit the bieehome.htm file.

There are two possible locations for this. The main location is under:


However you may have already copied this to the OracleBIPresentationServicesComponent directories if you’ve made other customisations:


Take a backup copy of the file bieehome.htm then edit it.

Search for the line:

<body class="HTMLBody">

and beneath it add the following 8 lines, replacing the URL with the appropriate URL for your welcome page  - copy from the browser address bar and replace everything to the left of /analytics with two dots (..)

<p align="center"> </p>
<script type="text/javascript">
function Redirect()
  location.href = '../analytics/saw.dll?dashboard&PortalPath=%2Fshared%2FWelcome%2F_portal%2FWelcome to BI';

save the file.

This will come into effect after OBIEE is restarted, which we’ll do later.

Change the 'Home' link

Now we need to change the Home link in the dashboard menu bar:

For this we need to edit a javascript file, header.js

This can be found in the directory:


Take a backup copy of it first then edit it.  You need to be careful now, this script in this file is quite complex and the syntax needs to be perfect for it to work. The code is also all on one line, so it’s not that easy to see where you are.

Search for the string:

Now replace the code between the curly brackets:


With this below, again replacing the URL with the correct one for your welcome page, but in this case only from saw.dll onwards:

window.location.href="saw.dll?dashboard&PortalPath=%2Fshared%2FWelcome%2F_portal%2FWelcome to BI"

Save the file.

Restart OBIEE

Perform a restart of the OBIEE services - either from the Enterprise Manager console or a full restart using your normal process.

Now when you login your welcome page will be displayed by default and the Home link will always return to it.

This is of course just the default login page. It can still be overridden by users who choose alternative starting page in their preferences or who access OBIEE via a URL which includes a specific portalpath reference.

For the record, this blog was written using OBIEE version (Build 140403.1046 64-bit).