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

Unable to create DTP

Hi,

I am trying to load data from flat file to DSO , I have created steps to load data from flat file till PSA but after PSA when I am trying to create DTP,

its showing error as below. and also in my case its showing DTP type as blank. And target is already active.

Br

Sumeet

struct.png (30.2 kB)
DTP.png (42.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Oct 19, 2015 at 10:48 AM

    Hi Sumeet

    As per your first screenshot, your target is not a DSO. It is an infosource.

    When you haven't created a DSO, it will give the error. No doubt in that 😊

    Please check the flow properly and create DTP accordingly.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2015 at 11:26 AM

    Hi Sumeet,

    You have the option to create the DTP either right clicking on the Source or the target.

    Since you are having above mentioned issue with the Target, make sure that you create the DTP by right clicking the target. Else select the DSO as the target and select the correct DSO in the F4 help.

    Thanks

    Vivek

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 21, 2015 at 08:48 AM

    Hi Sumeet,

    First point - Info Source doesn't store any data it is a virtual object which has structure of a physical storage object like DSO. it acts like a channel for data during data flows. Info Source is not used in BW 7X versions, it had great importance in BW 3.X versions based on direct loading to data targets.

    Do one thing as you have already created an Infosource, use it as a Template to create a DSO- DataStore Object as shown in below picture. The other way is to create a DSO Directly using point 2 giving it a name and no template and then assigning Key and Data fields.

    Once you create a DSO following above steps, create a transformation with Source as your Data Source and (This) DSO, then try creating your DTP it should work.

    Note: Info Sources have its own importance under certain scenario's. In these kind of data flows Info Source is not required.

    Usual Data Flow in 7.X versions

    Data Source (PSA) -> DSO/Master Data Attributes/Texts/Hier's (via DTP) -> DSO/cube(further Data Targets based on your Architecture.)

    Regards,

    AK


    Untitled.png (59.5 kB)
    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.