Defining measure groups and measures
The first cube recipe will create a simplistic cube based on the FactResellerSales fact table and will include only two dimensions: promotion and date.
To create a cube and its related entities, you must first define the data sources from where we'll import data and Data Source Views (DSVs), which define necessary relationships between dimension and fact tables, as well as dimensions you intend to include in your cube. Please refer to Chapter 2, Defining Analysis Services Dimensions, for recipes on defining data sources, DSVs, and creating dimensions
Getting ready
Create a new SSDT project called SSAS_Cookbook_Chapter3 and save it to any location of your choice. Create a data source view with all the tables via ...
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.
