Aggregations in SSAS

Practice Labs Module
Time
21 minutes
Difficulty
Intermediate

The "Aggregations in SSAS" module provides you with the instructions and devices to develop hands on skills in the following topic: Creating aggregations in SSAS.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

Introduction

The Aggregations in SSAS module provides you with the instructions and devices to develop hands on skills in the following topic:

  • Creating aggregations in SSAS

Exercise 1 - Creating Group of Aggregations

Aggregations in SQL Server Analysis Services (SSAS) improve query performance and calculation time. Aggregations limit the data to be scanned for answering a query.

In this exercise, you will learn to design aggregations in SQL Server 2012. As a prerequisite to this task, you will first perform the tasks to create and deploy a multidimensional cube in SSAS.

Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.