Wednesday, December 14, 2016

SAP Crystal Reports

Crystal Reports (questions and sites on bottom)

What:  Design Explore, Visualize, and provide report, which can be run on web or enterprise applications.

Crystal Reports is a business intelligence application, currently marketed to small businesses[1] by SAP SE. It is used to design and generate reports from a wide range of data sources.[2]

    BO Crystal Reports = Design well-formatted, layout-focused reports.

Crystal Reports, WEBI, SBOP Dashboards are able to leverage hierarchies in reports but are lacking deep hierarchial capabilities.

Crystal Reports for Enterprise

In Crystal Reports for Enterprise, you can access SAP HANA data by using an existing relational connection created using the information design tool.
You can also connect to SAP HANA using an OLAP connection created using information design tool or CMC.

Qs:30 A company wants to use SAP BusinessObjects reporting tools. They cannot use Adobe Flash. They require scheduled, ready-made reports. Which reporting tool do you recommend? (Choose two)

A. Dashboards 
B. Web Intelligence 
C. Explorer 
D. Crystal Reports

Step 3) To consume Universe by Web Intelligence, Dashboards or Crystal Report for Enterprise, we need to publish the connection. So, now we publish connection for SAP HANA.cnx.


      Why are Crystal Reports used ?

Crystal Report is for developing formatted reports like P & L, Balance sheet, etc.  

#Which BO tool is good for Formatted reports
A. Crystal reports


10.  Semantic Layer (UNX) is available for reporting by which of the following reporting  tools

a.     Crystal Reports Enterprise, Dashboards & WEBI

71. Pre-requisite to execute Crystal reports enterprise?
·         JDBC / ODBC Interfaces

·         Relational Universe





1) Explain what is Crystal Reports?
Crystal report is a window based report writer that enables the programmer to make reports from different data sources with a minimum of written code. Crystal report can access data from various data-bases and can synchronize data from multiple databases into a single report
2) Explain how can you connect crystal report to the databases?
To connect crystal report to the databases, there are two ways
  • Use crystal report built in query
  • Use the tool “Crystal SQL Designer” given by crystal report
3) Explain whether it is possible to create our own formulas in crystal reports?

Yes, it is possible to create your own formulas in Crystal reports. For that from insert menu item choose “Formula Field”. Write the formula in “Formula Editor”, here you will see “Function Tree” , “Field Tree” , “Operator Tree” which will show the report fields, functions supported by crystal reports, operators etc.

  1. Crystal Report 2011 /13 /16: This will be used when –
  • 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
  1. Crystal Report for Enterprises: This will be used when -
  • If there are Universe available or needed, then use SAP Crystal Reports Enterprises.
We will use crystal reports for enterprises.

Step 1) Login into Crystal Report for Enterprises.





SAP Crystal reports for Enterprises will be displayed as below-

  1. It is Report Formatting section, which provides a different tool for formatting.
  2. This is an icon for the window (Data Explorer, outline, Group tree, Find).
  3. Detail of Data Explorer, outline, Group tree, Find, etc. will be displayed.
  4. Report Page Formatting option.
  5. Work Area for Report.

Step 2) Now we create a connection for the data source.
        
   Click on Choose data Source option from Data Explorer-




A pop-up for Choose a data source type will be displayed-

Select Browse option from SAP HANA Platform Section.

Connect to server: New Server



A window for Server connection will be displayed as below-

  1. Click on Add Button.
  2. Enter Connection Display Name (saphana).
  3. A connection Name will appear in the connection list.
  4. Enter HANA Server name.
  5. Enter HANA Server Instance Name.
  6. Enter HANA username.
  7. Click on "Test Connection "Button.
  8. A pop-up for Test connection logon. Enter password for SAP HANA user.
  9. Click on the OK button.







Step 3) In this step,

  1. We will do the following thing
    1. Select server "saphana."
    2. Click on OK button


One more pop-up will appear for selecting HANA View.
2) In this step, we select SAP HANA View.

  1. Select HANA View (Analytic View AN_PURCHASE_ORDERS).
  2. Click on OK Button.
  1. In this step, a window for Query will open.
Follow below point to create a query-

  1. Select required column from the list for the query.
  2. Drag and Drop required field in Query.
  3. Click on Refresh button.
  4. The result set will be displayed.
Click Finish









Questions: 
1) A company wants to use SAP BusinessObjects reporting tools. They cannot use Adobe Flash. They require scheduled, ready-made reports. Which reporting tool do you recommend? (Choose two)

A. Dashboards 
B. Web Intelligence 
C. Explorer 
D. Crystal Reports

Step 3) To consume Universe by Web Intelligence, Dashboards or Crystal Report for Enterprise, we need to publish the connection. So, now we publish connection for SAP HANA.cnx.

2) Why are Crystal Reports used ?
Crystal Report is for developing formatted reports like P & L, Balance sheet, etc.  

3) Which BO tool is good for Formatted reports
A. Crystal reports

4) Semantic Layer (UNX) is available for reporting by which of the following reporting  tools
a.     Crystal Reports Enterprise, Dashboards & WEBI

5) Pre-requisite to execute Crystal reports enterprise?
·         JDBC / ODBC Interfaces
·         Relational Universe

6) Explain how can you connect crystal report to the databases?

         To connect crystal report to the databases, there are two ways

          Use crystal report built in query
          Use the tool “Crystal SQL Designer” given by crystal report


7) Explain whether it is possible to create our own formulas in crystal reports?

Yes, it is possible to create your own formulas in Crystal reports.

8)When will Crystal Report be used?
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

9)How is Crystal Reports transferred to SAP HANA vs Crystal reports Enterprise?



10)  How to create a connection for the data source?
   -Choose data explorer =>  Choose data source/connection (browse) => Conection display name ==> connectio name, SAP (server name, server isntance name, username),test connection

   -Create a query:  1) select column from the list for the query, refresh, results






Crystal Reports Enterprise:  USED HANA(DIRECT-HANA/VAR/NOT HIER)



3) Which BO tool is good for Formatted reports
A. Crystal reports

4) Which BO tool is good for visualization
BO Explorer









http://dba1admin.blogspot.com/2015/12/sap-hana-questions-and-answers.html
https://en.wikipedia.org/wiki/Crystal_Reports

http://www.guru99.com/sap-hana-reporting.html#3

No comments:

Post a Comment