Page 73 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes Hyperion’s Business Intelligence Platform Scheme

In mid-2001, Hyperion changed its business strategy, shifting its focus from business intelligence
software infrastructure and applications to business presentation management programs
answers. The firm states its target “is to be the premier global provider of business presentation
management solutions.” These solutions are created to automate the business performance
administration method of scheme setting, modelling, planning, performance supervising,
describing and investigation. Their target is to improve your profitability.
The expertise platform for Hyperion’s performance administration solutions is Essbase, its
venerable OLAP Server Within the new strategy, Hyperion states that Essbase technology will
be enhanced in the areas of ease of use, ease of application development, interoperability of
business performance management applications, scalability, and tighter integration with
relational data sources. Missing from Hyperion’s enhancement strategy for Essbase are localities
such as analytic technology and business intelligence platform technologies. Essbase is evolving
away from a general reason OLAP facility and in the direction of a platform for carrying a very
exact type of business understanding application.
Hyperion’s new scheme and target can play quite well in today’s business understanding market
where companies’ top main concerns are to do business more competently and efficiently.
Business performance administration is a classic business intelligence submission. It requires a
comprehensive business intelligence platform as its base in order to assemble the data that
comprises business presentation, organize that data, investigate it, present it, and use investigation
outcomes to advance business presentation.

Packaging and Pricing

Hyperion Essbase has a pricing model for with two elements: a per server charge and a per
entitled client charge. Currently, per server charge is $28,000 per processor and per entitled
client charge is $1,500. Essbase packaging includes the OLAP server, administrative tools, and
construct and organise tools.

!
Caution Essbase installations most commonly use relational data warehouses as the data
causes for Essbase cubes.

Comparing Business Intelligence Databases

The following table enumerates BI Databases of different companies:

Table 5.1: Different BI Databases

Interfaces
Microsoft Oracle IBM Hyperion
Relational SQL and SQL and SQL and DB2 Not applicable
interfaces Transact/SQL PL/SQL SQL
ODBC and JDBC ODBC and ODBC and JDBC
OLE DB JDBC
ADO
ADO.NET
OLAP MDX OLAP DML Essbase API Essbase API
Interfaces DSO Java OLAP API
Pivot Table Service SQL and
XML for Analysis PL/SQL
Contd....

68 LOVELY PROFESSIONAL UNIVERSITY