SAP Knowledge Base Article - Public

2195098 - How Crystal report based on universe works?

Symptom

How Crystal report based on universe (.UNV) works?

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013

Resolution

When a crystal report based on universe (.UNV) is refresh, it performs the following tasks:

  1. When one expands the option Universe in Database Expert, it prompts for login to the enterprise. Here, it communicates with CMS for authentication and authorization.
  2. After selecting universe objects when one clicks on Next or Show command, it sends a request to Web Intelligence Processing Server to get a query.
  3. Web Intelligence Processing Server sends a query to Crystal Reports designer and Crystal Reports designer uses the same query to hit the reporting database and retrieve records.
  4. Here, it uses the database drivers (local) available on the client machine.

Keywords

CR, Crystal reports, universe, UNV, workflow, refresh , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013