Skip to Content
0
Former Member
Jan 26, 2015 at 08:39 AM

Creating Analytic/Calculation view best practice

147 Views

Hi Team,

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.

Best regards

venu