Difference between a view and calculation view

[#1]

Hello,

Essentially we can build a database view instead of a calculation view in HANA.

what is the advantage of using a calculation view in hana?

[uladzislau_pralat]

Hi Tommy,

for purpose of reporting database views are not an alternative to HANA views. There is no visual Modeling Tool for database views creation and it is difficult to re-use them in the same manner as you do with calculation views. Besides of, in contrast with calculation views there are no:

1) database views optimization at the time of execution, for example,  removing unnecessary joins;

2) database views additional metadata generation for MDX clients such as Analysis for Office and Lumira.

Hope it will help.

Regards, Uladzislau