Exercise: Data Source View of Geography

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

The answer to the exercise will be included and explained if you attend the Wise Owl course listed below!

Category ==> SSAS - multidimensional  (21 exercises)
Topic ==> Data Source Views  (2 exercises)
Level ==> Relatively easy
Course ==> SSAS - Multidimensional
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Create a new project called GeographyOnly, and within this create a data source linking to the MAM database.

Create a data source view, and create a new diagram within this called Geography.

Add tables and configure them to create the following diagram:

SSAS Analysis Services exercise - Data Source Views (image 1)

You'll need to use diagonal layout, and give your tables friendly names

You'll need to create a relationship between the store and shopping centre tables, and give most of the tables new friendly names.

Create a named calculation called [Metres per unit] within the tblCentre table.  You can use:

SSAS Analysis Services exercise - Data Source Views (image 2)

A suggested way to calculate the metres per unit

Explore the shopping centre table and sort it by your new Metres per unit column to show that Holmbush Farm has the largest average unit size:

SSAS Analysis Services exercise - Data Source Views (image 3)

Click at the top of a column to sort by it

Close down all open windows!

This page has 0 threads Add post