Business Intelligence with MicroStrategy Cookbook

Chapter 5. Data Display and Manipulation – Reports

In this chapter, we will cover:

• Going deeper into data with drill down
• Manipulating grids – Pivot and page-by
• Dynamically adding and removing objects in reports
• The bottom line – customizing subtotals
• Avoiding missteps – NULL values in facts
• Sorting data in grids
• Emphasizing numbers with conditional formatting
• Printing and exporting reports
• Restricting results with view filters

Introduction

In the previous chapter, we learned how to create different facts and metrics: if you endured the exercises until now, you won the title of "The Fact and the Furious" (as a colleague of mine likes to say…); so we can go on and have a deeper look at how to modify reports and enrich the data.

Before we continue, I'd like ...