Overwrite records with Match key Question

[former_member481715]

Hello,

I have a question about data loads using this option when loading from infocube - I understand it will overwrite only if all the dimension values match. However what happens if there are two rows in the same cubee with same dimension values. Will it agreegate those two rows and upload that amount? e.g.

Infocube example(Referencefield column wont be loaded to BPC)

ACCOUNT     CATEGORY   TIME    ENTITY      REFERENCEFIELD    Amount

1000                  actual        2013.jan    200N                 1Z                  1200

1000                  actual         2013.jan    200N                 9A                     300

will it upload 1500 or 300?

Tanks

[Former Member]

Hi Manny,

It's 300.

Since you are not mapping REFERENCEFIELD to any dimension, and set to OVERWRITE, it will load only 1 record and amount will be 300.

-- Selva.

[former_member481715]

Selvakumar, Are you sure? because if that is the case, how will you ever load data from standard infocube to BPC? there will always be some fields that will not be loaded.

[Former Member]

Hi Manny,

I was wrong in my previous reply. The sum will be 1500 in cube.

While loading data from infoprovider, there are 3 options. Append, Overwrite and Replace.

1. Append - This will load all duplicate records and sum the value with the data in the cube. ie., signedata.

2. Overwrite - This will not allow duplicate records. It will overwrite records which are there in the cube.

3. Replace - Based on matching Account, Entity, Category, Time.

-- Selva.