Please go through information @ https://wiki.scn.sap.com/wiki/display/BI/Introduction+to+Operational+Data+Provisioning
Hi Rahul,
it depends what you are looking for.One way is to replicate the table directly into your HANA Schema.Using this Approach gives you the ability of adding e.g. HANA calculation views atop of such replicated tables for real time reporting.Thus replication will not Trigger any Dellta on BW side of view.
Second way is to use the ODP replication.
Using that way will use the PSA for Deltas coming from e.g. changes in ERP tables.
This way can be used for regular BW WHM and staging but you might have any load delays between table changes and visibility in reporting.
LAst and uncommon way is to use table replication between ERP and BW and create an ODP based on replicated tables on BW side.
Using this (my favourite) Approach will give you the flexibility to have the realtime ability via calculation views (used e.g. in HCPR Provider) and the regular "old School" BW load Scenario.
Hope that helps to demistify the different ways of SLT
Best regards
Joerg Boeke
Add comment