Business Intelligence with MicroStrategy Cookbook
上QQ阅读APP看书,第一时间看更新

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)