Skip to Content
SAP Business ByDesign

Creating Custom Data Sources - Analytics

Tags:

In order to create customized data sources, please, follow the steps below. Bear in mind that we have three types of customized data sources that can be created in SAP Business ByDesign systems, and we are covering all three in this document.

For Cloud for Customer systems you will also have the option to create Cloud Data Sources, this topic is covered in the document Creating Cloud Data Sources - Analytics.

  1. Combined Data Sources
    1. Combined Data Sources are a type of data sources that will merge data between two or more data sources. In cases where you have data in the Data Source 1 but not in Data Source 2, you will then receive 2 rows for that certain data, where one line will be shown as "#" for Not Assigned. This happens because Combined Data Sources will only Merge the data, without checking for any matches between the Data Sources. In order to create a Combined Data Source, please, follow the steps below:
      1. Go to the Business Analytics work center and access the view Design Data Sources;
      2. Click on New Combined Data Source;
      3. On the New Combined Data Source screen define a name and a description for your customized data source;
      4. Click on Add Data Source and select the first data source which you want to use in your combination, by selecting the data source, a list of fields will be shown below it, select which Characteristics and Key Figures you want to use and click on OK, repeat the process until you have selected the data sources you want to combine;
      5. Check if all fields are correctly mantained/referenced and click on Check Mapping, if everything is ok, click on Save and Close. Your newly created data source is now available to create a report based on it.
  2. Joined Data Sources
    1. Joined Data Sources are a type of data sources that will merge data between two or more data sources based on the matching of its data, there are two types of Joined Data sources: Inner Join data sources and Left Outer Join data sources.
      1. Inner Join data sources are data sources that will select only characteristics from the data sources to be joined that match in the joined data source field along with any key figure values. Characteristic field values that do not appear in both data sources will be excluded, in order to create an Inner Join data source, follow the steps below:
        1. Go to the Business Analytics work center and access the view Design Data Sources;
        2. Click on New Joined Data Source;
        3. On the New Joined Data Source screen define a name and a description for your customized data source;
        4. In the case of a new Joined Data Source, you will have to select whether you are using an Inner Join or Left Outer Join, for this case, select Inner Join and proceed with the next steps;
        5. Click on Add Data Source and select the first data source which you want to use in your join condition, by selecting the data source, a list of fields will be shown below it, select which Characteristics and Key Figures you want to use, for joined data sources, the button for Select All is not available, since you should only select characteristics and key figures that are relevant to your data source, after selecting which characteristics and key figures you want to use click on OK, repeat the process until you have selected the data sources you want to use on the joined data source;
        6. Check if all fields are correctly mantained/referenced and click on Check Mapping, if everything is ok, click on Save and Close. Your newly created data source is now available to create a report based on it.
      2. Left Outer Join data sources is a type of join that selects all characteristics values from the data source that is selected as the anchor and those characteristic values that match in the data sources that are added along with any key figure values. By default, the first data source that you select is the anchor, this can be changed by clicking on the button Set Anchor in the Data Source creation screen. In order to create a Left Outer Join data source, please, follow the steps below:
        1. Go to the Business Analytics work center and access the view Design Data Sources;
        2. Click on New Joined Data Source;
        3. On the New Joined Data Source screen define a name and a description for your customized data source;
        4. In the case of a new Joined Data Source, you will have to select whether you are using an Inner Join or Left Outer Join, for this case, select Left Outer Join and proceed with the next steps;
        5. Click on Add Data Source and select the first data source which you want to use in your join condition, by selecting the data source, a list of fields will be shown below it, select which Characteristics and Key Figures you want to use, for joined data sources, the button for Select All is not available, since you should only select characteristics and key figures that are relevant to your data source, after selecting which characteristics and key figures you want to use click on OK, repeat the process until you have selected the data sources you want to use on the joined data source;
        6. Check if all fields are correctly mantained/referenced and click on Check Mapping, if everything is ok, click on Save and Close. Your newly created data source is now available to create a report based on it.

If you have any further queries, please, check the Central Document for Analytics Troubleshooting.