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?
Edited by: Shaun Enslin on Dec 23, 2007 9:41 PM
you only can create DTP with a connection from one cube to another. In your case you will need two DTP: Once from cube 1 to target cube and another with connection between cube 2 and target cube. The system will automatically recognize that there is a infosource between this cubes and will perform it each time.