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.