Explanation:Reference dimensions are materialized and added as regular dimensions. 4. _________ statement is used to write back data to any cell in a cube that aggregates to its parent using the SUM aggregation.
A. UPDATE CUBE
B. DELETE CUBE
C. ALTER CUBE
D. None of the mentioned
Answer:A
Explanation:Reference dimensions are materialized and added as regular dimensions. 4. _________ statement is used to write back data to any cell in a cube that aggregates to its parent using the SUM aggregation.
A. UPDATE CUBE B. DELETE CUBE C. ALTER CUBE D. None of the mentioned
Explanation:You can update the value of a specified leaf or nonleaf cell in a cube, optionally allocating the value for a specified non-leaf cell across dependent leaf cells. 5. Point out the wrong statement :