Dear All,
I have my analytical view as below (system landscape: ERP data replicated over HANA DB; modelling using Studio)
EBELN EBELP VGABE BWART BEWTP DMBTR 4500005836 00010 1 101 E 286.32 4500005836 00010 1 101 E 687.18 4500005836 00010 1 101 E 2004.26 4500005836 00010 2I would like to aggregate(sum) the DMBTR(amount) based on VGABE, mean first(measure m1) to add all the DMBTR with VGABE = 1 and then another (m2) for VGABE = 2.
I tried creating a calculated measure using the m1= IF("VGABE"=1,DMBTR,0) but HANA Studio doesnot allow me.
Can any body suggest me how I can proceed further?
Thanks in advance!
Vittali