Home | Ciber
Knowledge page of Ciber Netherlands

Archive for June, 2008

Encountering OSGi

For me, an interest in Eclipse internals resulted in my first encounter with OSGi. By now, OSGi has gained serious momentum in the entire Java ecosystem and I feel that OSGi is a topic that every Java developer should be aware of. In this article, I intend to guide you past the online resources that I found most relevant for gaining knowledge of OSGi. Hopefully, readers will agree with my selections and gain an understanding of OSGi and why they are likely to encounter it in the near future, if they have not already.

Read more

9 comments

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".

Read more

No comments

OBIEE Excel Import, prepping the data.

One of our customers has an application which generates an Excell with combined data.

 image

They wanted this to be imported into OBIEE, but couldn’t get OBIEE to see the data. They got the connection oke, but didn’t "see" the tables.
This problem was caused by the fact that the generating application didn’t prep the data. It didn’t set the named ranges for the three tables.

 

Read more

2 comments

OBIEE Directing a user to a default dashboard

One of our customers wanted the OBIEE users after login directed to a default dashboard based on the department they work in. First we created a view containing P_USER, DEPARTMENT and PORTALPATH.

image

Read more

No comments

OBIEE Flexible Dashboards

One of our customers wanted a “flexible”dashboard. They wanted to select a x number of trucks and have an individual graph for each truck. The number of selected truck varies between 0 and 5.

We made this possible by using the RANK function in OBIEE. We made a simple report for the “licence plate” dimension:

image image

 

Read more

No comments