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

Problem with extraction of flat file to infocube

Hi there,

We are workin on SAP SCM APO release 7 that has the componente BW release 7. and we're trying to load data from a flat file to infocube like we used to do in release 5.

The problem is that we get the message that no data is available everytime we run the DTP. The transfer structure is:

1. source system: flat file

2. data source: a flat file according with our CSV file

3. transformation between the data source and the infocube

4. infocube

do i need to create an infosource even i'm loading from a flat file? With the release 5 of SAP SCM APO i don't need to create an infosource. It works fine from the data source to the infocube.

We don't fine any notes related so I'm asking if you have experienced this before with the release 7.0 and how do you solve it.

Regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2011 at 07:09 PM

    Hi

    Do you have data in data source(PSA)?

    use the Info Package to load data from flat file to data source(PSA).

    If you have data in data source(PSA), check the data mart status of request in PSA.

    If data masrt status is green, then you will not that request to CUBE.delete the request from PSA and load the same from flat file using IP.

    make the DTP extraction mode as full and execute, then you will get data to CUBE.

    Regards,

    Venkatesh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 21, 2011 at 05:55 PM

    Hi arturo,

    Are u getting the data to the PSA ?

    IF u getting the data in the PSA, and unable to get the data to the datatarget when u trigger the DTP . I think u have written some ROUTINE that is filtering the data.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2011 at 07:10 PM

    The issue was solved with the second answer.

    Thanks for your support.

    Add a comment
    10|10000 characters needed characters exceeded

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.