You are building a sales analysis model. In this model there is no requirement for calculation. The user needs to aggregate data across all dimensions and wants to archive many years of data…

The correct answer is C. Aggregate Storage. Consider using the aggregate storage storage model if the following is true for your database: The database is sparse and has many dimensions, and/or the dimensions have many levels of The database is used primarily for read-only purposes, with few or no data updates. (C) The…

Reporting and Integrations

Question

You are building a sales analysis model. In this model there is no requirement for calculation. The user needs to aggregate data across all dimensions and wants to archive many years of data. Archived data will be analyzed once in while. What types of cube would you build using Essbase for this kind of requirement?

Options

ABlock Storage
BXOLAP
CAggregate Storage
DVirtual Cube

How the community answered

(44 responses)

A
5% (2)
B
11% (5)
C
80% (35)
D
5% (2)

Explanation

Consider using the aggregate storage storage model if the following is true for your database: *The database is sparse and has many dimensions, and/or the dimensions have many levels of *The database is used primarily for read-only purposes, with few or no data updates. (C) *The outline contains no formulas except in the dimension tagged as Accounts. *Calculation of the database is frequent, is based mainly on summation of the data, and does not rely on calculation

Topics

#Essbase#Aggregate Storage#Block Storage#cube design

Community Discussion

No community discussion yet for this question.

Full 1Z0-531 Practice