Skip to Content

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.

/wp-content/uploads/2013/07/1_255054.jpg

Step 2: Once you find the 8ZDSO_TES Infosource, you can expand the flow to view the associated transfer rules and Datasource.

/wp-content/uploads/2013/07/2_255055.jpg

Step 3: Right click on the transfer rule and select the option migrate.

/wp-content/uploads/2013/07/3_255065.jpg

     Select copy Infosource 3.x to New Infosource

/wp-content/uploads/2013/07/4_255066.jpg

     Provide a technical name for the New Infosource, which will be 7.x Infosource.

/wp-content/uploads/2013/07/5_255067.jpg

    

     You should get the following message.

/wp-content/uploads/2013/07/51_255068.jpg

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.

/wp-content/uploads/2013/07/6_255069.jpg

     It will look something like this:

/wp-content/uploads/2013/07/7_255070.jpg

Step 5: Double click on the transformation and in the change mode activate the transformation.

/wp-content/uploads/2013/07/8_255071.jpg

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:

/wp-content/uploads/2013/07/9_255072.jpg

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.

/wp-content/uploads/2013/07/10_255073.jpg

     Select the generated Infosource, in this case it is ZINT_PSA.

     Activate the transformation.

Step 7:  Now the flow will look like below.

/wp-content/uploads/2013/07/11_255074.jpg

Step 8: Create DTP

Select the Source of DTP as DataSource and select your Datasource (8ZDSO_TES) from the list.

/wp-content/uploads/2013/07/12_255075.jpg

/wp-content/uploads/2013/07/13_255076.jpg

Step 9: Create Infopackage.

Infopackage will be created under the Datasource “8ZDSO_TES”

/wp-content/uploads/2013/07/14_255077.jpg

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.

/wp-content/uploads/2013/07/15_255078.jpg

     DTP schedule loaded data into Cube successfully.

/wp-content/uploads/2013/07/16_255079.jpg

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.


To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply