How to create PSA between further data targets in BW 7.x Data Flow?
I noticed many people in SCN were asking questions regarding PSA creation between data targets. Keeping this in view I am writing this step by step blog on how to create a PSA in between further data targets in BW 7.x and higher versions.
This approach is not the best practice and might not be applicable in most of the scenarios.
We all know that PSA is not mandatory anymore while loading data to further data targets.
But if you want you can create a PSA in between data targets based on following assumptions:
- If your scenario demands a requirement of PSA between further Data targets.
- You want to have a intermediate PSA and the data flow needs to be in 7.x version.
- You want to use the flexibility of DTP on top of PSA in between further data targets.
- If you want to perform some manual correction of data before loading into cube.
- If you would like to have a additional layer of transformation.
Following is the Step by Step document to achieve this:
The steps are based on Load from ODS to Cube. The same can be applied in any further data targets.
Example: Assuming that you scenario already has a DSO and Cube
DSO Name: ZDSO_TES, Cube Name : ZCUB_TES
Step 1: We know that when ever a DSO is created, automatically data mart interface gets created with the prefix ‘8’ followed by DSO technical name. Find the data mart Infosource. In this case the Infosource name would be 8ZDSO_TES.
Step 2: Once you find the 8ZDSO_TES Infosource, you can expand the flow to view the associated transfer rules and Datasource.
Step 3: Right click on the transfer rule and select the option migrate.
Select copy Infosource 3.x to New Infosource
Provide a technical name for the New Infosource, which will be 7.x Infosource.
You should get the following message.
Step 4. Use the find option to view the generated Transforamtion.
You have to use the Find under Modeling tab to view the generated transformation.
It will look something like this:
Step 5: Double click on the transformation and in the change mode activate the transformation.
At this point the transformation is active and a 7.x generated Infosource gets created.
Step 6: Create a Transformation between Cube ZCUB_TES and the generated Infosource ZINT_PSA.
Right click on the cube and select create transformation:
Select Source object type “Infosource”. When you click on the Name you should be able to find the 7.x generated Infosource in the list.
Select the generated Infosource, in this case it is ZINT_PSA.
Activate the transformation.
Step 7: Now the flow will look like below.
Step 8: Create DTP
Select the Source of DTP as DataSource and select your Datasource (8ZDSO_TES) from the list.
Step 9: Create Infopackage.
Infopackage will be created under the Datasource “8ZDSO_TES”
Step 10: Schedule the Infopackage and then Schedule the DTP.
Now if you schedule the infopackage, the data will be loaded from ODS into the PSA, then the DTP schedule will load the data into Cube.
Request loaded into PSA.
DTP schedule loaded data into Cube successfully.
SAP has already provided different ways to control your data load between data targets ( ODS to ODS, ODS to CUBE, CUBE to CUBE), but if you want to have a PSA in between data targets in 7.x version of BW then you can use the above approach.