Mastering Business Intelligence with MicroStrategy
by Dmitry Anoshin, Himani Rana, Ning Ma, Neil Mehta
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 ...
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.
Read now
Unlock full access