Showing results for 
Search instead for 
Did you mean: 

Business Objects - Siebel Integration kit - Generate Query

Former Member
0 Kudos


Thank you for reading this post.

I am designing reports using Crystal reports 2008 from Siebel CRM using the BO - Siebel integration kit. With the help of kit, all the business components (BC) of Siebel are exposed as tables in Crystal reports and can be fetched in the query to run a report.

When I run a report from Account BC, I am getting multiple records in the report. When I checked the SQL query from Siebel server, I found that there is a cartesian product in the query due to which duplicate records are coming.

Is there any way to modify the query which is generated by the integration kit??

When I discussed the issue with the Siebel Configuration team, they suggested that there should be a way to choose links in the BC. Can you please suggest a way to expose links in BC??

Waiting for reply..



Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Devesh,

In Business Objects Enterprise Integration for Siebel document, Chapter 6 Using Crystal Reports with Siebel, there is content talking about:

Linking tables in reports, and introduce how to link between parent and child Business Components, how to use the parent's multi-value field, etc, etc.

Could you please have a look at the content there and let us know if it contain the information you need?

Business Objects Enterprise Integration for Siebel document is available here:

Thanks and Regards

Carlos Chen

Answers (0)