Interview Questions.

Question 1. What Is Sap Hana Xs Engine?

Answer :

XS Engine is a JavaScript application server based at the Mozilla Spider Monkey engine. The essential concept of SAP HANA XS is to embed a full featured software server, net server, and development surroundings inside the SAP HANA appliance itself.

Important points about SAP HANA XS:

XS is a Small footprint software server / web server.
It is the basis for an application development platform internal SAP HANA.
It simplifies structure and lowers the TCO (total fee of operation).
It offers easy get right of entry to to SAP HANA database thru HTTP-based totally consumption.
Question 2. What Is The Purpose Of Xsaccess File In Hana Xs Project?

Answer :

The application-access (.Xsaccess) document permits you to specify who or what's authorized to access the content exposed with the aid of the application bundle and what content they may be allowed to peer.

The application-get admission to record does now not have a name before the dot (.); it handiest has the record extension .Xsaccess. The contents of the .Xsaccess report should be formatted consistent with JavaScript Object Notation (JSON) regulations.

Example of .Xsaccess record:

"uncovered" : real,

"authentication" :  "technique" : "Form"

SAP BI Interview Questions
Question three. How Can We Create A Job And Schedule It In Hana?

Answer :

With the help of XSJs document, we are able to run a service (for example, an XS JavaScript or a SQLScript) at a scheduled c program languageperiod.

We first need to outline the service both in XSJS or in SQLScript technique. Then we will create XSJob report and mention the provider information along with time c language. Finally from HANA Admin device we can activate the process.

Question 4. How Can We Create An Xsodata Service Which Only Allows To Read Data But Prevents Any Insert/replace/delete Operation?

Answer :

This may be accomplished with the “forbidden” command. For example:

carrier 

"mySchema"."myTable" as "MyTable"

create forbidden

update forbidden

delete forbidden;

SAP BI Tutorial
Question 5. What Is Benefit Of Xodata Compared To Xsjs?

Answer :

In HANA XSOData, there is a OData framework which provide many functionalities and we simplest want to provide information like facts source, affiliation etc. This could be very useful for builders as coding attempt is sort of 0. OData framework also looks after protection aspects like SQL injection, XSRF etc.

While in XSJS, we want to code the whole thing our personal. This consequences into greater coding effort. We also want to attend to security aspects, performance and so forth.

SAP BO Interview Questions
Question 6. Is It Possible To Call An External Service From Internet In Xs Application? If Yes, Then How?

Answer :

Yes, we will call an outside service from Internet. This can be accomplished with HTTP Destination (xshttpdest).

We first want to create an HTTP Destination file and offer the info of outside carrier along side other safety and proxy information. Then we will call this vacation spot from XSJS using $.Internet.Http.ReadDestination API.

Question 7. What Are The Different Web-based totally Tools Available In Hana Xs? How Do We Access Them?

Answer :

There are mainly four XS Web-based totally gear:

Editor: Inspect, create, exchange, delete and activate SAP HANA repository gadgets.
Catalog: Create, edit, execute and manipulate SQL catalog artifacts within the SAP HANA database.
Security: Manage customers and roles.
Trace: View and download SAP HANA hint documents and set hint degrees (as an example, information, blunders, debug).
The URL to get admission to these gear is: http://<WebServerHost>:eighty<SAPHANAinstance>/sap/hana/xs/ide.

SAP BO Tutorial SAP BW Interview Questions
Question 8. What Is Hana Cds? What Are The Artifacts We Can Create Using Cds?

Answer :

Core Data Services (CDS) artifacts are design-time definitions. When CDS report is activated, it generate runtime objects.

CDS may be used to create following database artifacts:

Create a desk (entity)
Create an SQL views
Create an association among entities or views
Create a consumer-defined dependent kind
Question nine. What Is The File Extension Of Xsjs Library?

Answer :

File extension of XSJS library is .Xsjslib

SAP HANA Interview Questions
Question 10. Can We Call An Http Destination From An Xsjs If Http Destination Is In A Different Package?

Answer :

No. We ought to maintain the HTTP vacation spot configuration inside the equal package deal as the utility that makes use of it. An utility cannot reference an HTTP destination configuration that is located in some other utility package deal.

SAP BW Tutorial
Question eleven. Can We Call An Xsjslib From Another Xs Project?

Answer :

Yes. XSJS library (xsjslib) may be referred to as from every other XS task or another bundle.

SAP BODS Interview Questions
Question 12. Suppose We Want To Create An Xs Application And Want To Make It Public. User Should Not Need Any Hana Database User To Access This Application. Is It Possible? If Yes, How?

Answer :

In .Xsaccess record, we are able to set the authentication to null. After this everyone can open the utility with out user id and password.

SAP BI Interview Questions