We can
visualize an array of reporting capabilities at this point, once we add
formatting, subtotal and other nuances. For now, we will conclude our article,
having focused upon the construction of one approach to the creation of an
aging capability, using Named Calculations to extend the data underlying
our cube to afford us a presentation capability that we might not otherwise
have had.

19. Examine other features of the Aged
Period dimension within the Cube Browser as desired.

20. Select File --> Save All from the main menu, to save our
work through this point, as depicted in Illustration 54.

Illustration 54: Saving Our Work
from the Session

21. Select File --> Exit, when ready, to leave the Business
Intelligence Development Studio.

Conclusion

In
this "second half" of a two-part article, we continued the
examination of Named Calculations we began in Mastering Enterprise BI: Extend the Data Source with Named
Calculations, Pt. I.
We briefly summarized our introduction in Part I, where we focused initially upon the Data Source View as a significant design
and development enhancement within Analysis Services, and then overviewed our stated objective to examine
Named Calculations. Moreover, we reviewed our initial steps in the
construction of working examples, based upon an illustrative business need to
create "aging buckets" within our cube to support a reporting and
analysis capability.

In
this article, we returned to the Named Calculations we had created in Part I, and next created a Cube containing data from our sample
relational tables. We then added a Dimension based upon two of our Named
Calculations, to contain "aging buckets. We reviewed our new Aged
Periods dimension to ascertain that its structure appeared as expected, and
then we deployed our solution, and processed our cube. Finally, we browsed the
Cube, focusing on the new aging dimension structures, to verify their
operation within the design environment.