Skip to Content
0

capturing only Delta records in views in SAP HANA

Apr 11 at 11:07 AM

37

avatar image

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

10 |10000 characters needed characters left characters exceeded

Hi,

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

0

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

0

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

flowgraph.jpg (61.6 kB)
flowgraph-2.jpg (60.7 kB)
0
* Please Login or Register to Answer, Follow or Comment.

0 Answers