Aggregate SUM in DSO object

[Former Member]

Hi all.

I have a flat file data source with detailed records:

Field1 Field2 Amount

-

---

1 22 100

1 23 200

2 24 220

3 25 150

3 26 600

I want to get aggregated results by Field1 in my DSO:

Field1 Amount

-

---

1 300

2 220

3 750

How and there I can do these aggregates during the data load process into DSO?

[Former Member · Accepted solution]

hi

go to the transformation and go to the field amount and choose the Aggregation as summation.now the values wld be gettint added automatically.

Regards

Dina

[flavian_lobo]

what is the difference between Aggregation in DSO and Addition in info cube?i have shallow knowledge in BW. Please,explain