Once the tabular model has been created in Excel, it can be immediately imported to a SSAS server, thus allowing multiple people to query it and additional (XMLA/MDX) client tools to access it. This recipe shows how to import an existing Excel model to the SSAS (tabular) server.
The workbook used in this recipe is the same as the workbook developed in the Allocating data at different levels recipe in Chapter 5, Applied Modeling. This is also the same workbook that was used in Chapter 6, Programmatic Access via Excel.
In order to import the workbook directly into SSAS, it must be saved with a
.xlsx (nonmacro) extension.
Let's start and connect to an SSAS server (with the storage in ...