Implementing Dimensions

SQL Server 2014    |    Intermediate
  • 10 videos | 49m 58s
  • Earns a Badge
Likes 12 Likes 12
A SQL Server Analysis Services (SSAS) cube includes measures and measure groups. Explore measures, including how to create and configure them for use in a cube.

WHAT YOU WILL LEARN

  • create a basic measure
    create a measure group
    design granularity
    create linked measure groups
    use aggregation functions to create a additive measure
  • use aggregation functions to create a non-additive measure
    explain how to define a semi-additive measure
    use aggregation functions to create a semi-additive measure
    configure measure properties
    configure measure group properties

IN THIS COURSE

  • Playable
    1.  Creating Measures
    5m 41s
    Learn how to create a basic metric. FREE ACCESS
  • Playable
    2.  Creating Measure Groups
    4m 18s
    Learn how to create a measure group. FREE ACCESS
  • Locked
    3.  Designing Granularity
    7m 21s
    During this video, you will learn how to design a granular structure. FREE ACCESS
  • Locked
    4.  Creating Linked Measure Groups
    2m 54s
    During this video, you will learn how to create measure groups that are linked. FREE ACCESS
  • Locked
    5.  Using an Additive Measure in a Cube
    4m 42s
    Learn how to use aggregation functions to create an additive measure. FREE ACCESS
  • Locked
    6.  Using a Non-Additive Measure in a Cube
    5m
    In this video, you will use aggregation functions to create a measure that is not additive. FREE ACCESS
  • Locked
    7.  Defining Semi-Additive Behavior
    3m 34s
    After completing this video, you will be able to explain how to define a semi-additive measure. FREE ACCESS
  • Locked
    8.  Using a Semi-Additive Measure in a Cube
    4m 32s
    In this video, learn how to use aggregation functions to create a measure that is only partially additive. FREE ACCESS
  • Locked
    9.  Configure Measure Properties
    6m 22s
    In this video, learn how to configure measure properties. FREE ACCESS
  • Locked
    10.  Configure Measure Group Properties
    5m 33s
    In this video, you will learn how to configure properties for measure groups. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.