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 the AdventureWorksDW2012 database. Add the promotion dimension as discussed in Chapter 2, Defining Analysis Services Dimensions. Also add the date dimension based on the DimDate table and include the year, month, and date attributes. The date attribute...