Interview Questions.

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

Analytic View

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

Using MDX Provider choice

Q3. What Are The Different Input Parameters Types In Sap Hana?

Direct: Using this parameter type, you could bypass any cost for the parameter.

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

Derived From Table: It is likewise possible to create dynamic values in a table. This permits you to select any of the available values from the listing.

Static List:It is likewise feasible to create a static list of values and provide consumer enter all through execution.

Q4. What Is The Use Of Relational Connection And An Olap Connection?

Relational Connection: A Relational connection is used to connect to the Database layer in HANA. You can connect with database objects - tables, views, and layout Data Foundation layer inside the Information Design tool. You also can import tables and joins from the facts supply.

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

Q5. How Do You Create An Olap Connection To Provide Direct Connectivity To Hana Views?

OLAP connection can be created in CMC or IDT

Q6. What Is The Use Of Sap Bi Launchpad?

BI Launchpad has the following essential alternatives :

Home : Displays the latest messages, indicators, documents, and packages that may be run.

Documents : Displays the available files and folders, making it easier to view, prepare, and manipulate the documents.

Any Open Document : Displays each open record.

Q7. What Are The Different Geographic Chart Types Available Under Sap Lumira?

Geo Bubble Chart

Geo Choropleth Chart

Geo Pie Chart

Geo Map

Q8. Is It Possible To Publish Datasets From Lumira To Hana Platform?

Yes, you may publish SAP Lumira dataset and tales to HANA platform for sharing with different users.

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

Tableau, MS Excel, Cognos and SSRS

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

Using Universe on pinnacle of HANA Modeling perspectives

Direct Webi connection with HANA Modeling perspectives

SAP HANA Online connectivity

Using Free-Hand SQL

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

Yes, even as developing an OLAP connection you have got an choice to pick out in case you need the connection to factor to a specific view or to the whole repository.

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

Using Universe choice - upload as facts source

Using direct backend connection to HANA

Q13. Which Bo Tools Can Connect To Hana System Using A Universe?

All BusinessObjects tool - Webi, Dashboard Designer, Lumira, Crystal Reports, Design Studio that provide Universe connectivity as statistics supply can be used to connect to HANA gadget.

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

Following are the homes of SAP HANA Analytic View:

Analytic Views are used to carry out complicated calculations and Aggregate features which includes Sum, Count, Min, Max, and so forth.

Analytic Views are designed to run Start schema queries.

Each Analytic View has one Fact desk surrounded by means of multiple measurement tables. Fact desk contains a number one key for every Dim desk and measures.

Analytic Views are just like Info Objects and Info sets of SAP BW.

SAP BusinessObjects reporting gear can connect with Analytic view using an OLAP connection for reporting and dashboard.

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

Using GUI alternative

Using SQL Script

Q16. How Do You Connect Dashboard Designer To Hana Database For Dashboard Creation?

You can hook up with SAP HANA the usage of Universe connectivity from the Dashboard. SAP Dashboard helps SAP HANA sponsored with Universe created on pinnacle of HANA views and tables. You can eat Universe Designer .Unx files the usage of the Query Browser choice to develop the dashboard.

Q17. What Is The Difference Between .Cns And .Cnx Connection?

.Cns − Secured Repository connection

.Cnx-neighborhood unsecured − If you use this connection, it's going to not permit you to post whatever to the repository.

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

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

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

BusinessObjects four.2

Q20. What Are The Different Types Of Hana Information Views?

SAP HANA provides the subsequent 3 kinds of Information Views :

Attribute View

Analytic View

Calculation View

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

SAP HANA in-reminiscence concept: SAP HANA in-memory database offerings provide the functionality of processing excessive-velocity transactions and analytics. It facilitates in handling large database volumes the usage of multitenant database boxes and dynamic tiering throughout multi-tier storage.

Analytics Processing: Using HANA in-reminiscence processing functionality - text, predictive, spatial, graph, streaming, and time collection - you may get answers to any commercial enterprise query and make smart choices in actual time.

App Development : Using SAP HANA, you could broaden subsequent-generation applications that combine analytics and transactions, and install them on any tool.

Data Access:SAP HANA enables companies in getting correct and entire view of commercial enterprise by using having access to information from distinctive resources. HANA offers actual-time information replication and facts nice to enhance decision making from inner and outside information sources.

Administration:SAP HANA guarantees software availability and tools to reveal the techniques at the side of information and alertness protection.

Security :SAP HANA presents a dashboard to screen all KPIs associated with security. It allows in maintaining communications, records garage, and application services secure with strong identity and get admission to management controls.

Q22. What Are The Different Data Sources Option Available Under Crystal Reports?

Crystal Reports can connect to more than one facts assets that include:

Universe

SAP BEx Query

HANA view

Excel Spreadsheets

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

If Universe is available, you can use Universe Connectivity.