Skip to Content
0

Connecting to CRM and infosets From BO

Dec 18, 2016 at 04:51 PM

58

avatar image

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

set-as-key.jpg (154.8 kB)
set-as-key.jpg (154.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Tammy Powlas
Dec 18, 2016 at 05:32 PM
0

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?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

0
sudhir kanakoti Dec 19, 2016 at 03:58 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Tammy Powlas
Dec 19, 2016 at 09:55 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded