Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide

Time for action – creating an entity with data from the Excel Add-in

MDS entities can be created with data from the Excel Add-in. In this example, we will load data from a database table into an Excel sheet and then create an MDS entity using the structure and data taken from the Excel sheet.

1. Open an empty workbook in Excel and go to the Data tab.
2. Click on the From Other Sources option (in the Get External Data section) and select From SQL Server.
3. Enter localhost as the SQL server name, then select AdventureWorksDW2012 as database, and select DimProductCategory. Click on Continue to finish. You will see the product categories listed in the Excel sheet.
4. Go to the Master Data tab. Connect to the MDS connection that you created in first example of this ...