Hi All
I am taking data from two cubes into a single cube. I have loads of rules so only want to do those complicated transformations once.
So I have two source cubes going into a infosource with just standard transformations (ie. field to field mappings)
Then I have transformations from the infosource to the target cube with the complciated transformations (ie. routines etc).
So all looks good and I do want to use an infosource as I want to do the mapping rules one. ( So please dont respond that I dont have to use infosource in BI7, as I already know this 😉 )
Now that I have done that I cant see where to create a DTP to send data from the 2 source cubes to the infosource and then how to create a dtp to send data from the infosource to the target cube.
When I create a dtp, I dont see an option for infosource being the source or target?
thanks
Edited by: Shaun Enslin on Dec 23, 2007 9:41 PM