I am working on SAP HCM-BW 7.0 Implementation and am trying to load data into 8 different InfoObjects (Texts) through 0EHS_PHRASE_TEXT (Phrases) extractor.
There are many InfoPackages in place created during the previous project loading into different set of Standard BCT InfoObjects.
After migrating the 0EHS_PHRASE_TEXT DataSource from 3.x to 7.0 version, I have created different InfoObjects with Transformations and DTPs upon business requirements to load them. The relevant data is available in 0EHS_PHRASE_TEXT when checked in Extractor Checker (RSA3). However, when I create InfoPackages to load these different InfoObjects, I don't see the Data Targets listed and it makes sense since the data is first loaded into PSA and then will be loaded into Data Targets (in this case InfoObjects with Text) using DTPs.
My concern is... when I create a Process Chain to load Master Data into these Objects, the following action is happening:
1. Load 10 Records into PSA and then into InfoObject A. All 10 Records are loaded into A.
2. Load 5 Records into PSA and then into InfoObject B. Previous 10 + New 5 Records are loaded into B.
3. and it continues... for 8 InfoObjects.
My question is... is there are way that I can see the corresponding Data Target tab in InfoPackages so the Data is immediately picked from PSA of 0EHS_PHRASE_TEXT DataSource and then loaded into the corresponding InfoObjects.
Or should I make use of Transfer Rules by Re-storing the 0EHS_PHRASE_TEXT DataSource from 7.0 to 3.x version...!!
Your help is much appreciated.
i too facing the same issue please let me know the solution.
i am using SAP bi 7.0 0EHS_PHRASES_TEXT is my datasource for the 11 different master data info objects and also using 11 different infopackage with the input parameter to load these master data.
As he said 1st master data loaded with the relavant data but 2nd master data loaded with 1st master data value + 2nd master data value.
My #1 suggestion would be to move the logic where you're deciding which EHS texts belong to InfoObject 1, from the InfoPackage to the DTP.
This way, you have 1 InfoPackage that pulls ALL EHS_PHRASE_TEXTS into the PSA. Then your DTP (or transformation start routine), Filters only the EHS_PHRASE's that you want loaded into the indiviual InfoObjects. If you have a question about how to do this let me know.
Develop this logic into your Process Chain..
Delete All PSA requests
Run InfoPackage 1
Run DTP 1
Delete All PSA requests
Run InfoPackage 2
Run DTP 2
Delete All PSA Requests
Build individual Datasources for each InfoObject.
There are some points I don't get in your explanation.
Why is the extractor delivering 10 and then 5. Is it delta?
I understand your requirement like this.
You have one datasource 0EHS_PHRASE_TEXT and 8 different infoobjekts. -> 1 infopackage, 8 transformations and 8 dtps.
I see two options.
1.) One is you load the data into psa in the first step of the process chain and then in parallel into each infoobject.
2.) You use the dtps to extract directly in full from the datasource. (That's what you might mean with direct picking the data.)
P.S.: or is there any selection in the infopackage "selecting" which infoobject you wish to get the texts for? That's a bit confusing. Sorry I don't know the particular extractor. But maybe me 2 cents are helping anyway.
Edited by: Andreas Gschwendt on Nov 4, 2010 11:00 AM