The ATR files in the OBIEE repository manage privileges on a item and provide a “readable” text for both the name and description of an object. Dan Malone of Calpoly did some basic research on how these work.

This article describe the build up of the ATR file when used for a report.

WOW: backup the files before you start to hack them, one misplaced byte can really f*&^k up your system!

Read more

Didn’t I read about this in several other blogs you might ask. Well you are right there. It probably started with the guys from carpe diem: http://carpediemconsulting.wordpress.com/2008/03/16/resetting-the-oc4j-password-in-obiee/ And since all the others copied there article from them nobody noticed they didn’t clear the security cache. Here is the version from the original documentation:

Read more

Ever seen these:

They are QR Codes: http://en.wikipedia.org/wiki/QR_Code. Most modern mobiles have a small application on board which can read the information. Because of the build in error correction they are ideal for stuff like address labels.

Read more

Impress with real venn diagrams:

First get your data:

Read more

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:

chartDataLabels.push(’@1′);

chartData.push(@3);

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;

</script>

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/

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!

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

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

Read more

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

Dutch only this time:

3 Juni is het weer zover, de tweede versie van OBI Forum Live.

Zoals u waarschijnlijk al gehoord hebt zijn de eerste sprekers al bekend; Mark Rittman (RittmanMead) en Emiel van Bockel (Centraal Boekhuis).

Wij zoeken natuurlijk nog veel meer boeiende sprekers.

Dus heeft u een goed verhaal over uw uitdagingen met OBI - EE en wil u die met de rest van de Nederlandstalige gebruikers delen, neem dan even contact op: john punt minkjan at ciber punt nl of  +31 (0)40 - 232 90 90

Tot 3 juni