Friday, December 29, 2017

Houston, we have a problem

When the theatre curtains rise, the play will begin and can’t be stopped. Like a play, once project begin, the work didn’t stop until completion. The root of the difficulty is that we can’t see what’s happening when it’s happening; so this article provides guidance on how to focus on weaknesses to get the project back on track when it starts to go off the rails.

First of all, let me say that Dashboard design is not an exact science, anyway obviously, the purpose of a Dashboard is not to entertain and also is not to provide dashboard developers a chance to astonish people with their artistic talents. That means that a Dashboard should be designed with appropriate consideration, which enable see what is meaningful and think without distraction.

Too often we evaluate performance against plan; so projects are performing better/worse than expected or close to plan. Trying to be practical, efficient and professional, a bull’s eye Chart uses just two simple KPIs and can be tracked regularly. Such indicator enables greater analysis; it’s helpful to bring deviations to light, to reset our expectations to something more realistic; containing the secret of a successful project. 

A bull's eye chart shows performance of the project by plotting the SPI and CPI. 

The Schedule Performance Index (SPI) is an indication of the schedule performance of the project (how you are actually progressing compared to the planned progress).

The Cost Performance Index (CPI) measures the value of the work completed compared to the actual cost spent on the project.

This indicator gives the project managers control over updated information of the project, and can be used in two ways:
- Monitor the performance of a single project during development.
- Monitor the performance of multiple projects by each point indicating a different project.

Once you know this useful tool, just now there's the mountain itself to climb: the project's completion.

Hope it helps!
Best wishes.
Joan Martí Peraire.

Monday, September 7, 2015

Consume the wsdl with SOAPUI request using an active login

The purpose of the functional requirement is to specify a login name to identify which integration is used in order to create the Service Request (within Siebel).

WSDL permit Service Request creation if an Administration name/password is specified. Anyway, consume the wsdl with SOAPUI request using whichever login of interest is available.

So, change the web service url in the SOAPUI request (username/password of the interested login in the url), for instance, using USERA the url request is such as:


Thursday, August 21, 2014

Optimizing the Value of Information Technology Investments

Recently, a client ask me if I consider using Open Source software for support “Business Intelligence” needs, which question I answer: it’s possible, but the Open Source system provides less functionalities to specific problems. 

As it’s well known, OBIEE is, for me, the Flagship of Flagships that continues its strong growth year over year. So, thanks to acquisition of Siebel, Oracle provides a friendly and high quality application that stay on top of “Business Intelligence” technologies.

Anyway, needless to say that the licensing is an intangible cost involved in commercial products. In this way, I focus on reaching ways of cutting costs, ensuring that information system is efficient according business requirements.

The usage of Open Source software as alternative for commercial products may cause nightmare, not only because of support that you can expect after buying a license, but also because of software requirements of businesses.

Notice that a solution could be combining  commercial  software with open-source applications. So, “Pentaho Report Design” (OpenSource) allows create custom reports using Oracle Database (commercial product).

In this way, within “Pentaho Report Design” include the SELECT statement, such as in the screenshot below:

Once is included and customized, click on “Print” > “PDF” and you could save the Report as PDF, just as in the screenshot below.

Best wishes.
Joan Martí Peraire.

Saturday, September 21, 2013

Stop and think

My bro releases another work: "Equilibrios", and once again he give us an essential key of life. In this case: Is whatever you have whatever you want?

So once again complex situations become simple or understandable, I always focus on whatever I wish, whatever I need or which one is my priority. Anyway just now I realize that these concepts are secundary, and it's crucial that whatever you have is really whatever you want.

When I listen that release I was under impression that "Equilibrios" is not just a new song in general, it can also refer a specific style of life: stop and think, so then go on.

Below is available the link to related song:

Equilibrios - Artur Martí.

Best wishes,
Joan Martí.

Friday, August 23, 2013

1993 - Not so small revolution

In 1993 Thomas Siebel and Patricia House founded Siebel Systems, Inc.

Forward 20 years and here we are:

-       Siebel CRM:

o    Oracle's roadmap for Siebel CRM is already announced.

o    More than 3.000 organizations use Siebel CRM.

-       Siebel Analytics (now known as OBIEE) is considered a reference within Business Intelligence products, as Oracle's standard Business Intelligence product.

Within IT industry, that means for me: not so small revolution.

In 2004 began my particular Siebel journey thanks to Deloitte and until now I have worked closely with Siebel products. Currently I still struggle to get the concepts that are incorporated into each Siebel releases (in other words: within Siebel, new technologies are being continuously improved). 

So what makes Siebel CRM or Siebel Analytics so successful should be considered exhaustive, anyway let me explain the conceptual overview of what really fascinated me.

1.     Business logic layer

Siebel CRM is a consistent way to record and Siebel Analytics is a consistent way to provide information, both products include predefined modules such as Energy, Public Sector, Loyalty, Order Management and so on. Both products separate each layer:

-       Physical layer: Contain the definition of the relational database.

-       Business logic layer: Contain the abstraction layer of the business.

-       Presentation layer: Contain the end user interface.

I was so impressed when I find out the abstraction of the Business logic layer. To be concrete, Business entities are customized within Business logic layer. In this way, Siebel provides several resources (such as the usage of user-properties based on classes or the incorporation of additional code into Business Component events) to enable particular customer requirements that predefined entities doesn’t include. 

2.     Operational vs Analytical:

At high level, in this point there are two main concepts involved: Operational environment and Analytical environment.

In this scenario, the analytical environment builds consolidated information from more than one source.

On that basis, I was really fascinated as soon as I realized that depending on physical layer configuration, Siebel analytics (OBIEE) is able to provide not only Analytical dashboards (operate in data collected over time, insights into historical data), but also Operational dashboards (operate in real-time, insights into current performance).

To sum up: It’s an asset that the Analytical environment contains Analytical and Operational dashboards, depend on the purpose of the dashboard. In order to be efficient, effective and also identify issues before they become problems.  

Finally, let me say that I really think that a way to evolves is incorporate into Siebel Analytics (OBIEE) statistical modules, conceptual functionalities that nowadays provide software such as SPSS, for me currently OBIEE and IBM SPSS are complementary (have an eye to: Can't see forest for the trees ).

Best wishes.

Joan Martí Peraire.
(Industrial Engineer)

Wednesday, August 14, 2013

Adapt to survive

Little by little things evolves and evolution means change over time. These changes should be always focused on improvement and only adaptive mechanisms are the key to get better.
There’s no sense bet on something that over time is useless.
Finally, I’ve installed the latest version of Oracle BI (11G), and this release includes the latest application server Weblogic.
Once works, I noticed that Oracle BI 11g provides a new robust architecture within Business Intelligence applications. After a bit of research, now it’s time to share my findings (thoughts that are still on my mind).
First of all, as you can see in the below screenshot, let me represent the main part (from my point of view): How are involved Oracle Instance within Oracle BI 11g application.
Focus on Oracle Instances, use the following command line to start (Oracle Process Manager and Notification Server) OPMN services:
Command: opmnctl.bat startall
Path: C:\OracleBI11g \instances\instance1\bin
e.g.: C:\OracleBI11g\instances\instance1\bin>opmnctl.bat startall
Anyway, in order to start the process separately, below are listed each service:
opmnctl startproc ias-component=coreapplication_obiccs1                         (Cluster Service)
opmnctl startproc ias-component=coreapplication_obis1                            (BI Service)               
opmnctl startproc ias-component=coreapplication_obijh1                           (Javahost)
opmnctl startproc ias-component=coreapplication_obips1                          (Presentation Service)
opmnctl startproc ias-component=coreapplication_obisch1                        (Scheduler Service)
Finally, in order to stop Oracle Process Manager and Notification Server (OPMN) services, we use the following command line:
Command: opmnctl stopall
Path: C:\OracleBI11g \instances\instance1\bin
C:\OracleBI11g\instances\instance1\bin>opmnctl stopall

Such as start OPMN services, each process can be stopped separately, below are the command lines:
opmnctl stopproc ias-component=coreapplication_obisch1          (Scheduler Service)
opmnctl stopproc ias-component=coreapplication_obips1           (Presentation Service)
opmnctl stopproc ias-component=coreapplication_obijh1            (Javahost)
opmnctl stopproc ias-component=coreapplication_obis1              (BI Service)
opmnctl stopproc ias-component=coreapplication_obiccs1           (Cluster Service)

Hope it helps.
Fins aviat,
Joan Martí.

Saturday, June 29, 2013

Go ahead

First of all let me say so sorry for not having written for so long, maybe because I needed to work so hard or maybe just finished a complicated life stage that once is over it’s better to forget. Anyway life is life and now it's time to look forward and be enthusiastic about it.

Recently, I devote so time to propose an innovation initiative to be efficient, the main idea is the usage of water according the quality you need. For instance, not only it’s not required, but also it’s not efficient use water with the same quality for all tasks.

So, my initiative is based on collect rainwater and includes an auxiliary mechanism to provide our system with water that comes from a wastewater treatment plant.

 According to the rules established by regional law, physic-chemical properties of water collected should be measured.

In this case, Oracle BI helps us to monitor the physical and chemical properties of water, within a Dashboard, such as I represent below:

If you have an eye on that again, you’ll notice that I design the Dashboard using some of my theories:

  •  A Dashboard must focus on information, instead of art. 
  •  Dashboard should include concrete alerts, such as remark unexpected values. 
  •  A Dashboard should present the process evolution, in order to compare results.

Finally, below is detailed my water-efficient model proposed:

Best wishes,

Joan Martí Peraire.