on 03-23-2015 7:54 AM
Dear All,
We were on SAP BI 7.0 version and have been migrated to SAP HANA Data base 3 months ago.
We have one data flow which exists from last 5 years. The data Flow is Cube --> DSO3 --> DSO2 --> DSO1-->Info Package
DSO1 is write optimized and DSO2 and DSO3 are standard DSOs.
After HANA data base migration, few delta records are missing from DSO2 to DSO3 which never happened prior to Migration.
Please note that we didn't change any logic between DSO2 and DSO3 in last 5 years and current version is SP6.
If anybody faced similar issue in your project please share with us the solution. Thanks for your time.
Regards,
Anjee
Hi Anje
What asettings are you using in the DTP? What is the processing mode? Is there semantic grouping set?
If the release is 740 i would suggest to install SP09-SP10 at least. If its 7.3x then i also would suggest a more recent version.
br
Roland
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
Thanks for your reply.
We are on BI 7.4 (HANA SP 6) and semantic grouping are not set for any field.
Keys in DSO3 are SHIPS Shipment ID, Order Number, Standard Item Code, GL Account and Invoice ID
Keys in DSO2 are SHIPS Shipment ID, Invoice ID and Freight Pkey.
We do derive GL Account in the end routine and Order Number, Standard Item Code are mapped from data fields of DSO2.
Processing Mode: Serial Extraction, Immediate Parallel Processing.
Settings are same in both DSOs.
BR,
Anjee
Hi Anjee
There were some issues with the sorting of data. Therefore i would suggest to apply the notes like:
2143766
2037066
2147862
And also consider note 1358780 and 2065853.
If this doesn't work could you please tell us with some screenshots, as of what exactly is missing? How the data looks like in the source DSO? What is in the target? What is the expected result?
br
Roland
Hi,
which procedure did you used for the BW on HANA migration?
old way via separate upgrade and migration? which BW Release do you have now?
new way via DMO procedure?
did you runned a table comarision before/after the migration?
Best Regards Roland
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Anjee,
Could you maybe tell a bit more on exacty what the situation is?
- Exact BW version
- Keys in DSO's
- Examples of data records missing
- Settings in DSOs
Sjoerd
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.