Performance and Implementation Considerations

There are certain factors that an organization should take into account before implementing Business Views. Because many people will likely use each Business View, care should be taken when building the query to ensure that performance meets expectations. Additionally, because of the increased functionality (such as joining two data sources), you might be tempted to simply create a structure that fulfills business requirements but sacrifices performance. Although most of the performance considerations are exactly the same as those for Crystal Reports design, some of the most common pitfalls are considered in the following sections.

Joining Large Data Sets

It is recommended to keep disparate data source joins to a minimum for large data sets to keep performance satisfactory. Because Crystal Enterprise must, based on the Business View, link the data on the Crystal Enterprise server, both data sets must be transferred to that system before they can be joined. Further, joining large data sets can tax the memory resources of the Crystal Enterprise server.

CAUTION

With the use of disparate data sources, Business Views do not allow the Crystal Report option of grouping on the server. To concatenate the disparate data sets, most of the processing is performed within Crystal Enterprise and not the database.

To ameliorate performance concerns, users or administrators can schedule reports at off-peak hours and cached into the system; the user is not waiting for the report at view time. Another solution might be to combine the disparate data sources into one data source.

For more information on scheduling, see Chapter 23, "Using Crystal Enterprise with Web Desktop," and Chapter 27, "Administering and Configuring Crystal Enterprise."

Business Objects Universe

Prior to its acquisition of Crystal Decisions, Business Objects provided Business View functionality in the form of Universes. Business Objects has released a roadmap with migration information that indicates that Business Objects Universes and Crystal Business Views will be merged at some future point. Contact Business Objects for more information.

Versioning

The Crystal Repository does not provide version control. Although there are alternatives to achieving versioning, the user cannot simply revert to a prior version, for instance.

Using Other Metadata

Other applications generate metadata layers; for example, ETL tools have their own metadata layers. One advantage is to be able to use this metadata so that the number of metadata layers is kept to a minimum. Currently Business Views do not support using other metadata layers or the importing of these layers. Please contact Business Objects for more information.

Part I. Crystal Reports Design

Creating and Designing Basic Reports

Selecting and Grouping Data

Filtering, Sorting, and Summarizing Data

Understanding and Implementing Formulas

Implementing Parameters for Dynamic Reporting

Part II. Formatting Crystal Reports

Fundamentals of Report Formatting

Working with Report Sections

Visualizing Your Data with Charts and Maps

Custom Formatting Techniques

Part III. Advanced Crystal Reports Design

Using Cross-Tabs for Summarized Reporting

Using Record Selections and Alerts for Interactive Reporting

Using Subreports and Multi-Pass Reporting

Using Formulas and Custom Functions

Designing Effective Report Templates

Additional Data Sources for Crystal Reports

Multidimensional Reporting Against OLAP Data with Crystal Reports

Part IV. Enterprise Report Design Analytic, Web-based, and Excel Report Design

Introduction to Crystal Repository

Crystal Reports Semantic Layer Business Views

Creating Crystal Analysis Reports

Advanced Crystal Analysis Report Design

Ad-Hoc Application and Excel Plug-in for Ad-Hoc and Analytic Reporting

Part V. Web Report Distribution Using Crystal Enterprise

Introduction to Crystal Enterprise

Using Crystal Enterprise with Web Desktop

Crystal Enterprise Architecture

Planning Considerations When Deploying Crystal Enterprise

Deploying Crystal Enterprise in a Complex Network Environment

Administering and Configuring Crystal Enterprise

Part VI. Customized Report Distribution Using Crystal Reports Components

Java Reporting Components

Crystal Reports .NET Components

COM Reporting Components

Part VII. Customized Report Distribution Using Crystal Enterprise Embedded Edition

Introduction to Crystal Enterprise Embedded Edition

Crystal Enterprise Viewing Reports

Crystal Enterprise Embedded Report Modification and Creation

Part VIII. Customized Report Distribution Using Crystal Enterprise Professional

Introduction to the Crystal Enterprise Professional Object Model

Creating Enterprise Reports Applications with Crystal Enterprise Part I

Creating Enterprise Reporting Applications with Crystal Enterprise Part II

Appendix A. Using Sql Queries In Crystal Reports

Creating Enterprise Reporting Applications with Crystal Enterprise Part II



Special Edition Using Crystal Reports 10
Special Edition Using Crystal Reports 10
ISBN: 0789731134
EAN: 2147483647
Year: 2003
Pages: 341

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net