No dimensions from a secondary source

Data blending, although very useful for connecting disparate data sources, has limitations. The most important limitation to be aware of is that data blending does not enable dimensions from a secondary data source. There is an exception to this limitation; that is, there is one way you can add a dimension from a secondary data source. Let's explore further.

Exercise: adding secondary dimensions

There are other fields besides Sales Person/Sales Associate and Shirt Amount/Pants Amount in the data sources.

We will reference those fields in this exercise:

1. In the workbook associated with this chapter, select the Adding Secondary Dimensions worksheet.
2. Select the Shirts data source.
3. Add...