Some information systems have exceeded the boundaries of the department and his knowledge has spread to all areas of the company. As the technologies are becoming easier to use and accessible for all business casuistry, his knowledge extends and extends beyond the field of "understood" by the experts, to be known by every company profiles. Concepts such as CRM, ERP, etc., Not long ago in companies known only to the department and the department involved (Marketing and Sales for CRM, ERP Operations, Human Resources for the intranet, etc.).. Concepts today are managed and understood by anyone in the business world.

As for Business Intelligence, I believe that unfortunately is still preserve of experts and technologists. Today it is very common to find a business decision makers are unclear about the functions, spheres of influence, potential and business benefits of a Business Intelligence system. The BI is still known by a few, there has been democratized, it has jumped the hurdles of technology to be part of each and every one of the departments of companies. In my opinion there are several reasons for this.

Good.
I finally finished reading the book Pentaho Solutions, who kindly have sent me Roland Bouman (co-author of the book) and Wiley.

On that occasion will realize different reviews from different points of view, as I did with Pentaho Reporting. Here are the reviews:

1) Overview :  It is a very easy book to read and handled very well the theoretical and practical.

As the concepts are giving more complex and heavy, is always accompanied with an example, graphic or exercise.

This book is really very useful and indispensable reading both for those who are just beginning to work with Pentaho, and for that we have some time.

"The goal of Business Intelligence is to provide the information they need, when you need it and in a form appropriate to people who have to make decisions."

The aim of this paper is to support the Business Intelligence or BI should be, of all business software tools (including CRM, ERP, or BI himself), that is closest to the role of management, specifically the Executive Officer.

Since the computer revolution and the explosion of Internet, information is becoming more and more importance. Everything is or will soon be digitized, the amount of information available each year is multiplied and the activity of our business is computerized in most respects.

Studies tell us that the information maintained by companies is doubling every two years and that 80% of decisions are made with only 10% of the available information.

And all of this information is power! Is necessary, vital, to compete. 

SAP TechED presented in Vienna on Gravity product prototype, a BPM solution that works on the collaborative environment provided by Google Wave.

This product allows Business Process desing collaboratively, building communication facilities provided by the environment Google Wave. Obviously it works for web, and can also be used from mobile devices like an iPhone.

This video shows how to simulate a situation of merger of two companies in which they must redefine many business processess the highest level.

As expected, the first BI tools adapted to the new iPad of Apple are appearing. Nothing like a dashboard application to exploit the Multitouch screen possibilities of this device.

Prelytis is the company that has developed Prelytis LiveDashBoard, the first Business Intelligence software compatible with the new Apple Tablet. This is a dashboarding tool, and 2.0 oriented, with collaborative features, and remarkable for their efforts in terms of adaptation to mobile devices.

In a Data Warehouse there are a number of common dimensions such as Geographic and Time. 

I leave here a script to create the Time Dimension table and a procedure to loading it between two dates:

/ * Destination database * /

use PAnalisys