SSAS - MULTIDIMENSIONAL EXERCISES▼
SSAS - multidimensional | Data Source Views 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.
You can learn how to do this exercise on the relevant Wise Owl classroom training course (sadly for the moment only in the UK).
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:
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:
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:
Click at the top of a column to sort by it
Close down all open windows!