Bi Rep Tool Comparison Guide
Transcript of 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
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
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
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
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
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