Thursday, April 28, 2011

OBIEE Making your laptop available for Wi-Fi

If you want to do a demo for customer showing the mobile capabilities for OBIEE you need a Wi-Fi access point. Since most organisations don’t allow ‘experiments’ on there Wi-Fi here is how you can set up an Windows 7 laptop as a Wi-Fi gateway.

Open a command line box on your laptop and enter:

netsh wlan set hostednetwork mode=allow ssid=ObiLaptopWireLess key=OBIEE123

image

image

Open the network centre and look for the new entry

image

image

It’s probably called something like ‘Wireless Network Connection 2’

image

Open the connection and select the Sharing tab on the incomming connection:

image

image

Select a Network to use for the connection:

image

On the networking tab select only the IPv4 protocol:

image

Open a command box to start the network:

image

netsh wlan start hostednetwork

image

Change the name to something meaningful:

image

Till Next Time

Saturday, April 23, 2011

OBIEE OC4J Shutdown on 64-bit windows

Shutting down the OC4J engine on 64 bits windows can give strange errors like:

Error: Missing ormi[s]://<host>:<port>

This seems to be a issue with IPv6 adressing. Try adding:

-Djava.net.preferIPv4Stack=true

FI: JAVA -jar -Djava.net.preferIPv4Stack=true D:\ORACLE\OBIEE10Gr3\OracleBI\oc4j_bi\j2ee\home\admin.jar ormi://localhost:23791 oc4jadmin p***** -shutdown force

Till Next Time

Tuesday, April 19, 2011

OBIEE11g PROJECT_INACCESSIBLE_COLUMN_AS_NULL

The PROJECT_INACCESSIBLE_COLUMN_AS_NULL in the NQSConfig.ini file controls how security-sensitive columns are displayed to unauthorized users.

If this parameter is set to YES, then a NULL expression replaces the original column expression in the query and secured columns are hidden from unauthorized users in analyses.

If this parameter is set to NO, then when a user attempts to run a report that contains a secured column the user is not authorized to see, an unresolved column error occurs.

image

Till Next Time

Saturday, April 16, 2011

Brainteaser

Ok this has nothing to do with OBIEE but is just nice to solve during a coffee break: Which number follows next for this sequence: 16, 33, 45 ?

I will post this answer in a couple of days.

Till Next Time

Update 20110418:

And the answer is 78! (They are vinyl record speeds see: http://en.wikipedia.org/wiki/Gramophone_record#Speeds)

So the winner is Jeff Kemp!

Friday, April 15, 2011

OBIEE11g setting loglevel

Setting the loglevel for an individual user in OBIEE11g is a bit illogical. Most of the security stuff is managed by the weblogic console:

image

But if you are looking for the loglevel you will have to set it directly in the RPD…..

Open the administrator tool and log in to the online RPD:

image

Goto Manage Identity

image

Select the user and set the log level:

image

Check in and save:

image

image

Restart the BI-SERVER and check the log. [nqquery.log]

image

Till Next Time

OBIEE11g Tips and Tricks

Nice one from the people at BICG:

Till Next Time

Monday, April 11, 2011

OBIEE11g DEFAULT_PRIVILEGES

By default every group or user defined in the RPD has read rights to each new element you add. This can be a bit of a pain in the a$$$ if you have a lot elements which each try own security group. Better to develop the RPD so that you have to grant each group access to a element.

This can be set in the NQSconfig.ini file:

image

Till Next Time

Friday, April 8, 2011

OBIEE Oracle Virtual Box Screen size

I had to configure an Oracle Virtual Box on my laptop, but the default max screen size was 800x600 . You can adjust this with:

VBoxManage.exe setextradata global GUI/MaxGuestResolution 1920,1080

from a windows command box.

Till Next Time

Thursday, April 7, 2011

OBIEE11g Setting Multi User Development Options

When you are working on a MUD or Multi User Development RPD you can set some extra options.

In the MUD directory create a new option file for each master repository. It’s a TXT file called [RPD_NAME].opt fi: paint.opt. (be aware CaseSensitive!)

Set the properties of the file to hidden:

image

open the file in a text editor:

Add the following (INI style):

[Options]

BuildNumber = Yes

Admin = admin1;admin2

Mandatory Consistency Check = Yes

Equalize During Merge = Yes

image

Option

Description

BuildNumber

When set to Yes, the build version of the Administration Tool is displayed in the MUD history.

Admin

Lists multiuser development administrators. Administrators must be defined in the option file before they can delete MUD history.

Administrators are defined by their computer/network login names. When multiple administrators exist, administrator names are separated by semicolons. For example:

Admin=jsmith;mramirez;plafleur

Mandatory Consistency Check

When set to Yes, the publish step performs a consistency check. Publishing cannot proceed unless there are no errors in the given repository.

Equalize During Merge

When set to Yes, the multiuser development merge process performs mandatory equalization during MUD merges.

Note that setting this option to Yes affects the performance of the merge process.

Mandatory Consistency Check &  Equalize During Merge can be experienced as a real pain in b*&t for developers because it forces them that everything is ok when checking in. I advise it only projects which are close to deployment for production to ensure some basic error checking.

Till Next Time

Sunday, April 3, 2011

OBIEE11g using Dashboard Templates

When logging in for the first time you normally get an empty dashboard page:

image

Wouldn’t it be nicer if you can give a dashboard which already has some content ?

Let prep the instance config.xml

add: <DefaultName>Template</DefaultName> between the <Dashboard> tags

Now let’s make a template dashboard.

Step 1 build a nice dashboard:

image

Save this dashboard in the shared folder with the name ‘Template’

image 

First create a folder Template:

image 

Create a folder dashboards:

image

Next save:

image

Set the owner in the catalog

image

Create a new user:

image

don’t forget to assign it to a group:

image

Log in to OBIEE:

image 

Check the catalog folder of the user to see that it’s actually saved as a personal dashboard.

image

This is ideal to create cooperate standard default dashboards for all users.

Till Next Time