Online Course Support

4. Question 4 How many members does the Department dimension have? 1 point   9   5   1   7   3

3. Question 3 How many members does the Region dimension have? 1 point   2   4   3   5   1

2. Question 2 How many measure(s) is/are in the cube? 1 point   3   5   4   2   1

1. Question 1 How many dimension(s) is/are in the cube? 1 point   4   2   3   1   5

4. Question 4 What is the February Average Sales Amount of the No Discount promotion for all currencies? Note that February is the third column as WebPivotTable may not render…

3. Question 3 How many levels are in the Delivery Date.Month of Year dimension excluding All? 1 point   1 2 3 4

13. Question 13 Identify the dimension expansion shown in the Rows of the snapshot for part 3. 1 point   New Product -> Touring-3000 Promotion   Seasonal Discount -> Sport…

9. Question 9 What is the July Average Sales Amount of Volume Discount for the Euro Currency as a source currency? July is the eighth column in the pivot table….

7. Question 7 What is the Average Sales Amount of Discontinued Product for the USA and Canadian dollars as source currencies in all periods? 1 point   $2,667.13   $3,627.81…

6. Question 6 What is the Average Sales Amount of Resller promotions for the USA and Canadian dollars as source currencies in January? 1 point   $4,999.50   $2,667.13  …