Olap Tools

OLAP (On Line Analytical Processing) is used for business reports for companies using a number of protocols. Organisations can analyse data in a number of different ways i.e. budgeting, planning, data warehouse reporting, simulation and trend analysis. One of the main benefits of OLAP is the skill to make multidimensional calculations especially used for large businesses. This process will be complete in seconds There are many components of OLAP tools. In this report I will discuss and compare four OLAP tools and identify there strength and weaknesses. Four OLAP tools: Cognos Pentaho Hyperion Spagobi Cognos capabilities include Building reports, OLAP cubes, dashboards and scorecards using all data sources Cognos core products are Query studio, analysis studio and report studio the 3 web front ends cognos and BI offers for reporting and analysis Key areas evaluated include server platform, component integration, offline support and aspects of the front end functionality such as analysis, reporting and charting capabilities Business Intelligence users distribute all the dashboards, tactical, strategic, and operational to help them achieve, monitor and sustain corporate governance IBM Cognos 8 Business Intelligence applications There are several applications used by IBM Cognos and Business Intelligence:  Query Studio – Is a tool to create unplanned reports. Users are able to create one 1-page report at a time. This application may be used by Query Authors and Report Authors. http://www.cognos-bi.info/cognos8.html Because security was the main concern, Cognos chose to add Salesforce's data security features, Cognos is now 24/7 support for all users Cognos enjoys end-to-end visibility, tracking leads through to closed opportunities http://www.salesforce.com/eu/customers/hi-tech-software/cognos.jsp {draw:frame} The following chart contains Cognos License: