Solved

GENERICDATA
Observe the Tables GENERICDIMENSION and GENERICFACT:

GENERICDIMENSION

Question 6

Multiple Choice

GENERICDATA
Observe the tables GENERICDIMENSION and GENERICFACT:

GENERICDIMENSION
AABBCCDDEEFFAA1BB1CC1DD1EE1FF1AA2BB2CC1DD2EE2FF1AA3BB3CC2DD3EE1FF1AA4BB4CC2DD4EE2FF1AA5BB5CC2DD5EE3FF1\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
 AA  Number  AA1 100 AA1 100AA2200 AA2 200AA3300AA3300AA4400AA4400 AA5 100\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
CC1CC2EE1200600EE2400800EE30100\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.
CC1CC2FF16001500\begin{array} { r r r } & \mathcal { C C 1 } & \mathcal { C C } 2 \\F F 1 & 600 & 1500\end{array}


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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents