Crystal Reports for Enterprise and Multisource Universe

[Former Member]

Purpose

To illustrate the servers involved in creating a report, saving and refreshing based on a multisource universe

Overview

When creating reports off a multisource universe the servers which come into picture are unlike the regular datasource based report. There are various error messages which occur if any of those are missing.

Information Design Tool

Improved Features

• Data display
• Context
• Enhanced Integrity Check
• Comments
• LOV's
• Search
• Derived Tables
• Unlimited Undo and Redo

New Features:

• Multi Source Universes
• Calculated columns
• BI Projects
• Families
• Business ObjectsSQL
• OLAP hierarchy Support
• Data profiling
• Prompts
• Query editor
• Predefined filters
• Computation Statictics

For more information on IDT and how to create a Multisource Universe you may refer the following documentations.

Step by Step description to create a Multisource Universe

Creating a Report of a Multisource universe in CRforE

Scenario 1:

CMS, Input File Repository Server, Crystal Reports Processing Server(CPRS) and
Crystal Reports Cache Server(CRCS) are running

When one logs into the SAP BI server repository he will get the list of available objects (in this case its unx file). After selecting the universe and clicking on next it will give the following error

Scenario 2:

Report is created successfully when CMS, Input File Repository Server(IFRS) and Default Adaptive Processing Server(APS) is running

In APS only following Services are required to report of a multisource universe

• Data Federator Service
• Adaptive Connectivity Service
• DSL Bridge Service

If any of the above service is not running then it will give an error.
In case of Multisource universe Data Federator service is involved. Connection servers are not required to report off a Multisource universe from CRforE.

Save a report from CRforE based on a Multisource universe to SAP BI server

Scenario 1:

All servers are stopped and only CMS, IFRS and CRPS are running. It gives the following error. It gives the same error if CRCS is stopped and others are running

Here APS is not required.

The report could be saved successfully if CMS, Crystal Reports Cache Server, Crystal Reports Processing Server and Input File Repository Server are running.

Why Crystal Reports Cache Server and Crystal Reports Processing Server are required while saving the report?

While creating the report neither of the two are required. However they both come into picture while saving the report.

This can be clarified with the help of ProcMon (Process Monitor) utility.

While saving the report run ProcMon simultaneously click on save and monitor CrystalReports.exe in it.  You can see the following

The request is first sent to CRCS and then passed to CRPS. In the highlighted location it can be observed that CRPS writes into a
particular location.

Now re launch CRforE and ProcMon access the same location which is as follows to observe what happens in there.

C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI4.0 Data\CrystalReportsProcessingServer\temp\BIPW08R2.CrystalReportsProcessingServer\child_JRC-VIEW5

"child_JRC-VIEW6" this folder is created when one tries to save the report from CRforE as follows

CRPROC.EXE creates this folder temporarily and cleans it as well.

In this folder crproc.exe writes the template of the report temporarily for fractions of seconds and then cleans it as well.

  And then it writes the report to Input File Repository.

The reason to open this topic and explain in brief was, CR processing Server and CR cache server they never come into picture while creating or refreshing the report.