So far we saw reporting with one source of data as the source. But we can also add more than one data source to the same report. In such case, we can use the attributes and metrics from both the sources in creating the visualization. The result appears as if we are dealing with one source of data. This happens because MicroStrategy combines both these sources and internally treats them as one.
Following are the steps to combine two source data sets and create a visualization.
Create a report with one source of data. We will use All_sales.xlsx in the example. Next, click the New Data menu as shown in the following screenshot.
Now you can see both the data sources available under the Dashboard. The attributes and metrics of both of these sources are available under their respective names.
Next, drag the attribute “Business Line” from All_sales.xlsx to the rows box. Drag the attributes “customer segment” and “Product Category” from the second data set to the rows box. The grid visualization appears showing data from both the data sets.