Configuring Data Blending in Data Cube
You can configure data blending when creating or editing a data source in Data Cube. For an overview of data blending and how it works, see Data Blending in Data Cube.
Before You Begin
Any additional data sources that you want to configure for data blending must be crawled in Data Cube. For more information, see Crawling a Data Source in Data Cube.
- Add a data source, or edit the configurations for a data source in Data Cube.
- In the Data Blending step, select Enable Data Blending.
The data blending configuration options appear. The current data source is automatically populated in the left drop-down list under Select Data Source.
- Click the Select Data Source list and select the data source that you want to blend with the current data source.
Tip: Use the search bar in the Select Data Source list to search for the data source that you want to use.
- Under Join On, enter the names of the equivalent data fields from each data source as follows:
- In the box to the left of the equal sign, enter the name of the data field in the current data source that you want to use.
- In the box to the right of the equal sign, click the list and select the name of the data field in the additional data source that you want to use.
- If you want to add more equivalent pairs of data fields, click the plus sign and repeat the previous step.
Note: If you add multiple pairs of equivalent data fields in the Join On section, then data blending will only occur when the values in all of the paired columns are the same. If only one pair of values are the same, then data blending will not occur.
- Under Select Columns to Retrieve, select the check boxes next to the data fields from the additional data source that you want to blend with the current data source.
Tip: Use the search bar to search for the data fields (columns) that you want to use.
- If you want to add more data sources to the data blending configuration, next to Data Source click the Add button and configure the options for the additional data source.
Note: If you add multiple data sources to data blending, then data blending will occur when any of the data source configurations have equivalent values in all of the data fields under the Join On section for that particular data source. If a data match exists for one configured data source but not a secondary source, then the string data not found will be inserted for the columns where data was missing for the data source.
After you configure data blending and crawl the data source, the default search view for the data source will contain the combined set of data according to your data blending configurations.