OBIEE This is the end?

…..not really, but ….

 As most of you might have notice my activity’s in the OBIEE community have been minimal during the last year or so.
How come?
I have accepted a new challenge in becoming the team lead for Microsoft BI at Ciber in the Netherlands .
This means I have little to none time left for OBIEE blogging.  And thinks like visiting the Rittman-Mead conference in Brighton this year are sadly also out of the question.
I will be closing the possibility of adding comments / question on this blog because I don’t have any time (more...)

We are back!

OBIEE101 has been restored! Thanks to Nitecruzr for pushing the right buttons at google!

Till Next Time

OBIEE 101 is down

We know about the problem, I'm trying to contact google to get it resolved!

See you Soon

OBIEE en JDev in the same FWM home

Don't do it, it screws up your OBIEE weblogic instance.........

(especially when you are preparing for the Brighton 2012 BI congress.......)

8-(

Till Next Time

OBIEE install avoid RTD license problems

If you are not going to use RTD (Real Time Decisions) uncheck the box during installation:

image

This avoids extremely difficult discussions with Oracle over the license fee.

Till Next Time

OBIEE 11116 repository on MS-SQL I

We had to do a POC on some MS-SQL data. Instead of bringing an extra Oracle DB we used an existing MS-SQL instance.

1. Create a repository database:

We called ours “Repositories” Winking smile

image

2. Enable case-sensitive collation

ALTER DATABASE Repositories COLLATE Latin1_General_CS_AS

3. Enable Row versioning

ALTER DATABASE Repositories SET READ_COMMITTED_SNAPSHOT ON

 

4. Allow TCP/IP access to the database:

image

(Bounce the service if you changed it!)

4b. If you have a firewall running check if the ms-sql port is open (1433 for a default instance)

5. Create a user (fi: REP_OWN)

image

6. make  the default database repositories:

image

7. Set (more...)

See you in Brighton !

Want to know if  the White Stork really brings the babies? See me and many others speak at the Rittman Mead BI-Forum http://www.rittmanmead.com/biforum2012

See you in Brighton!

OBIEE 11.1.1.6 upgrade guide

Upgrade guide is found here:

http://docs.oracle.com/cd/E23943_01/bi.1111/e16452/bi_plan.htm#BABECJJH

Pretty much a standard weblogic upgrade.

Till Next Time

250 Followers !

Recently follower number 250 has joined this blog! Thanks everybody for all the great feedback!

Regards John

OBIEE 11.1.1.6 is out!

If you have missed it:
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html ==> 11.1.1.6.0 is out
See the nice new features:
http://docs.oracle.com/cd/E23943_01/bi.1111/e10540/whatsnew.htm#CJAEEGJH

Till Next Time

OBIEE in hebrew

Boris has set up an OBIEE blog in hebrew: http://obiee.co.il/.
Translatesd : http://translate.google.com/translate?sl=iw&tl=en&js=n&prev=_t&hl=en&ie=UTF-8&layout=2&eotf=1&u=http://iloug.org.il/BI/ 

For those of you who also have a non english OBIEE blog feel free to sent me a link and I will gladly advertise it here.

Till Next Time

OBIEE11g FireFox 10 problems

For those of you having problems with the new FireFox 10 client. Michal Novy posted a solution on Christians Blog:

Hi, I found the way how to do a workaround:
1. type "about:config" into an address bar
2. right click anywhere and choose New / String
3. name it "general.useragent.override"
4. put the value "Mozilla/5.0 (Windows; Windows NT 6.1; rv:10.0) Gecko/20100101 Firefox/9.0"
5. refresh OBIEE login screen
Then it works without any problems!

Seems that Oracle is already working on some patches: see patch # 13564003 released by Oracle Support which repairs this limitation.

Till Next Time

VMWARE connection problems

I noticed when connection a vmware to certain networks the network doesn’t like a loopback adapter running on the vmware. Although you will get a valid IP it can’t connect to anything….

Disabling the loopback did the trick.

Till Next Time

OBIEE101 I’m still around ;-)

Thanks everybody for the interest in my whereabouts.

Yep, I'm still around. Just very very busy on a huge OWB migration.

Hope to be back soon we some OBIEE stuff.

Till Next Time

BIP Quartz tables

On a 11g BIP only install you can use the QUARTZ scheduler. The scheduler is fed from the XMLP_SCHED_JOB table from the repository. It will seed either the QRTZ_SIMPLE_TRIGGERS (one off jobs) or QRTZ_CRON_TRIGGERS (repeating jobs). This will feed the QRTZ_TRIGGERS table which controls the next execution time. The actual job is in the QRTZ_JOB_DETAILS table.

image

You can inject jobs directly into these tables. Remember that all DateTimes are in QUARTZ_TICKS calculated back to GMT time. A ms-sql conversion function DateTime to Ticks can be foud here. From Ticks to DateTime is this one.

Till Next Time

BIP11g Users and Roles

Did some work on a 11g BI publisher only install recently. Opposite to OBIEE11g you can still add users directly into BIP. Be sure to give them the right roles and sync it with your weblogic security realm.

Till Next Time

OBIEE11g / BIP Quartz Scheduler

Seems that Oracle is using there own standard for the Date Time format in the BIP quartz scheduler. They are not using standard ticks (starting on 1-jan-0001) but a milliseconds count starting on 1-jan-1970. So 1-Jan-2012 = 1325376000000. IE: a whole day is 86400000 ticks.

Till Next Time

OBIEE10g Auto Suggest Prompt

A client asked me if I could create an auto suggest prompt for him. (ie: Google Style Prompt). Basically he wanted an edit box prompt which would fill an suggestion box which he could tab trough to make the right selection.

Since this isn’t a standard 10g functionality I wrote some JavaScript to make it happen. But I didn’t reinvent the wheel Knipogende emoticon ! The people at jQuery already did the bases, I simple adapted it for usage in OBIEE 10g.

1. Download the jQuery UI package here. Install it in your b_mozilla directory’s (or other webserver dirs you use).

2. Download (more...)

OBIEE10g AutoRunPrompt

A client asked me if I could create an auto run prompt for him. Basically he wanted an edit box prompt which would updated his report after each character has been typed. Since this isn’t a standard 10g functionality I wrote some JavaScript to make it happen. It uses the onkeyup event to fire the GFPDoFilters filter event.

The script can be downloaded here: download COBIEEJS.

Copy the file to your b_mozilla directory’s (or other webserver dirs you use)

How to use it?

1. Add an edit box style prompt to your dashboard:

image

2. Add a textbox with:

<script src="res/b_mozilla/cobieejs. (more...)

OBIEE11g SampleApp OID doesn’t start

Yep, I did again :-(.

After playing around with the new sampleapp107 I managed to crash the VM. After a reboot the OID refused to start up. It seemed that because there was still an active status record in the ODS schema, the OPMN couldn’t find anything to start.

Solution: truncate the "ODS"."ODS_PROCESS_STATUS" and  "ODS"."ODS_GUARDIAN" tables in your database repository.

(Not sure if the "ODS"."ODS_GUARDIAN"  is really necessary…. Please correct me if I’m wrong)

Till Next Time