DSO Keys with numerous amounts

[Former Member]

Hi All

I have a DSO with 5 Keys.

ID

partner ID

Day

Cost Type

Cost Code

On two of my rows i have the exact same keys but different amounts.

ID--

---

Partner ID

---

Day

---

Cost Type

---

Cost Code--

---

Amount

1--

---

B

---

01.01.2009

---

B

---

200150--

---

75000

1--

---

B

---

01.01.2009

---

B

---

200150--

---

25000

When loading from PSA to DSO it takes the last row amount (25000) and doesn't add them together even though it is set to SUM in the key figure.

How do i get it to summarise (give me 100000) the duplicate key amounts?

I do not think this will happen in reality but if i can solve this it would be good anyway.

Regards

[Former Member · Accepted solution]

HI,

If you load these 2 records in 2 different loads, then it will show 2 separate records in DSO / Cube. Because you set key Figure property as SUM. Even thou it is "Over write" mode, we can see 2 separate records in change log table. When we do the report, it will show by adding these 2 records (as 100000).

Regards

Rajesh