Chapter 3. Schema Objects – Attributes

In this chapter, we will cover:

  • Attribute forms – ID and DESC
  • Using functions in an attribute form
  • Parent-child relationship I
  • Parent-child relationship II
  • Other attribute forms
  • Selecting which forms are displayed
  • Building Data Explorer Hierarchies
  • Creating an attribute only report
  • Parent-child relationship in a report
  • Filters on attributes

Introduction

In every BI project, we find dimensions and facts. There is an extensive literature about data modeling if you want to look further into this topic; I personally like The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling by Ralph Kimball and Margy Ross; a very complete, yet simple-to-read manual.

We learned in the previous chapter that the metadata components ...

Get Business Intelligence with MicroStrategy Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.