on 06-11-2014 9:47 AM
Hi all,
I know to eliminate duplicates we can go WDSO or check uniqueness of data--->settings ---> standard DSO I want to identify /trace duplicates while looking into DSO / Infocube and can i trace out exactly which request has data that duplicated data in the cube/DSO?
can u suggest me?
To identify the duplicate records while loading to a cube,
In the UPDATE tab of the DTP, under Error Handling choose Update Valid Records, No Reporting(Request Red).
If there are any duplicates those will be captured in the error stack. Display Error Stack to see the duplicate records.
Does this help??
Regards,
Meghana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
WDSO use loading the one time
WDSO have 0RECORDNO object - it will give the count of how many records
it check uni uniqueness of data it will allow the duplicate records.
DSO will overwrite based on the key fields check the KF property
please search "dso overwrite and summation in sap bi".
Thanks,
Phani.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.