Home | Ciber
Knowledge page of Ciber Netherlands

OBIEE Google Charts part 1

or how to get from:


to this:



in 5 minutes.

It uses the same technique we used with the googlemaps. Create a new narrative view.

In the prefix part put:

<!–Get an empty map–>

<img xsrc="http://chart.apis.google.com/chart?cht=t&chm=europe&chs=440×220" id="GD_mapImg"/>

<!–chm ==> geographical area (africa, asia, europe, middle_east, south_america, usa, world)–>

<!–chs ==> canvas size max 440X220–>

<!–more info http://code.google.com/intl/nl/apis/chart/ –>

<script type="text/javascript">

// setting up parameters

var chartURL = "http://chart.apis.google.com/chart?cht=t&chtm=europe&chs=440×220&chds=1,6";

var chartBGColor = "&chf=bg,s,EAEAEA";

//specify the gradient: <default color>, <start of gradient>,.., <end of gradient>

var chartPalette = "&chco=AEF5EB,EFE6CE,DFAE6B,1F6913,D94801,A63603,7F2704";

var chartDataLabels = new Array();

var chartData = new Array();

In the Narrative part put:

// Use the push command to fill the array:



In the postfix part put:

// putting it all together

chartURL = chartURL + chartBGColor + chartPalette + "&chld=" + chartDataLabels.toString().replace(/,/g,'’) + "&chd=t:" + chartData.toString();;

// now get the image from Google Chart

document.getElementById(’GD_mapImg’).src = chartURL;


Remember to check the HTML box:


There are maps for africa, asia, europe, middle_east, south_america, usa and the world. For more info see: http://code.google.com/intl/nl/apis/chart/

Till Next Time


This article is also published on http://obiee101.blogspot.com/

No reactions

Java development using SAP NWDI

SAP has a lot of experience with enterprise wide software development and managed transport of software. To support component based development and transport for Java software, SAP introduced Netweaver Development Infrastructure (NWDI).


Read more

No reactions

SoapUI usage and integration within a CI environment part II

Best practices / lessons learned

This section is organized in the following main parts, which are discussed one by one in more detail within the remainder of this article:

1. Tips for an optimized SoapUI configuration when using a CM (configuration management) system

2. Tips for creating SoapUI TestCases

3. Tips for setting up the SoapUI Testrunner script

4. Tips for configuring SoapUI within Hudson (CI environment)

Read more

No reactions

SoapUI usage and integration within a CI environment Part I

SoapUI usage and integration within a CI environment Part I: an enumeration of best practices and lessons learned.

The focus on this article is not to summarize the known features and functionality of SoapUI, but instead focus on lessons learned and best practices which are gathered during extensive usage of SoapUI within a webservices project.

Service-oriented architecture (SOA) and webservices are becoming more and more popular in many IT projects. Exposing your business logic component as a webservice is as simple as adding a few metadata annotations.

Before making webservices available to the public, you need to make sure they function as designed. The common way to do this is by writing functional tests for your webservices. Another reason for writing functional tests is regression, e.g. ‘is everything still working as before?’. If well-designed, all tests should continue to be successful when nothing in the entire domain has been changed and detect impacting changes by indicating non-successful results.

Read more

No reactions

Software quality, how do we manage?

We write software. We try to make it as good as possible but it is hard. Complex business rules, intricate web frameworks and high-tech application servers all add to the complexity of the whole package. How do we ensure it all works flawlessly together?

Read more

No reactions

OBI Forum live de tweede editie

coumadin therapy
clomid challenge test
query lowest cialis price online
adipex side effects
levitra for sale
phentermine cheap
tramadol cheap
xanax addiction
herbal viagra reviews

Het is weer zover: woensdag 3 juni 2009 is er de tweede versie van OBI forum live : http://www.obi-forumlive.nl/ .

Naast Daan Bakboord (Scamander), Nicolas Gerard (New Frontiers) , twee van Nederland’s bekendste en beste (b)loggers op dit vlak, hebben ditmaal ook en Emiel van Bockel (Centraal Boekhuis) en Gerard Braat (Oracle)hun medewerking toegezegd.

En als klap op de vuurpijl is het ons gelukt de oervader van de OBI blogs, Mark Rittman, als keynote-spreker te krijgen.

Op 3 juni a.s. heeft u de mogelijkheid om deze belangrijkste spelers ‘persoonlijk’ te ontmoeten en met ze te sparren! Meld u nu aan en mis de 2e editie van het forum niet.  http://www.obi-forumlive.nl/ .

tot de volgende keer!

No reactions

OBIEE Dashboard Design 001

As promised in a previous article (http://obiee101.blogspot.com/2009/04/obiee-final-skills-creating-great.html) I will show you some tips and tricks on how the implement the findings of Stephen Few in OBIEE.

Let’s start with a simple top 7 list of product revenue:


Read more

No reactions

Creating XSLT-extensions with SAXON

Suppose you want to do some heavy lifting with xslt (2.0) but xslt provides no  out-of-the-box functions for your problem.  In that case you can create your own xslt extensions. 

Below you find a small demo how to accomplish this.

Read more

No reactions

OBIEE Showing zero’s in a bargraph

Somebody asked me how you can show zero’s (0) in a bargraph. Have a look at this table:


Read more

No reactions

OBIEE Multi lingual prompt

Recently I was asked to create a multilingual prompt label. Stijn Gabriels pointed me in the right direction.

First I created a dummy table in the .RPD with a single date column:


Read more

No reactions

« Previous pageNext page »