An export datasource is created when you want to use an info provider to load data to another targets which may reside in the same system or different system. An export datasource is created by default for a DSO. But its not the case for cubes. Below I will discuss one such scenario where I created and transported an export datasource.
You want to load data from cube in one system to a cube in another system. Let’s say that the source system is a SAP BW system with id SRD and target system is another BW system with system id TGD
SRD – SRT – SRP (Source system landscape)
TGD – TGT – TGP (Target system landscape)
Now there is a cube in SRD system which has data. This data needs to be get loaded to a cube in TGD system based on certain filters and conditions. And this has to finally move to the production systems (SRP and TGP)
The way to do this is first to request for a TR (transport request) in both SRD and TGD systems.
Step 1: TR exists in SRD as well as TGD systems
Step 2: Select your cube in SRD system and right click and select additional functions – ‘Create Export Datasource’
Step 3: Make sure that the export datasource is saved in correct TR and package.
Step 4: Activate your cube in the SRD system and store it in the same TR and package.
(Note that the instead of the export datasource, infosource will be appearing in the TR, let it be like that, make sure that the cube is also included in the TR)
Step 5: Go to the TGD system – Replicate the datasource created above and activate it.
Step 6: Create data flow to load from the datasource to your target in the TGD system. Save and activate all the changes in the TR in the TGD system.
Step 7: Transport your TR in SRD system to SRT system. Check the objects after transport.
Step 8: Go to your target test system i.e. TGT and replicate the datasource there.
Step 9: Transport the changes from your TGD system to TGT system.
Follow the same procedure while transporting to SGP and TGP systems.
Make sure you follow the steps in the order mentioned above, or else the TR will fail in the TGT or TGP systems saying that the ‘export datasource does not exist’
Hope this helps..happy SAP BW 🙂