260 • Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals
4 and 6, the two [1st Half] and [2nd Half] Views, then which could be used to compute
View 18? Of the four remaining Views in the list enumerated in the paragraph above,
View 10 is the smallest. It should be noted that View 15 at .373747 Mb is almost nine times
larger than View 4. If the [1st Half] and [2nd Half] are queried 1/9 or less as oen, it prob-
ably pays not to create the “Half” views. Note that View 10 is a View at the “Qtr” level.
Because a query that would have run against View 18 still can be run from another
Aggregated View that is not at level-2 (the Half level), it still can perform well. You do
not always need the most optimal View ...