capturing only Delta records in views in SAP HANA

[ashutosh_shrivastava4]

Hi,

Can anyone explain how to capture only delta records in graphical views of HANA.

I know we can handle delta in BODS with Table comparison (OR) key generation.

Thanks,

Ashutosh

[Former Member]

Hi,

can you provide some more details like data provisioning tech you using ? ECC tables are the source ?

[ashutosh_shrivastava4]

Hi Rajiv,

Source is ECC and we have used SLT data provisioning. We need to have only delta records for calculation view for one specific report.

Thanks,

Ashutosh

[former_member213277]

Hi Ashutosh,

One option I can think of is using flowgraph. This has functions same as BODS for table comparison and history preserve

Use replicated table(replicated using SLT) as source table and create a one more table in HANA and use as target table. Target table has change history of the records. Build Calculation view on top of target table

You can create flow graph from Developer perspective

Regards,

Nag