Olap Tools Essay

This report describes four OLAP tools. The four tools that I have chosen for this are: Pentaho – Open Source Tool Cognos Business Objects SpagoBI Pentaho – Open Source Application “The Pentaho BI Project is an open source application software for enterprise reporting, analysis, dashboard, data mining, workflow and ETL capabilities for business intelligence needs” (http://en. wikipedia. org/wiki/Pentaho). The Pentaho Business Intelligence Suite provides reporting on OLAP analyis, dashboards, data integration, data mining and a business intelligence platform that have madde it the worlds leading and most widely deployed open source suite.

Using Pentaho BI Suite omits software licence fee’s, providing support, services and product enhancements via an annual subscription. Pentaho offers flexible deployment, which includes: A complete integrated business intelligence platform Individual out-of-the-box products Embeddable components for use by Java developers Pentaho also has professional customer services that are knowledgable and on-hand to offer support to companies that have purchased the Pentaho software.

They have experienced consultants around the world, public and online training with professional certification options, and OEM (Original Equipment Manufacturers) for company’s that installed the Pentaho technology. “The Pentaho BI Suite uses various licenses to distribute software and documentation, to accept regular contributions from individuals and corporations, and to accept larger grants of existing software products. These licenses help us achieve our goal of providing reliable and long-lived software products through collaborative open source software development” (http://www. entaho. com/license/). Architecture and Administration {draw:frame} http://images. google. ie/imgres? imgurl=http://rnayak. files. wordpress. com/2006/10/pentaho_architecture. jpg&imgrefurl=http://rnayak. wordpress. com/2006/10/12/53/&usg=__MvH0gBhUMNNE6Ivg1eMa893dgp4=&h=372&w=430&sz=29&hl=en&start=3&um=1&itbs=1&tbnid=z92a1_idQ2jv_M:&tbnh=109&tbnw=126&prev=/images%3Fq%3Dpentaho%2Barchitecture%26hl%3Den%26sa%3DX%26um%3D1 Administration Pricing At the present moment Pentaho have six special offers for the purchasing of the software: Cognos 8 BI

Cognos 8 BI can provide capabilities and information you need to make better decisions. Cognos uses: Reports Analysis Dashboards Scorecards to examine an organizations performance, study trends and assess results. “Cognos 8 BI has won numerous awards which include the eWEEK Excellence Award in Analytics and Reporting, the Lotus Advisor “Editors Choice” Award and TechTargetsSearchCRM. com 2005 product of the year. In 2007, Cognos was named one of Canada’s Top 100 Employers, as published in Maclean’s magazine, one of only a handful of software development companies to receive this honour.

Cognos has been named to the InformationWeek 500, chosen as one of START-IT Magazine’s “Hottest Companies of 2006” and won “Best of Information On Demand Showcase” as part of the IBM Information Management Awards. ” (http://en. wikipedia. org/wiki/Cognos#Awards) Licensing Architecture and Administration Cognos 8 has a multi-tiered architecture and can be sperated into 3 teirs. These tiers are web server, applications and data and are based on business function, and are normally separated by network firewalls. As shown in the diagram below Cognos 8 BI user interface sits above the 3 tiers.

Depending on what the users requirements are, you can choose different configurations but the one shown below illustrates a single server Cognos 8 BI configuration. {draw:frame} http://www. adaptiveusa. com/ASI%20Links/c8_arch. pdf Administration For administration purposes, as soon as you have Cognas installed and configured you can carry out the following tasks: “Set up folders where reports are stored Make reports available to business users Monitor and administer servers Back up data Maintain security Deploy Cognos 8 from one environment to another” (Architecture and Planning guide 2006, http://support. ognos. com) Components {draw:frame} The above diagram shows the six components in IBM Cognos 8 BI. These components are: {text:list-item} {text:list-item} {text:list-item} Content Manager Application Tier Components Gateway Controller Web Services Server Web and Windows Interfaces Image: http://publib. boulder. ibm. com/infocenter/c8fpm/v8r4m0/topic/com. ibm. swg. im. cognos. ctrl_inst. 8. 4. 0. doc/images/cntrl_install_order_servers. jpg Security and Distribution Looking at the Cognos 8 BI tool it seems that secutiry implementation is either not enough or too much.

Not enough security can mean “when the Cognos 8 default settings are left in place and security is relegated to the user logon or no security at all” ( Volitich, Dan. IBM Cognos 8 Business Intelligence : The Official Guide, 2008). The threat here is, anyone that would have a Cognos Connection can view or print any data that has been published by the company, delete any items they find, for example, packages, folders and reports . Too much security can occur “when the system administrator either does not understand the flexibility of Cognos 8 security, or, to be frank, the system administrator is paranoid. In this ase, legitimate business users cannot access the information they need to make sound business decisions. The business users quickly become frustrated and the Cognos 8 installation is considered a failure by the people it is meant to help the most. Every organization should be concerned both with information security (not allowing unauthorized user to access information) and content integrity (not allowing someone to remove or change content). Cognos 8 lets you apply a fine level of control over all of the features and content found in the Cognos 8 environment, ensuring that you can meet both of these objectives” ( Volitich, Dan.

IBM Cognos 8 Business Intelligence : The Official Guide, 2008). It is important for any company using Cognos 8 that they must enable and configure security before they use it. If this is not enabled then anyone that has a Cognos connection will be able to access all information and data in the program. Volitich, Dan. IBM Cognos 8 Business Intelligence : The Official Guide. New York, NY, USA: McGraw-Hill, 2008. p 592. http://site. ebrary. com/lib/limerickit/Doc? id=10226996=614 Business Objects Companys use the Business Objects Suite for many reasons.

Some of these reasons include: Real-time business planning and forecasting Accelerating mergersand acquisitions Understanding business performance by customer segment product, channel and business line, Delivering performance information across the company. The user has the choice if using the business objects suite as it can be used in house or through the web, and also works locally or worldwide. Components The components of a Business Object are required to be installed before they can run. The components of a Business Object are: Database – the database contains all the data for the company’s site.

It can include information such as the user information, transaction logs and other data. Business objects supports Microsoft SQL server and Oracle for its database. File Server – the file server contains all the shared files for a site. Shared files contain data like configuration information, server logs, model information and reports. http://help. sap. com/businessobject/product_guides/planningExtxir2/en/BOPE_53_Architecture_Guide_en. pdf Business Objects Planning Architecture {draw:frame} http://technet. microsoft. com/en-us/library/Cc750581. infeva01_big(en-us,TechNet. 10). gif. gif) SpagoBI It is a platform because it covers and satisfies all the BI requirements, both in terms of analysis and of data management, administration and security. In the analytical world it offers solutions for reporting, multidimensional analysis (OLAP), Data Mining, Dashboard and ad-hoc query. It adds original modules for the management of collaborative processes which build analytical dossiers and for the geo-referenced analysis. It has tools for the data extraction, transformation and loading (ETL) and it supports the administrator in the maintenance of the analytical documents, managing the versioning and the approval workflow.

SpagoBI has a behavioural model which regulates the visibility on the data and the behaviour of the single documents in relation to the end users’ roles”. (http://en. wikipedia. org/wiki/SpagoBI) Licensing “SpagoWorld projects are released under the GNU Lesser General Public License (LGPL). Briefly, it means that anyone who receives a SpagoWorld solution, they receive all the license rights and duties as well. According to the GNU LGPL License, if you modify a SpagoWorld solution and distribute the modified version, all changes fall under the GNU LGPL license” (http://www. spagoworld. org/xwiki/bin/view/SpagoWorld/Licenses).

The license for this assures that the software remains free even after its alterations. The client can also link it to any other free or proprietary program, provided that the source code of the Lesser General Public License is made available and that it can be updated to the rest of the program in which it is linked to. Architecture and Administration *SpagoBI** Server*: the BI platform which includes the analytical tools, the management of security and visibility rules, the administration tools *SpagoBI** Studio*: the new integrated development environment *SpagoBI** Meta*: the new environment focused on metadata SpagoBI** SDK*: the new integration layer to use SpagoBI from external tools *SpagoBI** Applications*: to collect the vertical analytical models built using SpagoBI The below diagram shows the SpagoBI architecture structure: {draw:frame} Components Here is the list of SpagoBI components: Core: application that can be deployed as a collections of portlets or as a stand-alone web application; it contains base functionalities. It is mandatory for any application using SpagoBI. BirtReportEngine: it is an implementation of a report engine integrating the Birt solution.

GeoEngine: it is an implementation of a map engine. JasperReportEngine: it is an implementation of a report engine integrating the JasperReport solution. JPaloEngine: it is an implementation of an OLAP engine based on the JPalo. JPivotEngine: it is an implementation of an OLAP engine based on the JPivot/Mondrian solution. WekaEngine: it is an implementation of a data mining engine based on the Weka solution. QbeEngine: engine based on Query-by-example, that is a visual mode for data inquiring. TalendEngine: engine for ETL jobs designed with Talend Open Studio. Demo: it is a SpagoBI platform demo version. ttp://spagobi. eng. it/SpagoBISiteENG/target/docs/components. html References http://en. wikipedia. org/wiki/Pentaho http://www. pentaho. com/license/ http://www. pentaho. com/license/ http://images. google. ie/imgres? imgurl=http://rnayak. files. wordpress. com/2006/10/pentaho_architecture. jpg=http://rnayak. wordpress. com/2006/10/12/53/=__MvH0gBhUMNNE6Ivg1eMa893dgp4==372=430=29=en=3=1=1=z92a1_idQ2jv_M:=109=126=/images%3Fq%3Dpentaho%2Barchitecture%26hl%3Den%26sa%3DX%26um%3D1 http://www. pentaho. com/offers/