Skip to Content
author's profile photo Former Member
Former Member

Data from PSA to ODS

Hi all,

I have a custom ODS that, at the moment, is filled with data coming from a standard lower level ODS.

Is it possible (and how) to insert data in that ODS directly from the PSA not passing through that standard ODS?

Thanks a lot and bye.

Gianfranco

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2005 at 03:40 PM

    1. In case of an automatic process, you can create updateRules from the infoSource to the infoCubes.

    2. In case of manual process, transaction RSA1 -> Modeling PSA -> modeling -> PSA -> right click on the mouse -> Schedule the update -> and you can choose your data target

    3. In case you have several ODS from the same infoSource you can change the data target in the infoPackage.

    4. In case you don't need the standard ODS, desactivate the updateRule

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      If you want to get the PSA table related to 0AU_WTY_ITEM try this:

      - Transaction SE11

      - Input '/BIC/B*' in the Database table parameter

      - Press F4

      You'll get a list of tables with the description 'Transfer Structure Application DataTargetTechName' look up in this list for your data source name 0AU_WTY_ITEM and you'll get the related PSA table.

      Hope this helps,

      Andreu

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2005 at 02:58 PM

    I believe there is a paper that details how to create a datasource for PSA. I think the paper is how to reconcile PSA to InfoCube contents or something similar.

    Hope that puts you on the right track.

    Please award points if you see fit..

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I explain better.

      My problem is that my ODS have some standard key figures that can be easly mapped.

      Some others are custom and must be filled with data coming from PSA stage.

      The problem is that I do not know how to retrieve the name of the PSA tables/structures on which address my routine.

      Ex. ODS Warranty Header takes data from 0AU_WTY_HEADER DataSource for all its key figures. If we add a new key figure whose data must be taken from 0AU_WTY_ITEM (for ex.) we need to write a routine (I think).

      The problem is that I dont know to which tables address in the PSA.

      Thanks.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.