Blog Network Home > 2008 > January

From the monthly archives:

January 2008

I just finished a Six Sigma project and was left wondering as to why BI practitioners are not using more of that Six Sigma power in Business Intelligence. Let me delve on this subject a bit more.

Here are the instant refresher steps for performing a peoplesoft clone.

The target system – the system to which the Peoplesoft Instance to be cloned.
The source system – the system from which the Peoplsoft Instance is cloned.
Oracle Server 9i with the patch at version 7 is installed in the target system.
Application and Web Server is also [...]

Before reading this entry (always a friendly warning first!), please read about my two blog entries that I posted earlier. This entry is kind of closure to my previous topic “Jolt Session Pooling”. If you still have decided to read this one, you cant complain about not able to understand this one….

Take 2: Jolt Session Pooling Continued….
In our last blog, we talked about Jolt Session Pooling. That was kind of introduction to this concept I suppose. I am now going much deeper into this parameter to understand how this parameter works with Peoplesoft context (also I am interested to know more about this parameter anyway!)…

Airlines are one of the earliest adopters of technology in the field of reservations, check in and departure. These systems are mainly on TPF (IBM) or USAS (Unisys) and are main frame based. The dilemma of the airlines to move to new technology probably could be due to doubts on the efficiency of new technology [...]

With the advent of a new year, let me do a recap of what I have discussed through my 15 odd posts in 2007 and also set the direction for my thoughts in 2008.

Okay, long time no see! I am back. First of all, let me wish you all a Happy and Prosperous New year. Lets hope for the best.
I had some project , as well as, some personal commitments that I needed to complete during last year. One of my project commitment was, obviously due to the [...]

The below SQL lists the complete portal navigation along with the process name. I built this SQL when we had to provide this list to our client to review processes that could be retired. The output is useful for generating an inventory or assisting in KEEP/DROP decisions during upgrade.
Here it is:

SELECT NAVIGATION, A1.PRCSNAME
FROM
(SELECT LPAD(‘–’,2*(LEVEL-1)) || [...]

What is a BI Appliance?
If a data warehouse class database product or a reporting product or a data integration product or an all-in-one software package is pre installed and available in a preconfigured hardware box, then such a “hardware + software” box is called a ‘BI Appliance’. The very purpose of an appliance model is [...]