8 Replies Latest reply: Feb 19, 2009 6:32 AM by Rajesh Prasad RSS

Load data from PSA to DSO

Dave Marcus
Currently Being Moderated

Hi Experts,

 

How do I load data from PSA into DSO in BI 7? WE dont have and never had DTP. In 3.5 we had a PSA button under modelling in AWB and we just cliked update immediately.

 

Please help.

 

Thanks,

 

DV

  • Re: Load data from PSA to DSO
    Kiran Yelluru
    Currently Being Moderated

    use rsa1old transaction and push data from psa to datatarget in the same way as you used to do in 3.x

  • Re: Load data from PSA to DSO
    Jagadeesha K.S
    Currently Being Moderated

    Hi ,

     

    Go to your Datasource manage ,there u have your request.

     

    Select your request and schedule it...

     

    Thanks

    Jagadeesh

  • Re: Load data from PSA to DSO
    Debjani Das
    Currently Being Moderated

    Hi.........

     

    In BI 7.0.............first we load data till PSA using Infopackage........

    Then create Transformation between Datasource and the Target............for that right click on the Datasource and create Transformation...........ie field to field mapping.......

    After that right click on the Datasource..........create DTP..........and load the data.......

     

    Regards,

    Debjani.......

    • Re: Load data from PSA to DSO
      Dave Marcus
      Currently Being Moderated

      Hi Guys,

       

      Thanks for your inputs. I notiece under Status, there is a button below " Update Manually" I clicked it and then it started pushing data from PSA into DSO.

       

      DV

      • Re: Load data from PSA to DSO
        Debjani Das
        Currently Being Moderated

        Hi.......

         

        Is it Process Manually..........that means u r using BW 3.X data flow.right............yes.........if u load data using infopackage..and u first make the setting till pSA.........then that tab will come..........now it will update records to the target.....

         

        But......Now if u want to do reconstruction...........ie in BI 7.0.u r using BW 3.X dataflow..........then RSA1 >> Search the datasource >> Double click on it >> Click on the pSA button in the top >> Select the request >> in the button there is button looks like Infopackage group >> Click on it and schedule......

         

        In BI 7.0..........the reconstruction tab in the data target manage screen will not work......

         

        Regards,

        Debjani.......

  • Re: Load data from PSA to DSO
    Santosh Dhanawade
    Currently Being Moderated

    Hi,

     

    If u create DTP for data load then u just need to execute that DTP......the data will get update to DSO.

     

     

     

    Regards,

    SD

  • Re: Load data from PSA to DSO
    Ajay D
    Currently Being Moderated

    Hi

     

    In BI 7.0 Data will be extracted from R/3 to BI using infopackage.

    right click on datasource--> create transformations to the DSO instead of Infocube > fields will be mapped automatically or else map the fields manually> go to ur DSO > refresh> observe the dtp folder> right click on DTP folder> create DTP

     

    this is how u can load data from PSA to DSO if any issues reply back.

     

    Thanks and Regards,

    Ajay.D

  • Re: Load data from PSA to DSO
    Rajesh Prasad
    Currently Being Moderated

    If you use 3.x datasource with out migrating this option is still available in RSA1 itself. Expand from your DSO (from RSA1 infoprovider tree) till Datasource---> Right click Manage --> you will find the PSA requests and four buttons including the update with scheduler.

     

    If you are using BI 7.0 Datasources this one extra button will be missing.

    I guess PSAs of datasources replicate as BI7.0 (RSDS) cannot be seen in RSA1 old also.

     

    Regards

    KK

Actions