Analytical, Attribute and Calculation Views

[#1]

Hello,

I have completed the tutorial on HANA development on OpenSAP, which is certainly the best way to learn specially for starters. But, even though I completed the course I was not able to exactly understand the concept of analytical, attribute and Calcualtion views.

I would like to know:

1) Why do we have these three different kinds of views, even though we could possibly have only one type of view from the above?

2) What is the significance or better said, what is the type of data we have in these three different views?

3) If we take retail industry as an example : what kind of data you would throw in these three different views and why?

I would be glad if anyone could answer this in simple words for my better understanding and hopefully would also help someone.

Thanks

Mesh

[Former Member · Accepted solution]

Request you to search the forum before posting as this has been discussed in numerous blogs in SCN.

here is a standard difinition of the HANA information views

     1) Attribute Views : In the language of SAP Netweaver Business Warehouse , attribute views are like Dimension, but with difference is that attribute views are fully reusable throughout the system and not stuck up to a single model. Simplifying, these are views on one or more table that can be reused for different purpose.

Example : An attribute view "FLIGHT" can  show together Airline Code, Airline Connection Number and flight Date into one Object. This attribute view can be used in analytical and calculation views where entities are relevant. Generally attribute views represent master data.But, however technically there is no restriction and its possible to make attribute views on transaction data.

    2) Analytical Views :  Again, in the language on SAP BW analytical views can be roughly compared with Info Cubes or Info Sets in SAP ERP. As same it joins together one central fact table with contains transaction data  to report on, with number of tables or attribute views. You can create variables in an analytical view.

     3) Calculation views : Calculation views can be referred as combination of tables, attributes views and analytical views to deliver a complex business requirement. They offer to combine different analytical views into one source of data for reporting.

Check the link for more details

http://www.saphana.com/docs/DOC-3896

[Former Member · Accepted solution]

I did find only the definitions which all meant the same. I wanted a sample example and I have it in the link you provided me.

Thank you so much.

[Former Member · Accepted solution]

Hi Durgamadhab Mishra

Good Morning.

I have tried to access the below link posted by you but not have authorisation. Is there any specific community I should be a member of to access the link?

Check the link for more details

http://www.saphana.com/docs/DOC-3896

Regards

Murthy Gunuputi

[Former Member]

Some more example links,,,,

COPA Scenario

http://scn.sap.com/community/developer-center/hana/blog/2013/03/06/copa-scenario-in-sap-hana-10-sps-...

http://scn.sap.com/docs/DOC-41293

http://scn.sap.com/community/hana-in-memory/blog/2013/05/06/sap-hana-information-models-for-master-d...

Finance

http://scn.sap.com/community/hana-in-memory/blog/2013/05/01/sap-hana-information-models-for-finance-...

Hope this will help..

Regards,

Mahesh