Working and Modeling Content of Project

Question 1

Dependencies in Information Models

Answer 1

1. Other Action->Data lineage

2. Other Action->Impact Analysis.

Question 2

Show lineage

Answer 2

will not work on Shared Objects from Dim view in the STAR Cal View

Question 3

Outline view

Answer 3

Jump to relavant col

Question 4

Workspace-> Project-.> Module

Answer 4

Workspace can contain as many project as required with different name.

Question 5

Project Creation will ask for Project template

Answer 5

MTA- Multi Target Application

Another project Template is SAP HANA Database Application Template.

Question 6

Types of Modules which can be created.

Answer 6

SAP HANA Database (HDB) Module,
JAVA module
Node. JS module

Question 7

HDB Module contains Design time files

Answer 7

1. Tables.
2. Tabes Data
3. CV
4. CDS views.
5. Table functions
6. Procedures.
7. Analytical privileges
8. Synonyms.

Question 8

Persistence layer : Inside or External

Answer 8

1. Standalone Application(Tables and data stored inside application as CDS)
2. Pure Data Analytics application where data can be stored outside.

Question 9

Namespace of Design time and Run Time objects

Answer 9

1. Namespace are optional.
2. Namespace for all design time object in same folder should be optional.
3. Definition can be added at . HDINamespace.

Question 10

CV, TF, PROC, AP

Answer 10

1. Each Design time object defines only 1 Runtime Object.

2. Runtime Object name is defined inside the object content and should match design time file name.

Question 11

Synon, CDS tables,CDS views, Roles.

Answer 11

One or Several runtime objects.

Question 12

HDI container

If you delete a run time object via SQL , after you build it , you can again see the Runtime object

Answer 12

True

Question 13

HDI container

If you create a run time object via SQL , after you deploy the container , you will not see this Table.

Answer 13

True.

Question 14

Datasources for Calculation view

Answer 14

1. It should be available inside HDI and corresponding Design time file available.
2. Synonyms ref DB objects located in other schema.

Question 15

If CV is ref by using the Database table created in Plain SQL in your container ,

Answer 15

Build of the CV will fail.

Question 16

Key properties of HDI container.

Answer 16

1. Container = Schema.
2. DB objects are deployed into the Schema.
3. Schema free.
4. Direct ref not allowed , Synonyms must be used.

Question 17

HDI container Configuration file

Answer 17

1. .HDICONFIG - Binds design time objects with corresponding Build plugin.
2. Without plugin , it is not possible to build the design time files.
3. By default hidden.
4. .HDICONFIG is always unnamed file, if you try to add any name, build will fail.

Question 18

Database explorer

Answer 18

Technical user is SBSS.

Service Support Security Support.

Question 19

Building Modelling Content

Answer 19

1. Building modelling content means
   a)Creating Runtime Objects from Design time
   objects. HDB Module build
   b) Project build and create the MTAR file.
   b) Deploy them to the container( Schema) or to
   target systems.

Question 20

Build errors.

Answer 20

1. Dependency checks is done end to end for whatever you are building.
2. Project exported but not assigned to SPACE.Space in which you deploy the container service must be specified and Develeloper access on the user id in that space.
3. Definition of Object on which this object is dependent is not yet provided or it is not yet build.
4. Name Space inconsistency between Content of design time file and the name space property.
5. Service to external schemas not defined and running in target space.
6. Synonyms of external schemas are not build.
7. Object specific error( e.g no measure in the cube).
8. Object you build and ref object. ( col name between objects with dependency).

Question 21

Rename the column

Answer 21

First we need to refactor the consuming view , then only build of the source View will be successful.

Question 22

Synonynm

Answer 22

.hdbsynonymn and .hdbsynonymconfig

Question 23

XSADVANCED Migration tool

Answer 23

All the steps are now taken care by the tool related to migration and once MTA file is generated , we need to deploy it.