CRM Delta

[Former Member]

Hi

In our CRM Transactional load first time I did FULL Loaded to DSO & Info cube at time Transaction details

Char1 Char2 count

A C 1

When I see the behavious in DSO

Active table

Char1 Char2 count

A C 1

Change table

Char1 Char2 count

A C 1

When I see the behavious in Info cube

Char1 Char2 count

A C 1

Full Load data is fine

Now the record was changed Char2 C to Char2 B.

I did delta Load

When I see the behavious in DSO

Active table

Char1 Char2 count

A B 1

Change table

Char1 Char2 count Image

A C 1 N

A C -1 X

A B 1

When I see the behavious in Info cube

Without DB aggregation I am getting four records

Char1 Char2 count

A C 1

A C 1

A C -1

A B 1

With DB aggregation I am getting two records

Char1 Char2 count

A C 1

A B 1

My requirment is I do not want see below record in info cube.

Char1 Char2 count

A C 1

I want to see only one record in my info cube.

Char1 Char2 count

A B 1

Please advice how can I achive this.

Thanks,

Manoj.

[Former Member]

good

[Former Member]

Hi Manoj,

It appears to me that the load which you are doing from ODS -> CUBE is a Full load and that too from Change log. (may be by mistake)

Please ensure that you are doing a delta load to the cube from change log of DSO.

Go to Extraction tab in the DTP to check this.

Regards,

Hemant Khemani