Skip to Content
avatar image
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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • 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 comment
    10|10000 characters needed characters exceeded

    • Sumeet

      Which is your final target. Search for the DSO in RSA1, right click on it and choose the option create DTP, it will automatically populate the source and target name.

      Try this way and keep going 😊

      Regards

      Karthik

  • avatar image
    Former Member
    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 comment
    10|10000 characters needed characters exceeded

  • 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 comment
    10|10000 characters needed characters exceeded