In my project, after activating the 0UC_SALES_STATS_02 in R/3 system; I tried checking in RSA3. But it showed zero records extracted. Later I tried replicating datasource and created infopackage in BW and ran it, still zero records in PSA.

I found solution for this:

I did some settings in R/3, those are as below:

In t-code SBIW, Settings for application-Specific DataSources (PI) >>Utilities Industries>>Sales Statistics>> Define Performance settings for sales statistics extractor >> Tick the Initial update group is allowed (as shown below)

/wp-content/uploads/2013/11/11_333298.jpg

Later checked in RSA3 in R/3 system by giving some print document, I found data extracted.

/wp-content/uploads/2013/11/2_333338.jpg

/wp-content/uploads/2013/11/3_334105.jpg


Then the task was to pull the data in BW till PSA.

Follow the below steps:

  1. In BW, create an infopackage with full load and you will extract no records and it will remain with a yellow status; which is fine.
  2. Again in BW, run the infopackage with Initial Load (it should extract 1 record and be in status of green).
  3. Now loin to R/3 system and go to t-code EBW_DQ_SS, follow below steps:

               a. Under the “Environment” tab in menu strip, click “Unlock mass activity type”.

                   /wp-content/uploads/2013/11/4_333339.jpg

                b. Under “Program run” tab in menu strip, click “deactivate old run” by giving Date ID and Identification.

                         /wp-content/uploads/2013/11/5_333340.jpg

               c. Now run the mass activity EBW_DQ_SS by clicking “Schedule Program Run”.

                    /wp-content/uploads/2013/11/6_333350.jpg

  4. In BW system, run the Delta load for 0UC_SALES_STATS_02. Now you will see data extracted in PSA.

/wp-content/uploads/2013/11/7_333352.jpg

This is how you can pull the data from IS-U Sales statistics 0UC_SALES_STATS_02 DataSource to BW system till PSA.

To report this post you need to login first.

6 Comments

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

  1. AMAR Nath

    Hi proona Chandra nice artcal ,when I loading the delta it’s green and getting null values ,could please let me know the reason

    (0) 

Leave a Reply