Blending Data That You Added

You might have a project where you added two data sources. You can blend data from one data source with data from another data source.

For example, Data Source A might contain new dimensions that extend the attributes of Data Source B. Or Data Source B might contain new facts that you can use alongside the measures that already exist in Data Source A.

When you add more than one data source to a project, the system tries to find matches for the data that’s added. It automatically matches external dimensions where they share a common name and have a compatible data type with attributes in the existing data source.

You can specify how you want the system to blend your data. See Changing Data Blending.

  1. Create or open an existing project and add data sources to your project.
  2. Go to the Data Sources pane and click Source Diagram.
  3. Click the number along the line that connects the external source to the newly loaded source to display the Connect Sources dialog.

    Note:

    Items that were never explicitly matched together may be matched by the system. For example, Customer.Person_Name is matched to Employee.Name, and Employee.Name is matched to Spouse.Given_Name.
  4. In the Connect Sources dialog, make changes as necessary.
    1. To change the match for a column, click the name of each column to select a different column from the external data source or between sources.

      Note:

      If columns have the same name and same data type, then they’re recognized as a possible match. You can customize this and specify that one column matches another by explicitly selecting it even if its name isn’t the same. You can select only those columns with a matching data type.
    2. Click Add Another Match, and then select a column from the data sources to match.
    3. For a measure that you’re uploading for the first time, specify the aggregation type such as Sum or Average.
    4. Click the X to delete a match.
  5. Click OK to save the matches from the data source to the data model on the server.