DTP with out Transformation

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

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

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

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.

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.

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.

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

Thank Q so much experts, my problem is solved.

Many Thanks

David