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.