Skip to Content

capturing only Delta records in views in SAP HANA

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

Add comment
10|10000 characters needed characters exceeded

  • Hi,

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

  • 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

  • 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)
  • Get RSS Feed

0 Answers