Skip to Content
author's profile photo
Former Member

DTP with out Transformation

Hi,

We have a flow like Data source > Transformation >Info source >Transformation > Info cube, (data source is 3.x) and here we need to create DTP from Data source to info cube.So, while trying to create DTP from data source to info cube, it is again asking to create transformation between data source and info cube...But, we just need to create DTP with out that new transformation...Please let us know the possibilities for this scenario...as we could see the availability of same scenario for the other flows

Thanks..

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

9 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on May 03, 2011 at 08:34 AM

    Hi David....

    It means you are using the Emulated Datasource .....and also you are not using the update rules anymore........you have created transformations....right....

    Then it should work...because we are also doing the same....

    Regards,

    Debjani.....

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 03, 2011 at 09:13 AM

    Hi

    create the DTP by doing right click on cube not on the data source, check for the source of the DTP it must be data source with the right source system.

    then activate the DTP.

    thanks

    neha

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 03, 2011 at 09:29 AM

    Hi,

    In BI7 you dont need to use infosource. You can directly create transformation between your Emulated datasource(3.5) and Data target ( cube). Then create DTP between DS and target.

    Else, if you want to use Infosource, first create DTP between datasource and Infosource as you have transformation between DS and Infosource.

    Then create another DTP from Infosource and Target as you have another transformation between these objects.

    Thanks,

    V.Senthil

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 03, 2011 at 06:38 AM

    Hi,

    Could you please explain what is the exact requirement why do u want to bypass the use of transformation.

    In case you dnt want transformation then you can load the data by using an APD or expert routine. However, if you use an expert routine also, you will have to create a transformation.

    Regards,

    Rahul

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on May 03, 2011 at 06:55 AM

    Hi,

    Ideally it should not ask. Can u try one thing?

    Create a direct transformation between the 2. Then when you create a DTP system would ask the Data Flow for which you want the DTP.

    Then select the flow mentioned above. Later delete the direct transformation.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      Your transformation is between data source and info source, and info source and cube. Now you are directly trying to create DTP between data source and info cube. I think you have to create transformation when you want to load directly to cube from data source.

      Regards

      Srikanth

  • author's profile photo
    Former Member
    Posted on May 03, 2011 at 08:02 AM

    Hi,

    In your flow from (Transformation --> Infosource --> Transformation) is there any complex routine written or in the final mapping to the cube (infosource -- Transformation--> cube) any field which is getting filled using lookup or so, because if there is no such complexities then you should be able to create a DTP from DS to cube.

    regards,

    Arvind.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on May 03, 2011 at 08:30 AM

    your mixing up terms/versions

    if your datasource is a 3.X as you state in your post, you can't have a transformation to the infosource, it would be a transfer rule. this goes to the infosource. if the entire flow is in 3.X, you have an update rule to the cube, not a transformation.

    in this case, you create an infopackage for the datasource, and you flag also the cubes you want to load.

    if you really want to use a dtp, you need to convert your datasource to a bi7 ds and create a transformation from the datasource to the infocube without using an infosource...

    M.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 03, 2011 at 09:30 AM

    Hi,

    In BI7 you dont need to use infosource. You can directly create transformation between your Emulated datasource(3.5) and Data target ( cube). Then create DTP between DS and target.

    Else, if you want to use Infosource, first create DTP between datasource and Infosource as you have transformation between DS and Infosource.

    Then create another DTP from Infosource and Target as you have another transformation between these objects.

    • Its asking you create transformation because you are trying to create DTP between Datasource and target directly without having a direct transformation between DS and target.

    Thanks,

    V.Senthil

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 05, 2011 at 08:30 AM

    Thank Q so much experts, my problem is solved.

    Many Thanks

    David

    Add comment
    10|10000 characters needed characters exceeded