Crystal Reports for Enterprise and Multisource Universe
To illustrate the servers involved in creating a report, saving and refreshing based on a multisource universe
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
- Data display
- Enhanced Integrity Check
- Derived Tables
- Unlimited Undo and Redo
- Multi Source Universes
- Calculated columns
- BI Projects
- Business ObjectsSQL
- OLAP hierarchy Support
- Data profiling
- 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
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
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
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
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.