on 04-09-2008 7:05 PM
Hi guys,
I have an input file that may contain dupplicate records for the key. I am having trouble loading to an ODS because the key is duplicated. Is there a way to have one register in the ODS with sum of the duplicate records?
Ex:
Input File:
YEAR COMPANY VALUE
-
2007 COMPANY1 2.00
2008 COMPANY1 2.00
2008 COMPANY1 2.00
2008 COMPANY2 2.00
Expected data in ODS:
YEAR COMPANY VALUE
-
2007 COMPANY1 2.00
2008 COMPANY1 4.00
2008 COMPANY2 2.00
help will be rewarded
Thx
DGF
uncheck the option Unique Data Records in the DSO and make the Key figures as addition.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello David,
Change the key figure aggregation behaviour from Overwrite to addition.
Nick
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.