SSAS - multidimensional | MDX Expressions exercise | Show for each animal how compares with owls sales

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.

Software ==> SSAS - multidimensional  (21 exercises)
Version ==> SSAS 2008 R2 and later
Topic ==> MDX Expressions  (3 exercises)
Level ==> Average difficulty
Subject ==> SSAS training
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 cube (with associated dimensions) or open an existing one.

Amend the cube so that it shows:

  • Total sales
  • What the total sales are for the Owl animal group for the same year, month or date
  • The difference between sales and your owl benchmark

This calculation should only display at the [Animal Id] level of the Classification hierarchy of the Product dimension.

Here's what your final answer could look like:

SSAS Analysis Services exercise - MDX Expressions (image 1)

You can only see figures at the Animal ID level of the hierarchy

If yoiu're using Analysis Services 2012 or later, you'll need to analyse your cube in Excel to see a pivot-table-style view of it similar to the one shown above.

Optionally, copy the MDX expression you've created into a new SQL Server Management Studio query, and then save it as Pointless data comparison.mdx.

Close down all open windows.

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.
This page has 0 threads Add post