Skip to Content
0
Former Member
Oct 21, 2010 at 10:36 AM

CRM Delta

12 Views

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.