Database view or calculation views

[Former Member]

Hi,

I was reading the blog :

I see that now the analytical, attribute and script based calculation views are deprecated going forward.

So was wondering what is best stratergy going forward?

Should we go back to building script based database views or graphical calculation views?

What could be the advantage/disadvantage of building db views compared to calculation views?

Any inputs/experience highly appreciated

--Aravind.

[lbreddemann]

Should we go back to building script based database views or graphical calculation views?

SAP has provided clear documentation on that. You can find it in the SAP HANA Developer Guide for SAP HANA Studio - SAP Library

I recommend reading it.

What could be the advantage/disadvantage of building db views compared to calculation views

What exactly are you referring to here? Nowhere does SAP recommend to use "db views" instead of calculation views.

The clear development direction is to use CDS views as well as calculation views. For cases where imperative coding is required user defined functions should be used.

Attribute and Analytic views are supported for backward compatibility, but new scenarios should be build without them,

The main advantage is a simpler development: instead of 3 view types with different editors, capabilities and rules there's now only one view type.

As mentioned above, the SAP HANA documentation covers this quite well.

[anindya_bose]

Attribute View ---------------> Calculation view type Dimension

Analytic View ---------------> Calculation View type Cube 

Script Based Calculation View --------> Table function

Graphical Calculation view remain as it is .

PS:

I still create Script Based Calculation view and migrate them automatically to Table Function.  I just feel more comfortable doing that instead of creating table function from scratch .

Regards

Anindya