Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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?


Edited by: Shaun Enslin on Dec 23, 2007 9:41 PM

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Shaun,

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.