SAP HANA Information Models for Finance ( Basic Level)
This blog explains deep dive of Attribute Views (Basic Level) for Finance.
Attribute Views are used to model an entity based on the relationships between attribute data contained in multiple source tables.
Process Flow for Creating Attribute View Creation
This Attribute View provides global company data.
Below SAP tables are used to create this Attribute View.
Attribute view for Global Company Information
1. Select the Content Package > Right Click > New Attribute View.
2. As a result you should see following screen.
3. Drag & drop T880 & T880G table in to Data Foundation.
4. In the details screen, select MATNR & Right Click > Add to Output.
Continue for below columns
MANDT,RCOMP,NAME1,CNTRY,MODCP ( T880 Table).
5. In the details screen, select CGSBR & Right Click > Add to Output.
Continue for CCOMP Column also.
6. Connect MANDT(T880) to MANDT (T880G), In the properties select join type as Inner Join , & Cardinality as 1:N.
7. Select Semantics , Click MADNT to enable as a Key Attribute.
11. As result you will see below screen.
12. Click Raw Data to see the output of the view in the column format.
13. Click Distinct Values to see the distinct values.
14. Click Analysis to see the output of the view in the graphical representation.
—————————————————
Attribute view for Chart_Of_Accounts
This Attribute View provides chart-of-accounts information.
Below SAP tables are used to create this attribute.
15. Select your package, Give name details.
16. Drag & drop T001,SKAT & SKA1 tables in to Data Foundation.
17. In the details screen, select MATNR & Right Click > Add to Output.
Continue for below fields for T001 Table
MANDT,BUKRA,BUTXT,ORT01
18. In the details screen, select KTOPL & Right Click > Add to Output.
Continue for SAKNR field from SKA1 Table.
19.Connect MATNR(T001) to MATNR (SKA1), In the properties select join type as Inner Join & Cardinality as N:1.
20. Connect KTOPL(T001) to KTOPL (SKA1), In the properties select join type as Inner Join & Cardinality as N:1.
21. Connect MANDT(SKA1) to MANDT (SKAT), In the properties select join type as Text Join , Language column as SPARS & Cardinality as 1:1.
22.Connect KTOPL(SKA1) to KTOPL (SKAT), In the properties select join type as Text Join & Cardinality as 1:1.
23.Connect SAKNR(SKA1) to SAKNR (SKAT), In the properties select join type as Text Join & Cardinality as 1:1.
24.Click Save & Validate after that Click Save & Activate.
25. Click Data Preview to see the output of the view.
26.As Result will appear below screen.
27.Raw Data to see the output of the view in the column format.
Advance level Blog :
http://scn.sap.com/community/hana-in-memory/blog/2013/04/19/sap-hana-information-models-for-fianance
Analytic View
SAP HANA Information Models for Finance ( Analytic View)_1
SAP HANA Information Models for Finance ( Analytic View)_2
Hello Mahesh Kumar:
Excellent information for Finance folk to have a basic understanding, good information. Thanks for sharing !
-Nishan Dev
Good flow with great steps! thanks!
Thanks Mahesh .
Looking forward to have more from you in various modeling scenario's.
Thanks for sharing Mahesh .
Thanks Mahesh for sharing Finance master with Attribute View flow.
Warm Regards
Hemendra
Thanks Bro
Thanks Mahesh for sharing this.
I have a small confusion - in recent blog on SPS11 sap is recommending to move to calculation views and use projections to max extent instead of Attr and Analytic view if possible. By this the performance will be good and its where sap is thinking and moving to even in future releases. I had just now saw another blog mentioning the same.
Please share your suggestions on this.
SAP HANA Modeling - Project Learnings and Tips