In this blog, you will learn how to develop a new custom data source in SAP C4C. This data source can be used further for developing a new report, key figure or a new custom KPI. It means, developing a data source gives us more flexibility to develop more helpful analytical dashboards and reports.
2. Data Source Types
Based on what SAP explained here, two types of custom data sources could be created in C4C:
- Combined Data Sources: this type combines at least two data sources which are expected to have same set of characteristics and different key figures to have all of the key figures in one place. However, in some cases you may create a combined data sources for gathering different characteristics which are not available purely in one single data source.
- Joined Data Sources: this type can be used when at least two different data sources have same characteristics and different key figures and joining them will set all these characteristics beside each other. It is possible to have more than one join. In C4C you can create two types of joined data sources:
- Inner Join: In this case, only records will be joined which exist in all of the selected data sources.
- Left Outer Join: In this case records inside the data source selected as anchor will be considered as source and the additional characteristics of the records in other data sources with the same characteristics will be added to it.
3. Developing a New Custom Data Source
To develop a new custom data source, you should at first access “Business Analytics – Design Data Sources” through SAP C4C main manu:
Image 01: Accessing Data Source Work Center
As the next step, you can clock “New” and then select desired data source type which can be Joined or Combined as explained in previous section:
Image 02: Selecting Desired Data Source Type
3.1. Developing a Joined Data Source
If you select “Joined Data Source” in Image 02, you can create a joined data source after which you see following screen. Here you can enter Name and Description of the data source and determine desired Join Type. In this example, you want to create a Joined Data Source with type Inner Join.
Image 03: Creating a Joined Data Source – Step 01
As you see above, as the next step you should add standard Data Sources by pressing “Add Data Source”, after which you can select desired data sources and required characteristics as following:
Image 04: Creating a Joined Data Source – Step 02
After adding all desired data sources and selecting required characteristics, you can see that C4C identifies possible characteristics for joining records, however, you can remove them or add new joins.
Image 05: Creating a Joined Data Source – Step 03
As the final step, you can save and close it, afterwards you can run it by selecting the data source and pressing “Preview”:
Image 06: Preview a Joined Data Source
If you run it, you can see how corresponding records will be joined. On the right side, you can determine which characteristics and key figures could be visible:
Image 07: Run a Joined Data Source
3.2. Developing a Combined Data Source
If you select “Combined Data Source’ in Image 02, you can create a combined data source after which you see following screen. Here you can enter Name and Description of the data source.
Image 08: Creating a Combined Data Source – Step 01
As you see above, as the next step you should add standard Data Sources by pressing “Add Data Source”, after which you can select desired data sources and required characteristics as following:
Image 09: Creating a Combined Data Source – Step 02
After adding all desired data sources and selecting required characteristics, you can see that C4C identify possible characteristics for mapping records, however, you can remove them or add other ones.
Image 10: Creating a Combined Data Source – Step 03
As the final step, you can save and close it, afterwards you can run it by selecting the data source and pressing “Preview”:
Image 11: Preview a Combined Data Source
If you run it, you can see how corresponding records will be combined. On the right side, you can determine which characteristics and key figures could be visible:
4. Conclusion
As a conclusion, you are now able to develop a new custom data source which can be used later for developing reports, key figures, and KPIs.
5. Call for Action
I would like to request you to share feedback or thoughts in a comment and follow my profile (Mohammad Salmani) for future posts.
If you have any question regarding SAP C4C Sales or Service you can ask it here (sales questions) or here (service questions), respectively or even read other blogs through these two links for sales and service.
