Sap Hana - All About Views

By Alka Jain

SAP HANA Modeling is one of the key capabilities of HANA system. This allows to create multidimensional objects on top of HANA database objects to meet the business requirements for reporting. You can implement complex business logic using HANA information models to create a meaningful report for analysis.

Features of HANA Modeling

SAP HANA Modeling is one of the key concepts in HANA BI reporting.

Using HANA Modeling, you can create complex data models as per business requirement to provide multiple views of transactional data stored in physical tables of HANA database.

SAP HANA Modeling can only be done for column-based storage tables.

HANA Modeling views can be used directly by SAP BusinessObjects reporting tools such as Crystal Reports or Lumira using an OALP or HTTP connection.

HANA supports different types of Modeling views such as - Attribute view is used to model characteristics, Analytic view is used to implement Star schema and Calculation view is used to implement complex logics, which are not possible with other type of views (Galaxy schema).

SAP HANA Modeling views can also be directly connected to third party tools such as MS Excel using HANA MDX Provider.

SAP HANA Modeling supports various features of Business Layer - Creating new calculated columns, new measures, input parameters, hierarchies, etc.

SAP HANA provides following three types of Information Views −

Attribute View

Analytic View

Calculation View

• Language: English
• Publisher: Alka Jain
• Release date: Jun 14, 2023
• ISBN: 9798223142393

Book preview

ABAP CDS on HANA-1

Basic CDS View Creation

Open HANA Studio. Goto ABAP perspective. Open the project, Navigate to the package. Right click on the package & select New->Other ABAP Repository Object.

1

Expand Code Data Services & select DDL Source and finally select NEXT button.

2

Provide CDS view name & description. Select FINISH button.

3

The view editor opens up. Here we have to provide the details.

4

---

Provide SQL VIEW NAME, provide a meaningful end user text label, provide view type as BASIC.  

On the define view statement, provide the select form as SFLIGHT, mention the field names marking key fields. Activate and execute the view.

5

@AbapCatalog.sqlViewName: ‘ZSFLIGHTVIEW’

@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: ‘Flight Information’

@VDM.viewType: #BASIC

define view Zflight_View as select from sflight{

key sflight.carrid as AirlineCode,

key sflight.connid as ConnectionNumber,

key sflight.fldate as FlightDate,

sflight.price as Airfare,

sflight.currency as FareCurrency,

sflight.planetype as PlaneCategory,

sflight.seatsmax as MaxAvailableSeats,

sflight.seatsocc as OccupiedSeats 

}

Here is the CDS view output.

6

Once the DATA Definition is activated,

Reviews for Sap Hana - All About Views

[ada ezia · Rating: 5 out of 5 stars]

Very good book I understand everything very well love it

[Nasirudeen Shakirullah · Rating: 4 out of 5 stars]

So intellectual and entertain to be here and read this amazing book

[Rahul Khan · Rating: 5 out of 5 stars]

Good book is a good time ghujn ikhvv good night

[Nimali Gamage · Rating: 5 out of 5 stars]

Good book is a good time ghujn ikhvv good night

[Md Nasim · Rating: 5 out of 5 stars]

Good book is a good time ghujn ikhvv good night

[MASTER FUNNY LTD · Rating: 5 out of 5 stars]

Amijing your book websaid i am oiting from new book

[Muhammad Hasan Mobarak · Rating: 5 out of 5 stars]

Wow, I took two very good books 123 56
8965

[Technical Gaming · Rating: 5 out of 5 stars]

Very very good i like you this bookso nice book is good

[Md Nurislam · Rating: 5 out of 5 stars]

A nice book and i will flow it’s, this good

[Jiban Debnath · Rating: 5 out of 5 stars]

Very very good i like you this bookso nice book is good

[Ponnaya Ponnaya · Rating: 5 out of 5 stars]

Werey good book topic for the next few weeks and

[FOYSAL AHMED · Rating: 5 out of 5 stars]

Very nice and exciting .I love that site. everyone that loves that

[Nayan Chowdhury · Rating: 5 out of 5 stars]

Nice app??? onak onak Valo akta app

















Kskk

Jzjxb

Kzjxjj


.....




Valo

[MD.Rashed Miah · Rating: 5 out of 5 stars]

this site is best all is ok best best nice

[Dipta podder · Rating: 5 out of 5 stars]

This is not book it knowledge and experience practice book ?

[mazz toon · Rating: 5 out of 5 stars]

This book was gave me an excellent feeling. I love this too

[Shrabon · Rating: 5 out of 5 stars]

Very very good i like you this books nice book is good

[adr · Rating: 5 out of 5 stars]

good book sir and nice job
Excellent ...I liked It