SAP HANA Crystal Reports in SAP HANA

What is SAP HANA Crystal Reports?

Crystal reports for enterprise

In Crystal reports for the enterprise, you can access SAP HANA data via using an existing relational connection created using the information design tool.

you can also hook up with SAP HANA using an OLAP Connection created the usage of statistics layout device or CMC.

Design Studio

design Studio can access SAP HANA facts via the usage of a current OLAP connection created in information design tool or CMC same like office analysis.

Dashboards

Dashboards can connect with SAP HANA only thru a relational Universe. customers using Dashboards on top of SAP HANA have to strongly recollect constructing their new dashboards with layout Studio.

Web Intelligence

web Intelligence can hook up with SAP HANA only thru a Relational Universe.

SAP Lumira

Lumira can join directly to SAP HANA Analytic and Calculation views. it could also connect to SAP HANA via SAP BI Platform the use of a relational Universe.

Office Analysis, edition for OLAP

In workplace evaluation version for OLAP, you could connect to SAP HANA using an OLAP connection described within the valuable control Console or in statistics layout tool.

Explorer

You may create a statistics area based totally on an SAP HANA view the usage of JDBC drivers.

Creating an OLAP Connection in CMC

we can create an OLAP Connection for all of the BI equipment, which we need to use on top of HANA perspectives like OLAP for analysis, Crystal report for the enterprise, design Studio. Relational connection through IDT is used to attach web Intelligence and Dashboards to HANA database.

That connection may be created the use of IDT as well CMC and both of the connections are stored in BO Repository.

Login to CMC with the username and password.

From the drop-down listing of connections, choose an OLAP connection. It’s going to additionally display already created connections in CMC. To create a new connection, go to the green icon and click on this.

Enter the name of an OLAP connection and description. Multiple persons, to connect to HANA views, in different BI Platform tools, can use this connection.

Provider − SAP HANA
Server − Enter HANA Server name
Instance − Instance number

It also offers an alternative to connecting to a single cube (you may also choose to hook up with single Analytic or Calculation view) or to the full HANA system.

Click on connect and choose modeling view by using entering username and password.

• Authentication sorts − three kinds of Authentication are possible while creating an OLAP connection in CMC.
• Predefined − it's going to no longer ask username and password again while using this connection.
• Prompt − every time it will ask username and password
• SSO − user specific
• Enter user − username and password for HANA system and keep and the new connection may be introduced to the current list of connections.

Now open BI Launchpad to open all BI platform gear for reporting workplace Analysis for OLAP and it will ask to select a connection. By means of default, it will show you the information View when you have specified it while creating this connection otherwise clicks on next and go to folders → choose views (Analytic or Calculation views).

SAP Lumira connectivity with HANA system

Open SAP Lumira from Start Program, Click on file menu → New → Add new dataset → Connect to SAP HANA → Next

Difference between connect to SAP HANA and download from SAP HANA is that it will download data from Hana system to BO repository and refreshing of data will not occur with changes in HANA system. Enter HANA server name and Instance number. Enter user name and password → click on Connect.

it's going to show all perspectives. you can search with the view name → choose View → next. it will show all measures and dimensions. you could select from these attributes in case you need → click on on create choice.

There are 4 tabs internal SAP Lumira −

• prepare − you may see the information and do any custom calculation.
• Visualize − you can upload Graphs and Charts. click on X axis and Y axis + sign to add attributes.
• Compose − this selection may be used to create collection of Visualization (story) → click on on Board to add numbers of forums → create → it will show all the visualizations on left aspect. Drag first Visualization then upload page then add second visualization.
• Share − If it's miles built on SAP HANA, we will only put up to SAP Lumira server. otherwise you may also post tale from SAP Lumira to SAP community network SCN or BI Platform.

Store the document to apply it later → visit record-store → select local → store

Creating a Relational Connection in IDT to apply with HANA perspectives in WebI and Dashboard −

Open information layout tool → by going to BI Platform client tools. click on New → project input project name → finish.

Right-click on Project name → Go to New → Choose Relational Connection → Enter Connection/resource name → Next → choose SAP from list to connect to HANA system → SAP HANA → Select JDBC/ODBC drivers → click on Next → Enter HANA system details → Click on Next and Finish.

You can also test this connection by clicking on Test Connection option.

Test Connection → Successful. Next step is to publish this connection to Repository to make it available for use.
Right Click on connection name → click on Publish connection to Repository → Enter BO Repository name and password → click on Connect → Next →Finish → Yes.

It will create a new relational connection with .cns extension.

.cns − connection type represents secured Repository connection that should be used to create Data foundation.
.cnx − represents local unsecured connection. If you use this connection while creating and publishing a Universe, it will not allow you to publish that to repository.
Choose .cns connection type → Right Click on this → click on New Data foundation → Enter Name of Data foundation → Next → Single source/multi source → click on Next → Finish.

It will show all the tables in HANA database with Schema name in the middle pane.
Import all tables from HANA database to master pane to create a Universe. Join Dim and Fact tables with primary keys in Dim tables to create a Schema.

Double click on on the Joins and hit upon Cardinality → detect → ok → keep All on the pinnacle. Now we need to create a new business layer at the information foundation that will be consumed by BI application tools.

proper click on .dfx and select new commercial enterprise Layer → input name → finish →. it's going to display all of the objects automatically, under master pane →. alternate dimension to Measures (type-measure change Projection as required) → Save All.

Right-click on .bfx file → click on Publish → To Repository → click on Next → Finish → Universe Published Successfully.
Now open WebI Report from BI Launchpad or Webi rich client from BI Platform client tools → New → select Universe → TEST_SAP_HANA → OK.

All Objects will be added to Query Panel. You can choose attributes and measures from left pane and add them to Result Objects. The Run query will run the SQL query and the output will be generated in the form of Report in WebI as shown below.