Data load in SAP BW
What is the strategy to load for example 500,000 entries in BW (material master, transactional data)? How to separate this entries in small packages and transfer it to BW in automatic? Is there some strategy for that? Is there some configuration for that? See OSS note 411464 (example concerning Info Structures from purchasing documents) to create smaller jobs in order to integrate a large amount of data. For example, if you wish to split your 500,000 entries in five intervals: - Create 5 variants in RMCENEAU for each interval
Loading Data From a Data Target Can you please guide me for carrying out his activity with some important steps? I am having few request with the without data mart status. How can I use only them & create a export datasource? Can you please tell me how my data mechanism will work after the loading? Follow these steps: 1. Select Source data target( in u r case X) , in the
context menu click on Create Export Datasources.
2. In Modelling menu click on Source Systems, Select the logical Source System of your BW server, in the context menu click on Replicate DataSource. 3. In the DataModelling click on Infosources and search
for infosource 8(name of datatarget). If not found in the search refresh
it. Still not find then from DataModelling click on Infosources,
in right side window again select Infosources, in the context menu click
on insert Lost Nodes.
4. No goto Receiving DataTargets ( in your case Y1,Y2,Y3)
create update rules.
5. In the DataModelling click on Infosources select infoSource which u replicated earlier and create infopackage to load data.. SAP BW Tips by: Srinivas
Fast Links:
SAP Business Warehouse Tips
Best regards,
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|