Free SSAS - multidimensional exercises

This page lists 21 SSAS - multidimensional exercises. You can use the menu to show just exercises for a specific topic.

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
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.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
Topic: Hierarchies and Relationships
Level: Relatively easy
Course: SSAS - Multidimensional
Exercise: Create a natural hierarchy showing fluffy toys within animals within species.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
Topic: Basic Cubes
Level: Relatively easy
Course: SSAS - Multidimensional
Exercise: Create the simplest possible cube: summing sales targets by region and year.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
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).

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
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.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
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.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
Topic: Writing MDX Queries
Level: Relatively easy
Course:
Exercise: Create a simple query showing animal types as column headings and species as row headings, then apply a WHERE slice.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
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.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
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.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
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.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
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.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
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.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
Topic: Writing MDX Queries
Level: Average difficulty
Course:
Exercise: Create a query using sets to show total sales for two specific Mayan months, across shopping centre type.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
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.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
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.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
Topic: Writing MDX Queries
Level: Harder than average
Course:
Exercise: Create an MDX query using a named set and NON EMPTY clause to get data for two specific shopping centres.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
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).

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
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.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
Topic: Cube actions
Level: Harder than average
Course: SSAS - Multidimensional
Exercise: Create a drill-through action for a cube, then open it in Excel to see if you can get it working!.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
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.

Go to exercise ...

Software: SSAS - multidimensional
Version: SSAS 2008 R2 and later
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.

Go to exercise ...

You can search our full list of SSAS exercises here.

This page has 0 threads Add post