We are in a process to extract data from ECC to HANA and create views and push data to BW targets using ODP.
Basically we are extracting data from PS tables for example.
PROJ,PRPS,SKA1,T001,CEPC,CEPCT are master data tables.
COEP,COSP,COSS are the transaction data tables.
We would like to create attribute views for all the master data tables and for transaction data tables we would like to create calculation views rather than analytic views and push data to BW Targets using Operational data provisioning.
To extract from ECC - SLT
To push to BW Targets from HANA Views - ODP
Which is the best practice, is it calculation view or analytic view?
Please explain in detail, so that it would be great for our modeling.
Please explain pros/cons for both the views.