Skip to Content
Author's profile photo Former Member

SAP HANA Information Models for Master Data ( Analytic Views) Series_3

This Blog covers the technical steps  to create Analytic Views ( Highlighted one in the below Model ).

Series 1:

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

Series 2 :

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

SAP HANA Information Model for Master Data

BLOg_11_3.jpg

Analytic view for Purchase Volume Data for Vendor


This analytic view provides line item amount data and valuation differences for accounting documents.

The analytic view provides an aggregated view on purchase volume per vendor, country, business year, company code, and purchase organization.


1.       Select package, Click NEW -Create New Analytical View & give technical name details.

/wp-content/uploads/2013/05/1_213340.jpg

2.       As a result you should see below screen.

/wp-content/uploads/2013/05/2_213341.jpg

3. Drag & drop BSIK table in to Data Foundation.

Navigate to your package, expand the folder and select the attribute views for Vendor , Vendor Company Code & Vendor Purchase ORG drop in to Logical Join.

/wp-content/uploads/2013/05/3_213342.jpg

4. Select Data Foundation, In the details screen, select below listed columns, Right Click > Add to Output.

MANDT

BUKRS

LIFNR

GJAHR

WAERS

ZTERM

DMBTR

/wp-content/uploads/2013/05/4_213347.jpg

5.       Join below Columns from Data foundation to Attribute Views.

/wp-content/uploads/2013/05/5_213348.jpg

5A.jpg

6. Final Steps.

/wp-content/uploads/2013/05/last_213350.jpg

                                                        ————————————————————–

Analytic View for Vendor-Material Relationship


This analytic view is used to select materials that are supplied by vendors.

1. Select package, Click NEW – Create New Analytical View.

/wp-content/uploads/2013/05/1_213340.jpg

2. As a result you should see below screen.

/wp-content/uploads/2013/05/2_213341.jpg

3. Drag & drop EINA table in to Data Foundation.

Navigate to your package, expand the folder and select the attribute views for Material and Vendor and drop in to Logical Join.

/wp-content/uploads/2013/05/3_213342.jpg

4. Select Data Foundation , In the details screen, select below listed columns, Right Click > Add to Output.

MANDT               

LIFNR

MATNR

IDNLF

WGLIF

LTSNR

MFRNR

/wp-content/uploads/2013/05/4_213347.jpg

5. As a result you should see Data Foundation Filled with Columns.

/wp-content/uploads/2013/05/5_213348.jpg

6. Join below Columns from Data foundation to Attribute Views.

/wp-content/uploads/2013/05/6_213360.jpg

6A.jpg

Another Blog on Analytic Views.

http://scn.sap.com/community/developer-center/hana/blog/2013/03/16/copa-e2e-modelling-scenario-in-sap-hana-10-part2

Thanks for you time..

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.