Crystal Reports

In SAP HANA, you can create crystal reports using the relational connection established with the help of Information design tool. These crystal reports do help the creation of design, exploration, and visualization which plays a vital role in web applications and enterprise software. Both complex and simple crystal reports can be created using the SAP HANA Studio.

Connecting with SAP HANA

Following are the various method of connecting with SAP HANA data while creating the crystal reports.

OLAP Connection in Design Studio

Design Studio can access SAP HANA data by using an existing OLAP connection created in Information design tool or CMC same like Office Analysis.

Connecting via Dashboards

Dashboards can connect to SAP HANA only through a relational Universe. Customers using Dashboards on top of SAP HANA should strongly consider building their new dashboards with Design Studio.

Connecting via Web Intelligence

Web Intelligence can connect to SAP HANA only through a Relational Universe.

The SAP Lumira Application Connection

Lumira can connect directly to SAP HANA Analytic and Calculation views. It can also connect to SAP HANA through SAP BI Platform using a relational Universe.

Using OLAP – Office Analysis edition to connect

In Office Analysis edition for OLAP, you can connect to SAP HANA using an OLAP connection defined in the Central Management Console or in Information design tool.

Types of SAP HANA Crystal Reports

Typically, there are the two types of crystal reports used in the SAP HANA system. They are Crystal Report 2011/2013/2016 and Crystal Report for Enterprises.

Crystal Report 2011 /2013 /2016

This crystal report is well suited in the case of following scenarios

• If you want to call a HANA stored procedure from Crystal Reports.
• If you want to create SQL Expressions
• If you want to execute a view with parameters or variables and submit non-default values

Crystal Report for Enterprises

Crystal Reports for Enterprises can be effectively utilized during the following scenarios,

• If there are Universe available or needed, then use SAP Crystal Reports Enterprises.

Reporting in the SAP Lumira Application

The SAP Lumira Application is a new software by SAP to Analyze and Visualize data.

By The SAP Lumira Application user can create a beautiful and interactive map, infographics, and charts. The SAP Lumira Application can import data from Excel, and another source.

The SAP Lumira Application can access information view of SAP HANA directly. SAP HANA Perform visual BI analysis using dashboard.

In The SAP Lumira Application, the following steps need to be done to visualize data.