Business Intelligence with MicroStrategy Cookbook

Chapter 4. Objects – Facts and Metrics

In this chapter, we will cover:

• Creating a simple counter fact and metric
• Using the SQL view to inspect SELECT statements
• Understanding the GROUP BY clause
• Adding more facts
• Filters on metrics
• Creating ranking metrics
• Grouping at a different level (level metrics)
• Embedding filters inside metrics
• Using Metric Join Type in reports
• Creating a previous month metric (transformation)

Introduction

It's time to produce some numbers. In our BI journey, we have walked through the installation, configuration, and creation of a project, and there was not a single number involved. I appreciate your patience reading the first few chapters; now we start looking at what the reports look like and where the results come from. Because, ...