Summary

In this chapter, we learned about consolidations, which are made up of an ordered collection of consolidation elements; this is the grouping of attribute elements. It allows inter-row arithmetic operations. A custom group is made up of an ordered collection of custom group elements, which contains its own set of filtering qualifications, a special type of document that displays data and summarizes all the key metrics for business use. We learned about drill maps to view additional information after the report has been executed.

We also discussed Freeform SQL, which allows the creation of customized SQL for data retrieval from a database, and in-memory copying of data, which is used for fast reporting and data fetching, known as intelligent cubes. In the next chapter we will cover graphical techniques for presenting data for analysis using maps, graphs, and advanced charts. We will also discuss integrating third-party ESRI map tools with MicroStrategy for creating geo-based reports...