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

Open the network centre and look for the new entry

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

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

Select a Network to use for the connection:

On the networking tab select only the IPv4 protocol:

Open a command box to start the network:

netsh wlan start hostednetwork

Change the name to something meaningful:

Till Next Time

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

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.

Till Next Time

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!

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:

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:

Goto Manage Identity

Select the user and set the log level:

Check in and save:

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

Till Next Time

OBIEE11g Tips and Tricks

Nice one from the people at BICG:

Till Next Time