Skip to Content

​How to load Data from datasource 2LIS_13_VDITM to Infocube in BW 3.5?

How to load Data from PSA table (Req_xxxx not showing in Manage screen but in PSA table its available) to info cube in SAP BW 3.5 flow.?

Flow is like ECC -> DATAsource (2LIS_13_VDITM) -> Infocube.

Help Help. Its urgent.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jul 16, 2018 at 10:15 AM

    Hi,

    1. If you have deleted the request from the cube for some reason and if you want re-load the same request, then go to Manage screen of the cube and then into the tab "reconstruction" and select the request and click on "reconstruct\insert" button. It will update the request to cube.

    Prerequisite to do this " Request should exist in PSA".

    2. If you have not deleted the request earlier from the cube and it is a fresh request available in PSA and it is yet to load to the cube. Then go to data source --> Manage --> Select the desired request --> at the right side down of this screen you fill find a button to process this request to targets. Once you do this, it will open the Info package screen, select the required targets and push the request.

    Regards,

    Satya.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 16, 2018 at 09:12 AM

    An alternative would be to use the reconstruct feature at the cube level:

    Regards,

    Frederic

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 09, 2018 at 09:03 AM

    Hi Ameya,

    As a workaround, I suppose you could use "filter" in DTP to extract filtered data from PSA to InfoCube, if you could confirm that it will not causes data inconsistency in the target InfoCube.

    Best regards,
    Tibbie

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Tibbie,

      Thanks for the reply. As it is 3.5 flow, So it doesn't have DTP.

      "Flow is like ECC -> DATAsource 2LIS_13_VDITM (with Infopackage)-> Infocube.

      I have brought data from PSA to cube but by deleting all request till date and by scheduler option, I triggered all request one by one (Old to latest). However, Is there any easy way to bring deleted request .

      Regards,

      Ameya

  • Oct 16, 2018 at 05:51 AM

    Thank you Guys. Re-construction is not happening here. I have taken out SPA dump in excel and by Vlookup I have created ranges for Document IDs and loaded in setup table.

    Add comment
    10|10000 characters needed characters exceeded