Hi Friends,
Env BW 7.4 on hana
I have question regarding moving data from one standard DSO to another with fewer keys in the second level DSO.
First layer staging DSO for FI GL 10 extractor
Keys
Account, company code, fiscalyearperiod,RTCUR, Zfield, other fields
Zfield is a concatenation field of profitcenter and segment, as we exhausted all the keys of the DSO
Second layer DSO
Account, company code, fiscalyear period,profit center, segment, other fields(same as the first level)
In the 2nd level we split up the Zfield to profit center and segment. RTCUR is not being used in this level as we do not need it for further reporting
the data part is 0credit, 0debit and 0balance - standard sap content
The transformation for the data part is set to "overwrite" in the aggregation.
Here is one sample of data in the first level dso
Account Company Zfield RTCUR 0balance ....
XXX YYY 1001100 EUR 5000
XXX YYY 1001100 GBP 450
XXX YYY 1001100 USD 1600
2nd level DSO
Account Company profitcenter segment 0balance ....
XXX YYY 1001 100 7050
Is this a normal behaviour, does the data from the first level actual get cumulative before being fed to the second level.
I would assume as the amounts are set to overwrite, we might get the last record that got updated to the DSO, in whatever order it is.
Thanks for your time.
Ed.
difficult to analyze it from the far.
Please check your company code currency and document currency. Maybe they aren't in accordance with any currency. Check t-codes: OX02 and OB22 (ECC source system).
Furthermore if you have a BW testing system with reliable data in the underlying ECC source system try the following.
Delete all data from 2nd level DSO, thereafter add RTCUR in the 2nd level DSO and make a reload from 1st DSO.
Did you already check the data quality of 1st level DSO. Are the data there correct?
Friends, your inputs are highly appreciated.
PS - There is no selection for semantic keys.
Thanks Thomas for your reply.
We were having significant differences in balances that we get from Totals(GL10) and Line item(GL14) extractor. We raised a note with SAP, and they asked us to include RTCUR as a key figure in GL10's first level DSO, and do not move forward as its not used in reporting.
The aggregation behaviour of the infoobject 0balance is "Sum". However we were are mapping in the transformation, the aggregation is set to
"Overwrite"
Process flow with standard DSO's is already in production. But will definitely explore the option of advanced DSO.
Hi
Why don't you need the currency as important key field? Check to use a semantic partitioned DSO or as you alreaday uses BW 7.4 on HANA the advanced DSO with over 120 possible key fields.
Check the aggregatrion behaviour of your key figures again.
Thanks
T.