118 • Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals
available. As I mentioned, the DBAG cautions that too many dynamic members
can negatively impact performance. e processor penalty may be desirable
over disk IO.
2. Eliminate large dimensions from consideration for inclusion in the dense block.
e objective in selecting dimensions is to pack the block as tightly with data as
possible. Density decreases as the size of the dimension increases. e measures
dimension is the exception to this rule.
3. Consider the measures and time period dimensions. Because many BSO data-
bases are nancially oriented, measures and time periods are probably good
candidates for the dense block. ese two dimensions when ...