Interview Questions.

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

Answer :

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

Answer :

BI Launchpad has the subsequent vital options :

Home : Displays the latest messages, signals, files, and programs that may be run.

Documents : Displays the available files and folders, making it simpler to view, arrange, and control the documents.

Any Open Document : Displays every open report.

SAP BI Interview Questions
Question three. 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 with database objects - tables, views, and design Data Foundation layer within the Information Design device. You also can import tables and joins from the statistics source.

OLAP Connection: OLAP is a multidimensional connection that directly factors to the enterprise layer in a information version. It lets in to connect with multidimensional schema immediately and later, they can be used with SAP Business Objects reporting gear.

Question four. What Is The Difference Between .Cns And .Cnx Connection?

Answer :

.Cns − Secured Repository connection

.Cnx-local unsecured − If you use this connection, it's going to no longer allow you to submit something to the repository.

SAP BI Tutorial
Question 5. What Are The Different Types Of Hana Information Views?

Answer :

SAP HANA presents the subsequent 3 kinds of Information Views :

Attribute View
Analytic View
Calculation View
SAP HR Interview Questions
Question 6. What Are The Different Input Parameters Types In Sap Hana?

Answer :

Direct: Using this parameter kind, you may skip any fee for the parameter.

Column: This parameter kind lets in you to pick any price from the list of distinct values available in a column in HANA view.

Derived From Table: It is also viable to create dynamic values in a desk. This permits you to pick any of the available values from the list.

Static List:It is likewise feasible to create a static listing of values and offer user enter during execution.

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

Answer :

Following are the homes of SAP HANA Analytic View:

Analytic Views are used to carry out complex calculations and Aggregate capabilities which includes Sum, Count, Min, Max, and many others.
Analytic Views are designed to run Start schema queries.
Each Analytic View has one Fact desk surrounded with the aid of multiple size tables. Fact table consists of a number one key for every Dim table and measures.
Analytic Views are much like Info Objects and Info units of SAP BW.
SAP BusinessObjects reporting equipment can connect with Analytic view the usage of an OLAP connection for reporting and dashboard.
SAP HR Tutorial SAP BO Interview Questions
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 statistics source may be used to hook up with HANA system.

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

Answer :

BusinessObjects 4.2

SAP BW Interview Questions
Question 10. In Businessobjects four.2, What Are The Different Ways To Connect Webi To Hana Views?

Answer :

Using Universe on pinnacle of HANA Modeling views
Direct Webi reference to HANA Modeling perspectives
SAP HANA Online connectivity
Using Free-Hand SQL
SAP BO Tutorial
Question 11. How Do You Connect Dashboard Designer To Hana Database For Dashboard Creation?

Answer :

You can hook up with SAP HANA the use of Universe connectivity from the Dashboard. SAP Dashboard supports SAP HANA subsidized with Universe created on pinnacle of HANA perspectives and tables. You can devour Universe Designer .Unx documents the usage of the Query Browser choice to broaden the dashboard.

SAP HANA Interview Questions
Question 12. What Are The Different Data Sources Option Available Under Crystal Reports?

Answer :

Crystal Reports can connect with multiple facts sources that consist of:

Universe
SAP BEx Query
HANA view
Excel Spreadsheets
SAP BI Interview Questions
Question thirteen. While Using Sap Hana Bi Development, Which Hana View Can Be Used To Implement Star Queries?

Answer :

Analytic View

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

Answer :

Using GUI option
Using SQL Script
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
SAP BPC Interview Questions
Question 16. How Do You Connect Sap Hana Views To Ms Excel For Creating Interactive Pivots And Charts?

Answer :

Using MDX Provider option

SAP HANA Tutorial
Question 17. Is It Possible To Publish Datasets From Lumira To Hana Platform?

Answer :

Yes, you can post SAP Lumira dataset and stories to HANA platform for sharing with different customers.

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

Answer :

Using Universe option - upload as facts source

Using direct backend connection to HANA

SAP HR Interview Questions
Question 19. What Are The Other Bi Tools That Can Be Connected To Hana For Reporting?

Answer :

Tableau, MS Excel, Cognos and SSRS

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

Answer :

OLAP connection may be created in CMC or IDT

SAP BW on HANA Interview Questions
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've got an option to pick out if you need the connection to factor to a selected view or to the complete repository.

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 may use Universe Connectivity.

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

Answer :

SAP HANA in-reminiscence concept: SAP HANA in-reminiscence database services provide the capability of processing high-pace transactions and analytics. It allows in coping with large database volumes the use of multitenant database boxes and dynamic tiering across multi-tier storage.

Analytics Processing: Using HANA in-reminiscence processing capability - textual content, predictive, spatial, graph, streaming, and time collection - you could get solutions to any enterprise question and make clever choices in real time.

App Development : Using SAP HANA, you may increase next-generation packages that combine analytics and transactions, and installation them on any tool.

Data Access:SAP HANA helps businesses in getting correct and complete view of enterprise via having access to facts from different assets. HANA offers actual-time information replication and data excellent to enhance selection making from inner and external statistics assets.

Administration:SAP HANA guarantees utility availability and gear to screen the strategies together with information and application protection.

Security :SAP HANA gives a dashboard to display all KPIs related to protection. It enables in preserving communications, statistics garage, and alertness services comfortable with robust identity and get entry to management controls.

Sap Business One Interview Questions