Skip to Content
0
Former Member
Oct 05, 2012 at 11:41 PM

Aggregation based on field value : Analytical view or Calculation view

250 Views

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 2
Q 291.44 4500005836 00010 2
Q 707.84 4500005836 00010 2
R 1964.18

I 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