SSAS - MULTIDIMENSIONAL EXERCISES▼
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.
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 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:
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.