Thursday, March 31, 2011

OBIEE11g Controlling Table, Pivot and Charts behaviour

In 11g it is still controlled by the instanceconfig.xml. You can edit the file and restart the system to see the effect.

Especially the MaxVisible.. parameters are of interest when you seem to “miss” data on the screen on large reports.

Be aware these are system wide controls, so don’t change the DefaultRowsDisplayed just for one report!

<ServerInstance>
<Views>
<Table>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>500</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>30</DefaultRowsDisplayed>
</Table>
<Pivot>
<MaxVisibleColumns>300</MaxVisibleColumns>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>500</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>30</DefaultRowsDisplayed>
</Pivot>
<Charts>
<MaxVisibleColumns>2000</MaxVisibleColumns>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>2000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<JavaHostReadLimitInKB>4096</JavaHostReadLimitInKB>
</Charts>
</Views>
</ServerInstance>



Till Next Time

Tuesday, March 29, 2011

Installing OBIEE10g on windows 7 64 bit

Be sure you only have a 32 bit java JDK installed, else you might run into trouble starting the javahost as a service.

Check your PATH variable if it “sees” the JDK.

Till Next Time

Monday, March 28, 2011

OBIEE11g preventing online RPD changes

I personally think it’s never a good idea to allow online changes to the RPD by default. Especially not on production environments. In OBIEE11g you can set the online editing of the RPD in

Enterprise Manager>Business Intelligence > Coreapplication > Capacity Management > Performance:

image

Click on lock and Edit Configuration:

image

Press close:

image

(un)Check the box:

image

Click Apply:

image

Press activate Change:

image

Wait a bit:

image

Press Close:

image

Go to the restart page by pressing:

image

Press Restart:

image

Till Next Time

Thursday, March 24, 2011

OBIEE11g using bi-init.cmd

If you did a RTFM you will have noticed that you are required to run the bi-init.cmd before executing a command line utility. Most of the time you won’t notice any difference if you omit this step. Especially if you have installed everything on a “clean” server-instance. If you have a somewhat “dirty” machine it quite handy. But what does it do?

Have a look a the script:

@echo off
set ORACLE_HOME=D:\oracle\OBI11GR1\Oracle_BI1
set ORACLE_INSTANCE=D:\oracle\OBI11GR1\instances\instance3
set ORACLE_BI_APPLICATION=coreapplication
set JAVA_HOME=D:\oracle\OBI11GR1\jrockit_160_17_R28.0.0-679
call %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\%ORACLE_BI_APPLICATION%\setup\user.cmd
if NOT "%1" == "" set COMPONENT_NAME=%1
set PATH=%ORACLE_HOME%\common\ODBC\Merant\5.3\Drivers;%ORACLE_HOME%\bifoundation\server\bin;%ORACLE_HOME%\bifoundation\web\bin;%ORACLE_HOME%\bin;%PATH%
if "%2" == "" start

It starts with setting your ORACLE_HOME, ORACLE_INSTANCE, ORACLE_BI_APPLICATION and JAVA_HOME variables

Next it calls the user.cmd which can set some extra variable like your TNS_ADMIN

@echo off
REM This file is a placeholder for setting environment variables
REM set TNS_ADMIN=

Next it sets the PATH variable which can be overruled by adding a COMPONENT_NAME to the script execution bi-init.cmd “COMPONENT_NAME”

If no second parameter is given it will open a CMD box.

Why if this important? If you are scheduling scripts you can use this script to verify that stuff is executed against the intended enverioment.