on 04-14-2011 11:36 PM
Hi All,
We have a data flow that used 0FIGL_C20 cube and 0FI_GL_20 data source. We have to do full loads every day becuase there is not DSO in the data flow. Now, i have created a custom DSO and inserted in the data flow, but a lot of records are left out from the PSA.
Here are the Keys of my DSO:
Version
Company code
Fiscal year / period
G/L Account
Cost Center
Value Type
Profit Center
Partner profit center
Segment for Segmental Reporting
Partner Segment for Segmental Reporting
Fiscal year variant
Currency Type
Valuation View
Currency key
Ledger
Debit/credit indicator
I initially thought that the keys might be the issue but i have see in debug mode that for two records with same keys only one was loaded. The difference was only the credit amount.
Becuase a lot of the records are not loaded our balances do not match. Please share your thoughts, any help is appreciated.
Hi,
Please compare the data extracted in PSA and that in the SAP tables.
If the data in the PSA is correct then :-
1. check the KF aggregation type.
2. Also check the total based on the credit debit indicator.
Regards,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi..
In the transformation please check the aggregation type for the keyfigure....
If it is summation then for the same key combination the keyfigure value will get summed up...
But if it is overwritten then for the same key comnination only the last value will get updated.......because the previous one will get overwritten by the next one....
may be due to this it seems to you that some values are missing...
Regards,
Debjani....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Please have a look into the transformation - > KF . Are they Summation or Over-write ??
If they are over-write , you can understand why only one record is loaded for the same key combination .
Hope this helps .
--Neha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.