How to Enable semantic grouping in DTP, when we use AMDP

[Pradeep_Emmidi]

Dear Experts,

Please suggest, How to enable Semantiv groping in DTP when we use AMDP (HANA SCRIPT EXPERT ROUTINE) in BW 7.4

[matt]

What did you try, and what happened?

[Pradeep_Emmidi]

Hello,

I have 70+ million records in the source with below format ( SOURCE KEYS: ITEM, STORE, WEEK, DEMAND ID),
Target Keys (ITEM, STORE, WEEK)

Indeed i'm using group by function in AMDP, While loading the data from source to the target,

Group by has not happend due to combination of data is coming in different packages.

Thanks,

Pradeep

[martin_chambers · Accepted solution]

It seems to work in HANA transformation in BW/4 HANA. There it is called "extraction grouped by...". Perhaps it works in BW powered by HANA if the SP is high enough?

[former_member302041]

As I remember semantic grouping is not supporter with AMDP/HANA execution.