Create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS)
Design and implement dimensions in a cube
Implement measures and measure groups in a cube
- Design, develop, and create multidimensional databases; select a storage model
Design and implement dimensions in a cube
- Select an appropriate dimension model, such as fact, parent-child, roleplaying, reference, data mining, many-to-many, and slowly changing dimension; implement a dimension type; define attribute relationships
Implement measures and measure groups in a cube
- Design and implement measures, measure groups, granularity, calculated measures, and aggregate functions; define semi-additive behavior