Skip to Content
0
Former Member
Feb 11, 2011 at 07:30 AM

Question on Multi provider

42 Views

Dear Gurus:

Please clarifie the scenario

I have 3 transactional Datasources say

1.Datasource

field 1 A is the primary key

field 2 B

field 3 C .

2. Data Source

field 1 B is the primary key

field 2 D

field 3 E

.

.

3. Data Source

field 1 C is the primary key

field 2 F

field 3 G

.

.

Here the report requirement is like this

I need to display A,B,C,D,E,F,G

Now what should i do? whether i need to create 3 different cubes for 3 datasources and later we can connect 3 cubes with multi provider for reporting. If Yes, tell me the steps and assigning the info objects.

Pls note that Primary key is different for 3 datasources.