The Source Currency dimension can be used as both a field in the Rows and Filters areas.
12. Question 12 The Source Currency dimension can be used as both a field in the Rows and Filters areas. 1 point True False
-
-
What changes occur in the MDX SELECT statement when a filter condition is added to a pivot table specification such as from Part 2 to Part 3 of the WebPivotTable assignment?
11. Question 11 What changes occur in the MDX SELECT statement when a filter condition is added to a pivot table specification such as from Part 2 to Part 3…
-
New post
10. Question 10 For a given cell, indicate the change in Average Sales Amount in a given cell (such as No Discount in the rows and January in the columns)…
-
How many levels are in the Promotions dimension excluding All?
1. Question 1 How many levels are in the Promotions dimension excluding All? 1 point 1 2 3 4
-
What is the February Average Sales Amount of No Discount promotion for the Euro Currency as a source currency? February is the third column in the pivot table.
8. Question 8 What is the February Average Sales Amount of No Discount promotion for the Euro Currency as a source currency? February is the third column in the pivot…
-
What is the Average Sales Amount across all periods and currencies for Mountain-100 Clearance Sale in the Reseller -> Discontinued Product items?
5. Question 5 What is the Average Sales Amount across all periods and currencies for Mountain-100 Clearance Sale in the Reseller -> Discontinued Product items? 1 point $3,590.42 $10,455.32…
-
What is the hierarchical ordering of levels in the Promotions dimension from coarsest (least detailed) to finest (most detailed)?
2. Question 2 What is the hierarchical ordering of levels in the Promotions dimension from coarsest (least detailed) to finest (most detailed)? 1 point Category-Promotion Category-Type-Promotion Category-Type-Subcategory Product-Subcategory-Type
-
To combine multiple dimensions on an axis,
7. Question 7 To combine multiple dimensions on an axis, 1 point a crossjoin operator must be used. a nested SELECT must be used. the WHERE clause…
-
In an MDX statement, a slicer is specified in which clause
6. Question 6 In an MDX statement, a slicer is specified in which clause 1 point FROM Nested SELECT statements SELECT WHERE
-
What is a measure in a data cube?
1. Question 1 What is a measure in a data cube? 1 point Number of rows or columns Subject label for a row or column …