SQL Server Analysis Services or SSAS multidimensional models contain objects called Dimensions, which is a collection of related objects used to provide the fact data to one or more cubes. The data provided to the cube is used by users to analyze the fact data. Dimensions are required in a multidimensional model to provide the basic information, attributes, and hierarchies. This course will demonstrate how to create dimensions, including how to configure relationships, hierarchies, and attributes. This course is one in a series of Skillsoft courses to help learners prepare for the 70-466 Implementing Data Models and Reports with Microsoft SQL Server certification exam.
Learning Objectives
Creating Dimensions
- start the course
- create a dimension using the Dimension Wizard
- configure a dimension structure using the Dimension Designer
- configure dimension attribute relationships using the Dimension Designer
- develop a custom attribute on a dimension
- create user-defined hierarchies in a dimension
- define a translation for dimension metadata
- create a time dimension using the Dimension Wizard
- modify a time dimension using the Dimension Designer
- manage parent-child dimensions
- create linked dimensions
Measure Groups
- create a basic measure
- create a measure group
- design granularity
- create linked measure groups
- use aggregation functions to create an additive measure
- use aggregation functions to create a nonadditive measure
- explain how to define a semiadditive measure
- use aggregation functions to create a semiadditive measure
- configure measure properties
- configure measure group properties
Practice: Create Dimensions and Measures
- design and create dimensions and measures given different scenarios