The following factors need to be considered before specifying the available disk
space:
The query performance levels that you want
The number of cube models that you are optimizing for
How critical each cube model is
How frequently each cube model is used
The availability and cost of the disk space
Typically, you can see significant improvement by allowing a moderate amount of
disk space, such as 1% to 10% of the space currently used by the relational
tables that are referenced by the cube model. Table 4-4 shows the relationship
between the percentage of disk space used and the corresponding expected
performanc ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.