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

Ciber SSIS specialist Frank Reterink heeft eens uitgebreid onderzocht wat nu de haken en ogen zijn bij de import vanuit Excel via SSIS.

Inleiding (uit de “literatuur”):

Bij de import van Excel bestanden maakt de Excel connection manager in Integration Services gebruik van de “Microsoft OLE DB Provider for Jet 4.0” en de ondersteunende “Excel ISAM” driver Deze driver heeft een aantal eigenaardigheden:

- Data bronnen:
Voor het aanroepen van en sheet of benoemd data bereik moet achter de naam een $ geplaatst worden. Om syntax errors te voorkomen moet die complete naar door rechte haken [Sheet$] omgeven worden.

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/

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

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

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

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