Building a Database
You would build an Analysis Services database by identifying the data to include in the database, specifying the relationships between those data, defining dimension structures on those data, and finally building one or more cubes to combine the dimensions and measures.
SQL Server Data Tools
The process to build an Analysis Services database begins by opening a new Analysis Services project in the SQL Server Data Tools. Each project corresponds to a database created on the target server when the project deploys.
Be sure to set the target server before attempting to deploy your new database, as shown in Figure 53.1. Right-click the project in the Solution Explorer, and choose Properties. Then set the target server in the deployment property page.
You can define a data source on any data for which an OLE DB provider exists, enabling Analysis Services to use many types of data beyond the traditional ...
Get Microsoft SQL Server 2012 Bible 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.