Connecting to CRM and infosets From BO

[Former Member]

set-as-key.jpgHi ,

Im able to connect to SAP CRM system by using the SAP jco driver and was able to get the infosets into the data foundation layer of IDT.

But was unable to create the joins in between the infosets as the option to select the primary key for infoset is grayed out.

Not sure why the option to set as primary key is grayed out.

Also tried by creating multisource enabled universe to check if the primary key options shows there but was unable to view the infosets and only ABAP functions were visible through multisource universe .

set-as-key.jpg

Please suggest.

Thanks ,

Babu

[TammyPowlas]

OK, I understand, it is a one to many relationship. Still, if you could, I would try to get that working in one big InfoSet.

I don't know of a way you can do those joins in the IDT

[Former Member]

Hi,

Actually our aim is to build a report in BO using the report query(i.e. Z_CRM Dashboard) created in ECC.

This report query contains multiple subqueries i.e. 3 to 4 subqueries which has "Select" sql statements with joins between the tables... I have created a separate infoset for each subquery with joins in the infoset. When run the query for each infoset ,was bale to get the data..

Now I need to get the final combined data of all these queries that's where I was trying to create a join between these infosets...but was unable to create the join as I was not getting the option to set the column as primary key in these infosets in the Datafoundation layer.

ex:

Infoset1 : Customer ID,Customer name,Customer Ph,etc

Infoset 2 customer id,item purchased,quantity,price

Imtrying to make customer id as primary key and create join between the infosets to get the final output as raw data in one file

Customer id,Customer name,CustomerPh,item purchased,quantity,price

Hope you understood my concern.

Thanks,

Sudhir.

[TammyPowlas]

Your best bet is to find a way to get the joins to work in the SQXX transactions. Have you reviewed the table relationships using transaction SE11?

[Former Member]

Hi,

Actually our aim is to build a report in BO using the report query(i.e. Z_CRM Dashboard) created in ECC.

This report query contains multiple subqueries i.e. 3 to 4 subqueries which has "Select" sql statements with joins between the tables... I have created a separate infoset for each subquery with joins in the infoset. When run the query for each infoset ,was bale to get the data..

Now I need to get the final combined data of all these queries that's where I was trying to create a join between these infosets...but was unable to create the join as I was not getting the option to set the column as primary key in these infosets in the Datafoundation layer.

ex:

Infoset1 : Customer ID,Customer name,Customer Ph,etc

Infoset 2 customer id,item purchased,quantity,price

Imtrying to make customer id as primary key and create join between the infosets to get the final output as raw data in one file

Customer id,Customer name,CustomerPh,item purchased,quantity,price

Hope you understood my concern.

Thanks,

Sudhir.