GENERICDATA
Observe the Tables GENERICDIMENSION and GENERICFACT:

GENERICDIMENSION

question 37

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.
$$\begin{array} { l l l c } & E E 1 & E E 2 & E E 3 \\C C 1 & 200 & 400 & 0 \\C C 2 & 600 & 800 & 100\end{array}$$

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

---

Definitions:

Intercompany Transactions

Financial dealings between two or more entities within the same parent company structure.

Integrated Subsidiary

A subsidiary whose operations are closely intertwined with its parent company, sharing resources, processes, and management.

Foreign Exchange Gains

Profits resulting from changes in exchange rates affecting the value of assets, liabilities, or financial transactions denominated in a currency other than the entity's functional currency.

Wholly Owned Subsidiary

A subsidiary where the parent company owns 100% of the shares, giving it complete control over the subsidiary.