Sunday, June 29, 2008

OBIEE Follow the sun / Time driven connection

One of our customers wanted a 'follow the sun' solution to connect to there international databases. Translated to the practice this means that they wanted to set a connectionpool based on the the local time. To achieve this we made a repository initationblock called "REP_IB_TNS" and a repository variable called "LOCAL_TNS_TO_USE".

In the datasource block we made a very simple query which determines which TNS to uses based on the time of the day:

We forced a refresh every 10 minutes by setting the "lifespan" of the block:



In the connection pool you make a reference by using the VALUEOF method:

n theory it takes a maximum of 15 minutes (10 minutes for "REP_IB_TNS", 5 minutes for the connection pool) to refresh all connections


Till Next Time

7 comments:

Sandeep said...

Hi John

I have one main report and child report. i am passing some column value from main report to child report. so i want my child report to get open in separate window. i am new to OBIEE. can you tell me how to do this using narrative view

John Minkjan said...

Hi Sandeep,

Not really sure what your question is or how this relates to the article above. Have you had a look a guided navigation in the documentation?

HTH

John

Sandeep said...

Hi John

I dont have any documents for OBIEE. i am just trying with help of article on interner.

there is some function GoNav and GoNavEx and i am trying with them but not getting any result.
it will be very helpful if you can tell me how to do this

John Minkjan said...

Hi Sandeep,

You can find the documentation at otn.oracle.com. GoNavEx isn't an OBIEE function. If you want to do some java stuff have a look at the Oracle® Business Intelligence Web
Services Guide.

HTH

John

John Minkjan said...

Also have a look at the GoURL function.

HTH

John

Tom said...

Hi John I really like you Blog 101 I'm looking forward to your other 101's especially EBS101,

John can you elaborate and may be even post a little more on follow the Sun connection pooling, this blog of yours is very very interesting if you could blog more about this it would be great.

Looking forward

TOM

Brian said...

Hello John
This question is not much pertaining to what you have published in this specific blog entry, but I could find no other way to contact you, and could use some help. I am very junior in my company, and have just gotten some Oracle sanctioned OBIEE training (Create reports/dashboards)...When I got home from training, I downloaded the OBIEE suite from OTN, and installed it on my external. Now I want to figure out how to build a database that I can then roll up into a data warehouse using Informatica. I would also like to get into some more of the admin portions of the software. I was hoping you could help me out a little with this, or point me in the direction of some pertinent documentation to help me get started. Feel free to email me back at frick.brian@gmail.com, or post back here, I'll check back in a couple of days.