GENERICDATA
Observe the Tables GENERICDIMENSION and GENERICFACT:

GENERICDIMENSION

question 3

Multiple Choice

GENERICDATA
Observe the tables GENERICDIMENSION and GENERICFACT:

GENERICDIMENSION
$\begin{array} { l l l l l l } A A & B B & C C & D D & E E & F F \\ A A 1 & B B 1 & C C 1 & D D 1 & E E 1 & F F 1 \\ A A 2 & B B 2 & C C 1 & D D 2 & E E 2 & F F 1 \\ A A 3 & B B 3 & C C 2 & D D 3 & E E 1 & F F 1 \\ A A 4 & B B 4 & C C 2 & D D 4 & E E 2 & F F 1 \\ A A 5 & B B 5 & C C 2 & D D 5 & E E 3 & F F 1 \end{array}$
GENERICFACT
$\begin{array} { l c c } \text { AA } & \ldots & \text { Number } \\ \text { AA1 } & \ldots & 100 \\ \text { AA1 } & \ldots & 100 \\ A A 2 & \ldots & 200 \\ \text { AA2 } & \ldots & 200 \\ A A 3 & \ldots & 300 \\ A A 3 & \ldots & 300 \\ A A 4 & \ldots & 400 \\ A A 4 & \ldots & 400 \\ \text { AA5 } & \ldots & 100 \end{array}$ Assume the following two hierarchies exist in the table GENERICDIMENSION:
AA --> BB --> CC
AA --> DD --> EE --> FF
Assume the following result table was created using the OLAP/BI Tool:

GENERICOLAPRESULT1
$$\begin{array} { l r l } & C C 1 & C C 2 \\E E 1 & 200 & 600 \\E E 2 & 400 & 800 \\E E 3 & 0 & 100\end{array}$$
This scenario will be used for the following questions citing GENERICDATA.



-The result table below is the result of a ________ action on the GENERICOLAPRESULT1 result table.
$E E 1$
$\begin{array} { l l } \mathrm { CC } 1 & 200 \\ \mathrm { CC } 2 & 600 \end{array}$
EE2
$\begin{array} { l l } \mathrm { CC } 1 & 400 \\ \mathrm { CC } 2 & 800 \end{array}$
EE3
$\begin{array} { r r } C C 1 & 0 \\ C C 2 & 100 \end{array}$

• A)Slice and dice
• B)Pivot
• C)Drill-up
• D)Drill-down