Knowledge check

To review your knowledge of this chapter, here are a few questions that this chapter’s material will help you answer. The questions that have been selected aren’t intended to trick you but to provide you with a learning benchmark to give you a foundational understanding to help prepare you for the exam. The answers are marked in italics:

1. Which items can be used in a calculation (select all that apply)?
   1. Groups
   2. Bins
   3. Sets
   4. Parameters
2. What is something you cannot do with a hierarchy of three fields (select the correct answer)?
   1. Select the plus sign from the top of the hierarchy on the header of the dimension using the hierarchy.
   2. Rearrange the fields in the hierarchy by manually dragging fields within the hierarchy.
   3. Give the name of a hierarchy its own field (e.g., use the hierarchy’s name in a calculation).
   4. Remove one member from the hierarchy so that two fields remain.