SAP HANA BI Development Interview Questions & Answers

  1. Question 1. What Are The Different Sap Businessobjects Reporting And Dashboard Tools?

    Answer :

    • Web Intelligence
    • Dashboard Designer (Earlier known as XCelsius)
    • Universe Designer (For Semantic Layer)
    • SAP Crystal Reports
    • SAP Lumira
    • SAP Design Studio
    • BusinessObjects Explorer
    • Analysis for OLAP
  2. Question 2. What Is The Use Of Sap Bi Launchpad?

    Answer :

    BI Launchpad has the following important options :

    Home : Displays the recent messages, alerts, documents, and applications that can be run.

    Documents : Displays the available documents and folders, making it easier to view, organize, and manage the documents.

    Any Open Document : Displays each open document.

  3. SAP BI Interview Questions

  4. Question 3. What Is The Use Of Relational Connection And An Olap Connection?

    Answer :

    Relational Connection: A Relational connection is used to connect to the Database layer in HANA. You can connect to database objects – tables, views, and design Data Foundation layer in the Information Design tool. You can also import tables and joins from the data source.

    OLAP Connection: OLAP is a multidimensional connection that directly points to the business layer in a data model. It allows to connect to multidimensional schema directly and later, they can be used with SAP Business Objects reporting tools.

  5. Question 4. What Is The Difference Between .cns And .cnx Connection?

    Answer :

    .cns − Secured Repository connection

    .cnx-local unsecured − If you use this connection, it will not allow you to publish anything to the repository.

  6. SAP BI Tutorial

  7. Question 5. What Are The Different Types Of Hana Information Views?

    Answer :

    SAP HANA provides the following three types of Information Views :

    • Attribute View
    • Analytic View
    • Calculation View
  8. SAP HR Interview Questions

  9. Question 6. What Are The Different Input Parameters Types In Sap Hana?

    Answer :

    Direct: Using this parameter type, you can pass any value for the parameter.

    Column: This parameter type allows you to select any value from the list of distinct values available in a column in HANA view.

    Derived From Table: It is also possible to create dynamic values in a table. This allows you to select any of the available values from the list.

    Static List:It is also possible to create a static list of values and provide user input during execution.

  10. Question 7. What Are The Different Features Of Analytic Views In Sap Hana?

    Answer :

    Following are the properties of SAP HANA Analytic View:

    • Analytic Views are used to perform complex calculations and Aggregate functions such as Sum, Count, Min, Max, etc.
    • Analytic Views are designed to run Start schema queries.
    • Each Analytic View has one Fact table surrounded by multiple dimension tables. Fact table contains a primary key for each Dim table and measures.
    • Analytic Views are similar to Info Objects and Info sets of SAP BW.
    • SAP BusinessObjects reporting tools can connect to Analytic view using an OLAP connection for reporting and dashboard.
  11. SAP HR Tutorial
    SAP BO Interview Questions

  12. Question 8. Which Bo Tools Can Connect To Hana System Using A Universe?

    Answer :

    All BusinessObjects tool – Webi, Dashboard Designer, Lumira, Crystal Reports, Design Studio that provide Universe connectivity as data source can be used to connect to HANA system.

  13. Question 9. Which Version Of Sap Businessobjects Provide Direct Connectivity Of Web Intelligence To Hana System?

    Answer :

    BusinessObjects 4.2

  14. SAP BW Interview Questions

  15. Question 10. In Businessobjects 4.2, What Are The Different Ways To Connect Webi To Hana Views?

    Answer :

    • Using Universe on top of HANA Modeling views
    • Direct Webi connection with HANA Modeling views
    • SAP HANA Online connectivity
    • Using Free-Hand SQL
  16. SAP BO Tutorial

  17. Question 11. How Do You Connect Dashboard Designer To Hana Database For Dashboard Creation?

    Answer :

    You can connect to SAP HANA using Universe connectivity from the Dashboard. SAP Dashboard supports SAP HANA backed with Universe created on top of HANA views and tables. You can consume Universe Designer .unx files using the Query Browser option to develop the dashboard.

  18. SAP HANA Interview Questions

  19. Question 12. What Are The Different Data Sources Option Available Under Crystal Reports?

    Answer :

    Crystal Reports can connect to multiple data sources that include:

    • Universe
    • SAP BEx Query
    • HANA view
    • Excel Spreadsheets
  20. SAP BI Interview Questions

  21. Question 13. While Using Sap Hana Bi Development, Which Hana View Can Be Used To Implement Star Queries?

    Answer :

    Analytic View

  22. SAP BW Tutorial

  23. Question 14. What Are The Different Ways To Create Calculation Views To Be Used In Bi Reporting?

    Answer :

    • Using GUI option
    • Using SQL Script
  24. Question 15. What Are The Different Geographic Chart Types Available Under Sap Lumira?

    Answer :

    • Geo Bubble Chart
    • Geo Choropleth Chart
    • Geo Pie Chart
    • Geo Map
  25. SAP BPC Interview Questions

  26. Question 16. How Do You Connect Sap Hana Views To Ms Excel For Creating Interactive Pivots And Charts?

    Answer :

    Using MDX Provider option

  27. SAP HANA Tutorial

  28. Question 17. Is It Possible To Publish Datasets From Lumira To Hana Platform?

    Answer :

    Yes, you can publish SAP Lumira dataset and stories to HANA platform for sharing with other users.

  29. SAP BODS Interview Questions

  30. Question 18. How Do You Connect Sap Design Studio To Hana Views For Bi Reporting And Dashboard Development?

    Answer :

    Using Universe option – add as data source

    Using direct backend connection to HANA

  31. SAP HR Interview Questions

  32. Question 19. What Are The Other Bi Tools That Can Be Connected To Hana For Reporting?

    Answer :

    Tableau, MS Excel, Cognos and SSRS

  33. SAP BPC Tutorial

  34. Question 20. How Do You Create An Olap Connection To Provide Direct Connectivity To Hana Views?

    Answer :

    OLAP connection can be created in CMC or IDT

  35. SAP BW on HANA Interview Questions

  36. Question 21. Is It Possible To Expose Only A Particular Cube/hana View To Bo Reporting Tool And Not The Entire Repository?

    Answer :

    Yes, while creating an OLAP connection you have an option to select if you want the connection to point to a particular view or to the entire repository.

  37. Question 22. A Crystal Report Developer Uses Sap Crystal Report For Enterprise. To Connect Hana Which Connection Type Is Preferred?

    Answer :

    If Universe is available, you can use Universe Connectivity.

  38. SAP BODS Tutorial

  39. Question 23. What Are The Advantages Of Using Sap Hana Db Over Other Traditional Database For Bi Reporting?

    Answer :

    SAP HANA in-memory concept: SAP HANA in-memory database services provide the capability of processing high-speed transactions and analytics. It helps in managing large database volumes using multitenant database containers and dynamic tiering across multi-tier storage.

    Analytics Processing: Using HANA in-memory processing capability – text, predictive, spatial, graph, streaming, and time series – you can get answers to any business question and make smart decisions in real time.

    App Development : Using SAP HANA, you can develop next-generation applications that combine analytics and transactions, and deploy them on any device.

    Data Access:SAP HANA helps organizations in getting accurate and complete view of business by accessing data from different sources. HANA provides real-time data replication and data quality to improve decision making from internal and external data sources.

    Administration:SAP HANA ensures application availability and tools to monitor the processes along with data and application security.

    Security :SAP HANA provides a dashboard to monitor all KPIs related to security. It helps in keeping communications, data storage, and application services secure with robust identity and access management controls.

  40. Sap Business One Interview Questions