# Microsoft SSAS - multidimensional training exercises (page 1 of 2)

Showing exercises 1-20 (out of 21)

 Category: SSAS - multidimensional Topic: Data Source Views Level: Relatively easy Course: SSAS - Multidimensional Exercise: Create a data source view containing a diagram, including multiple tables and a new relationship.
 Category: SSAS - multidimensional Topic: Data Source Views Level: Average difficulty Course: SSAS - Multidimensional Exercise: Create a data source view to include named queries, and use this to explore data graphically.
 Category: SSAS - multidimensional Topic: Dimensions Level: Relatively easy Course: SSAS - Multidimensional Exercise: Create a dimension classifying animals by species, and tidy it up (for example, so the ALL member is renamed).
 Category: SSAS - multidimensional Topic: Dimensions Level: Average difficulty Course: SSAS - Multidimensional Exercise: Create a dimension based on geographical tables, and enable browsing by it so that everything looks tidy.
 Category: SSAS - multidimensional Topic: Dimensions Level: Harder than average Course: SSAS - Multidimensional Exercise: Create a discretized dimension dividing targets up into equal buckets (this also includes doing the same thing using a named calculation).
 Category: SSAS - multidimensional Topic: Basic Cubes Level: Relatively easy Course: SSAS - Multidimensional Exercise: Create the simplest possible cube: summing sales targets by region and year.
 Category: SSAS - multidimensional Topic: Basic Cubes Level: Average difficulty Course: SSAS - Multidimensional Exercise: Create a cube showing total sales by species and region, with filtering and formatting applied.
 Category: SSAS - multidimensional Topic: Basic Cubes Level: Harder than average Course: SSAS - Multidimensional Exercise: Create a cube comparing two different measure groups (sales and targets), and set the IgnoreUnrelatedDimensions property.
 Category: SSAS - multidimensional Topic: Hierarchies and Relationships Level: Relatively easy Course: SSAS - Multidimensional Exercise: Create a natural hierarchy showing fluffy toys within animals within species.
 Category: SSAS - multidimensional Topic: Hierarchies and Relationships Level: Average difficulty Course: SSAS - Multidimensional Exercise: Create an unnatural hierarchy, showing product sales by target age band and gender, and use this to build and filter a cube.
 Category: SSAS - multidimensional Topic: Parent-child Hierarchies Level: Harder than average Course: SSAS - Multidimensional Exercise: Create a parent-child hierarchy on a staff table, and use this to filter a cube to show sales for a particular store manager.
 Category: SSAS - multidimensional Topic: Time dimensions Level: Average difficulty Course: SSAS - Multidimensional Exercise: Create a cube showing the number of staff joining by year, including generating a time dimension and role-playing dimensions.
 Category: SSAS - multidimensional Topic: Calculations Level: Relatively easy Course: SSAS - Multidimensional Exercise: Create a simple calculation for a cube, either using form view or by typing in the MDX expression.
 Category: SSAS - multidimensional Topic: Writing MDX Queries Level: Relatively easy Course: SSAS - Multidimensional Exercise: Create a simple query showing animal types as column headings and species as row headings, then apply a WHERE slice.
 Category: SSAS - multidimensional Topic: Writing MDX Queries Level: Average difficulty Course: SSAS - Multidimensional Exercise: Create a query using sets to show total sales for two specific Mayan months, across shopping centre type.
 Category: SSAS - multidimensional Topic: Writing MDX Queries Level: Harder than average Course: SSAS - Multidimensional Exercise: Create an MDX query using a named set and NON EMPTY clause to get data for two specific shopping centres.
 Category: SSAS - multidimensional Topic: MDX Expressions Level: Relatively easy Course: SSAS - Multidimensional Exercise: Create a cube calculation to show sales which are up on the previous period in a different colour.
 Category: SSAS - multidimensional Topic: MDX Expressions Level: Average difficulty Course: SSAS - Multidimensional Exercise: Create a cube calculation showing for each sales value how this compares to sales of fluffy owls.
 Category: SSAS - multidimensional Topic: MDX Expressions Level: Harder than average Course: SSAS - Multidimensional Exercise: Create cube calculations showing month to date or year to date figures, depending on the level of granularity.
 Category: SSAS - multidimensional Topic: Cube actions Level: Average difficulty Course: SSAS - Multidimensional Exercise: Create separate click-throughs for shopping centre and centre type level, with customised captions based on MDX expressions.