Working with data sources and loading data
In the previous recipe, you created the project; now it is time to load data into the model. Unlike other data modeling or data projects you have worked with, the Tabular Model loads the data into the model as soon as you define the data source and specify the data to load. This is a step beyond What You See Is What You Get (WYSIWYG). In this case, you see the data and the effects of all changes you make to it in real time.
The other thing is that you can load all types and sources of data into the model and relate the data after the data has been loaded. Data from a relational database, a text file, a data feed, or even a Power Pivot model can all be loaded into the same Tabular Model for analysis.
Note ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
