Confusion among analytical,attribute and calculation view with composite view.

[guru_ayarekar]

Hello everyone,

By reading blog posts I know that there are following CDS views -basic,composite and consumption views.

Then what are analytical,attribute and calculation views?

Where these views fits with compare to basic and composite views ?

I have lot of confusion in my mind regarding this.

Please explain if possible with example.

[maheshpalavalli · Accepted solution]

gurudevendranath Attribute Views & Calculation views are part of HANA graphical modeling and believe they are not superseded by abap cds views, alteast from the abap perspective.

https://answers.sap.com/questions/11606131/what-is-attribute-view-analytic-view-and-calculate.html

Analaytical view is part of abap cds views, you can check m.kreitlein answer. Basic & Composite views are just normal cds views but to differentiate them at different levels, we define them with annotations. check below:

https://blogs.sap.com/2017/10/09/abap-core-data-services-part-2virtual-data-model-types/

so basically attribute views & calculation views are graphical hana based whereas analytical cds views, basic, composite are normal abap cds views which are differentiated based on the annotations.

[MKreitlein]

Hello Guru,

I would recommend these wiki pages:

https://wiki.scn.sap.com/wiki/display/BI/CDS+views%3A+HowTo+use+in+BW+contexts

It's lots of information, but it will answer any of your "analytical" question 🙂

BR, Martin

[guru_ayarekar]

Hi Martin,Thanks for reply. By going through the link given by you I learn BW context of CDS analytical views.

[Sandra_Rossi]

TL;DR If I understand well the wiki, you are saying that an analytical view means that the CDS view contains @Analytics (and maybe @AnalyticDetails) annotations, which are used by the Analytic Engine/Manager, which are used for OLAP (OnLine Analytical Processing) like BW. So, it's all about multidimensional data/star schema. Thanks. That clarifies.