Bi Rep Tool Comparison Guide

8
PROJECT IDENTIFICATION Project Name CPI/Project Number Project Type (CBI, Implementation, CSS, Upgrade, Internal, other) Customer Name Customer Number Planned Start/Finish SAP Customer Partner Project Sponsor Program Manager SAP Project Manager Customer Project Manager Partner Project Manager REPORT CRITERIA DECISION TREE

Transcript of Bi Rep Tool Comparison Guide

Page 1: Bi Rep Tool Comparison Guide

PROJECT IDENTIFICATION

Project Name CPI/Project Number Project Type(CBI, Implementation, CSS, Upgrade, Internal, other)

Customer Name Customer Number Planned Start/Finish

SAP Customer Partner Project Sponsor Program Manager

SAP Project Manager Customer Project Manager Partner Project Manager

REPORT CRITERIA DECISION TREE

Page 2: Bi Rep Tool Comparison Guide

Table of contents

1. Introduction........................................................................................................................22. General Guidelines...........................................................................................................22.1. Crystal Reports........................................................................................................................22.2. Web Intelligence......................................................................................................................22.3. OLAP Voyager.........................................................................................................................32.4. Crystal Xcelsius.......................................................................................................................32.5. Live Office................................................................................................................................32.6. Dashboard Builder...................................................................................................................33. Report Criteria Matrix..........................................................................................................3

1.INTRODUCTION

The objective of this document is to provide a high level product comparison. This product comparison will allow decision makers a vehicle they can use to select the correct Business Objects tool to use in any given situation. This Decision Tree document should be used as a starting point, and will guide a decision maker to the best tool to use in any reporting situation.

2.GENERAL GUIDELINES

This section will provide general information about each tool. It should be used to understand the strengths

and primary purposes of each tool.

2.1.Crystal Reports

Crystal Reports is a high quality transactional reporting environment. It provides documents that require pixel

perfect layouts and highly formatted information. It provides extremely rich graphics and a high quality look.

Crystal Reports allow users to quickly and sufficiently print pixel perfect documents.

2.2.Web Intelligence

Web Intelligence is a high quality analytical reporting environment. It provides self-service access to corporate

information. Web Intelligence documents allow end users the capability of interacting with the information in

meaning ways. It allows users the capability of creating high quality documents. These documents can

contain rich graphics and a high quality look. However, the ability to drill-down, drill-across and slice-and-dice

the data is the real benefit of a Web Intelligence document. Users truly have the capability of analyzing the

data in any way they see fit.

©SAP AG 2009

Copyright © 2009 SAP AG. All rights reserved 2

Page 3: Bi Rep Tool Comparison Guide

2.3.OLAP Voyager

OLAP Voyager allows users to explore OLAP data. The OLAP Voyager tool is designed specifically for

financial and business analysts, and delivers to them a full range of functions to analyze multi-dimensional data

sets (i.e. OLAP cubes). Users are able to quickly answer business questions and then share their analysis and

workspace with others.

2.4.Crystal Xcelsius

Crystal Xcelsius allows organizations the ability to visualize their business with consolidated views of key

metrics and information. Through "what-if" analysis, customer segmentation and forecasting, an organization

can transform information and interact with sophisticated visual representations of business processes that

provide new insights and the ability to respond quickly with informed decisions. Crystal Xcelsius is a data

visualization tool designed to create flash-based interactive data presentations and dashboards.

2.5.Live Office

Live Office allows users to access corporate data from within Microsoft Office (i.e. Microsoft PowerPoint, Excel,

and Word documents). Right within Microsoft Office, you can use intuitive wizards and tool bars to select

corporate data from a Crystal Reports document, a Web Intelligence document, or via an ad-hoc data selection

(i.e. Query Panel). These documents can be shared with others over the web for collaborative decision-

making.

2.6.Dashboard Builder

Dashboard Builder provides visibility across an organization. It allows users the ability to quickly and easily

display their Business Intelligence content together in one consolidated view. By leveraging universe security,

users only access what they are allowed to see. They can navigate from a high-level summary to a detailed

review of root cause analysis. With drag-and-drop functionality, Dashboard Builder enables users the ability to

quickly build dashboards and rapidly deploy them across the organization.

©SAP AG 2009

Copyright © 2009 SAP AG. All rights reserved 3

Page 4: Bi Rep Tool Comparison Guide

3.REPORT CRITERIA MATRIX

The Report Criteria Matrix is illustrated on the following page. It is provided to quickly and efficiently examine common features of the various toolsets. It is provided as a starting point when deciding which toolset to use for a given report or application. The matrix summarizes the features of each toolset and allows decision makers to make informed decisions based upon

©SAP AG 2009

Copyright © 2009 SAP AG. All rights reserved 4

Page 5: Bi Rep Tool Comparison Guide

  Crystal Reports Web Intelligence OLAP Voyager Crystal Xcelsius Live Office Dashboard Builder

General Pixel Perfect Transactional Reports

High Quality Analytical Reports

OLAP Cube Analytical Reports

Visualizations and Dashboards

Access to Corporate Data from within Microsoft Office

User Built Dashboards

Export Options RPT (Crystal Reports format)

Adobe PDF Microsoft Excel SWF (Macromedia Flash)

Microsoft Excel  

  Adobe PDF Microsoft Excel CSV Adobe PDF Microsoft Word    Microsoft Excel CSV   Microsoft Word Microsoft

PowerPoint 

  Microsoft Word CSV (with options)   Microsoft PowerPoint

CSV  

  RTF (rich text format)

    Microsoft Outlook RTF (rich text format)

 

  XML     HTML XML            HTML  Printing Print directly to a

printerExport to PDF for Printing

Export to PDF for Printing

Print directly to a printer (Designer tool only).BOXI 3.0 – print from screen to printer.

Print directly to a printer

Browser print functionality available

Drilling Some Drilling Functionality

Extensive Drilling and Slice & Dice Functionality

Extensive Drilling and Slice & Dice Functionality

Drilling can be built into the report

Drilling can be built into the report

Drilling can be built into dashboards

Prompting Cascading and other prompting

Cascading and other prompting

  Prompting can be built into the report

Cascading and other prompting

Prompting can be built into dashboards

Sorting Designer tool only Interactive Sorting Interactive Sorting Sorting can be built Interactive Sorting Sorting can be built

Page 6: Bi Rep Tool Comparison Guide

In BOXI 3.0 – sorting available in viewer

into the report into dashboards

Filtering Designer tool only Interactive Filtering Interactive Filtering Filtering can be built into the report

Interactive Filtering Filtering can be built into dashboards

Ranking Designer tool only Interactive Ranking Interactive Ranking Ranking can be built into the report

Interactive Ranking Ranking can be built into dashboards

Data Sets Large (>10,000 rows)

Medium (<10,000 rows)

Large Small to Medium Large Large

Semantic Layer Universe, Business View, Freehand SQL, others

Universe, Freehand SQL

OLAP Cube N/A Universe, Crystal Report, Web Intelligence Document

N/A

Security Security applied to instances

Security applied upon refresh

Security applied to instances

Security can be built into the report

Security applied to instances

Security applied to instances

Training Authoring training recommended for developers. No view training required

Training needed for more advanced authoring capabilities

Minimal Training needed to navigate

Authoring training recommended for developers.No view training required.

Minimal Training needed to navigate

Minimal Training needed to create dashboards.No view training required.

Changes & Formatting

Designer tool only Interactive Changes & Formatting

Interactive Changes & Formatting

Designer tool only Interactive Changes & Formatting

Interactive Changes & Formatting

Miscellaneous Sub-reports can be embedded, designer tool only

    In addition to dashboarding, can provide a prompt selector front-end to Crystal Reports and WebI documents.Also provides database write-back.

   

©SAP AG 2009

Copyright © 2009 SAP AG. All rights reserved 6