cancel
Showing results for 
Search instead for 
Did you mean: 

BI 4.2 IDT multi-source connection SAP ECC: Multiple Function Module (ABAP Programs)

Former Member
0 Kudos

Hello Experts,

I have been developing several function modules/abap programs as datasources for various reports pertinent to our BI reporting solution. We are primarily using SAP ECC as the data source. I have set up the relational connections to the ECC system, and applied all proper technical parameters as per guidance from the SAP community and technical resources.

The solution has actually been working great, HOWEVER, I have encountered an issue with the inability to join two different function modules in the data foundation in the IDT. Is it possible to publish a universe and properly query the data with this set up? Is this a limitation? Currently, it will give me the equivalent of 'the spinning wheel of death'.

Based on potentially outdated material online, it is recommended to conduct all joins on ECC-side (which we are doing for a number of reports already). The problem is I would like to avoid doubling the work effort. We already have FM's dedicated to several functional areas (i.e. SD, MM, FI, etc.). For example, if we simply need a sales price to complement our financial table read.

Any feedback would be appreciated as federating has gone great up until now.

I can provide further details on request. Thank you in advance.

Best,

Jake

Accepted Solutions (0)

Answers (2)

Answers (2)

amitrathi239
Active Contributor
0 Kudos

If developers/users are know when/how to take objects from classes then you can keep stand alone FM in the data foundation.

If required to get data from multiple classes then you can use merge dimension function at webi level.

Former Member

Amit, thanks for the perspective. This sounds rather straightforward for webi but concerns me when implementing with Lumira and Crystal. While my current requirement is basic, this sounds like it could get complex down the road and have negative implications on performance...? Either way, it sounds like a custom (complex) solution is required.

TammyPowlas
Active Contributor
0 Kudos

Hi Jake - I think your application will be faster if all the "joins" are back in ECC. Maybe you could join all the data using a SAP ECC infoset? This is what we do.

Former Member
0 Kudos

Thanks Tammy.. I will revisit this with my team.