Skip to Content
0
Former Member
Dec 23, 2007 at 08:41 PM

Using an infosource in BI7 for 2 cubes -> 1 cube

20 Views

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