C4C Analytics Expose Data Source

[mjveerhuis1]

Hi,

We have the requirement to expose some data sources. This works fine for the standard data sources. But as the data sources are missing information, I want to use joined data sources. I understand that in the past it was not possible to expose joined data sources because of performance reasons. Is that still the case or can I work around that by selecting maybe less characteristics? I tried to define a combined data source, but one of the data sources I would like to use cannot be selected.

What can I do? Has anybody experienced the same situation and how can it be solved?

Kr.

MJ

Just to give you some more background.

We want to report in another application on opportunities = data source CODOPPH. In this data source in C4C the employee data = CODHCMEMPB is a referenced data source. The data we would like to use in reporting Department ID and Department is not part of the data source CODOPPH it self, but part of the CODHCMEMPB data source. So when exposing the standard data source CODOPPH, the department information is not included.

1. I can make a join of the 2 data sources CODOPPH + CODHCMEMPB, but this joined data source can not be exposed

2. I cannot make a combi of the 2 data sources CODOPPH + CODHCMEMPB, as the latter can not be selected.

[former_member497128]

Hi mjveerhuis,

We can not expose joined data source, so we have to go for combined data source.
You have mentioned that when you try to combine CODOPPH and CODHCMEMPB, you are not able to add CODHCMEMPB but when i tried in internal system, i was able to create combined data source with above two.
Can you please check again and let us know if you are not getting data source "CODHCMEMPB" upon searching or you are getting any error. Otherwise, you can raise incident to SAP.

Regards,
Saurav Kumar

[mjveerhuis1 · Accepted solution]

Hi,

I succeeded to create a combined data source in another system CODOPPH and CODHCMEMPB. So it is ok.

For our requirements we also exposed /MOM/ORGCENTRE as it includes all organizational ID's, descriptions and guid's, So this can be used in the other analytical application as a reference.

MJ