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 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 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 can hook up with SAP HANA only thru a Relational Universe.
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.
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.
You may create a statistics area based totally on an SAP HANA view the usage of JDBC drivers.
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.
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).
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 −
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.
SAP HANA Related Interview Questions
|SAP BI Interview Questions||SAP HR Interview Questions|
|SAP BO Interview Questions||SAP BASIS Interview Questions|
|SAP ABAP Interview Questions||SAP BW Interview Questions|
|Hadoop Interview Questions||SAP SRM Interview Questions|
|SAP BPC Interview Questions||SAP Testing Interview Questions|
Sap Hana Tutorial
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.