SSAS - MULTIDIMENSIONAL EXERCISES▼
SSAS - multidimensional | Cube actions exercise | Create a simple URL click-through
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.
Create an action so that when you right-click on the CentreType hierarchy members you see the following:
You should see this menu option when you right-click on a centre type
You'll need to choose the action's target type as Level Members.
When you choose the option shown above, it should take you to the search facility of the Wise Owl website:
Google, we're not!
Create another similar action so that when you right-click on Centre Id hiearchy members, you see the following:
The right menu caption is subtly different!
Save and close all open windows.