Business Objects to deliver OLAP for the mainstream business user; "Mercury" project to provide next-generation DSS Toolset with the industry's first fully integrated query, reporting, and analysis

Business Wire, Sept 25, 1995

CUPERTINO, Calif.--(BUSINESS WIRE)--Sept. 25, 1995--Business Objects, a leading provider of client/server decision support systems (DSS), today announced that it is developing the first toolset to provide mainstream business users with advanced online analytical processing (OLAP) functionality.

Code named Mercury, the toolset will integrate OLAP functionality into Business Objects' industry-leading query and reporting solution.

The Mercury project addresses a growing business requirement for front-line managers to make fast, intelligent decisions that can significantly impact a company's bottom line. These managers increasingly need to go beyond query and reporting, into the realm of sophisticated multidimensional analysis.

Mercury features breakthrough technology

Traditional multidimensional analysis solutions, from executive information systems (EIS) to OLAP servers, have historically been targeted at the needs of an elite group of users. Mercury will deliver OLAP functionality to the mainstream business user through a new architecture with four industry-unique components: unified metadata; a dynamic microcube engine; integrated query, reporting, and analysis tools; and an advanced set of repository-based IS utilities.

Unified metadata

Mercury will use a unified metadata repository that contains both business intelligence and data dimension information. This will provide two advantages over traditional OLAP approaches. Unified metadata will enable end users to work with a business representation of data, rather than working directly with the underlying database schema. Second, because the metadata repository will understand the dimensionality of the data, end users will be able to dynamically perform complex multidimensional analysis, without relying on IS for frequent assistance.

Dynamic microcube engine

Mercury introduces a major innovation -- the dynamic microcube engine -- that automatically and transparently builds micro-hypercubes (microcubes) on the user's desktop, eliminating the need for frequent IS intervention. Because they are both dynamic and inquiry specific, microcubes provide the ability to perform OLAP against large data volumes, with current data, and without heavy storage requirements.

Dynamic microcubes offer significant benefits over traditional OLAP solutions that rely on static hypercubes, which must hold large amounts of pre-defined data, can be time consuming to build due to their size, and must be periodically rebuilt to accommodate users' changing analysis needs.

Integrated query, reporting, and analysis tools

Mercury will provide the industry's first integrated set of tools to combine advanced query and reporting with state-of-the-art OLAP functions. Users can, for example, create graphical reports containing both tabular information and charts, and then "drill down" directly from within a report.

By integrating analysis with query and reporting in a single, document-centric metaphor, Mercury will provide end users a level of ease-of-use that is unmatched by any other vendor. Mercury also provides a host of wizards to assist users in performing complex operations, improving both ease of use and ease of learning.

Repository-based IS utilities

Mercury includes a new suite of repository-based IS tools for streamlining the setup, deployment, and administration of the decision support environment. The IS tools combined with the intelligent metadata repository will eliminate the tradeoff with current DSS solutions between IS setup and end-user ease-of-use.

"When we asked customers what they wanted most, they told us to enable analysis against relational databases, integrate analysis with query and reporting, improve enterprise deployability, and to do so without compromising our industry-leading ease-of-use. Mercury is our response to those demanding requests," said Bernard Liautaud, president and CEO of Business Objects. "By integrating OLAP with query and reporting, Mercury defines a new generation of decision support tool."

"Business Objects is headed in the right direction," said Robert Moran, senior analyst at Aberdeen Group, Inc., Boston, Mass. "Today's flatter organizations need to be able to deploy DSS solutions throughout the organization, not just at the top. Mercury will enable OLAP for the mainstream business user."

Mercury to deliver OLAP for the mainstream business user

Four key factors will contribute to Mercury's unique ability to deliver OLAP to mainstream business users:

-- Open -- Mercury provides OLAP without requiring the use of specialized multidimensional database servers or specialized relational database schemas. It also supports a wide variety of heterogeneous environments, including databases, middleware, and client hardware platforms.

-- Deployable -- Mercury's dynamic microcubes and repository-based IS toolset eliminate the need for day-to-day IS support of analysis and significantly reduce the amount of time needed to set up and maintain the decision support environment.