Chapter 2. The First Steps in a MicroStrategy Project

In this chapter, we will cover:

  • Creating an empty project
  • Setting up a data warehouse connection and selecting tables
  • Modifying a table structure
  • Using logical tables to create custom views
  • Generating constants with SELECT statements

Introduction

At this point, you should have a testing machine ready-to-use with all the samples in place. In the previous chapter, we have learned how to install SQL Server and the MicroStrategy platform. In this chapter, we start creating the schema objects that represent the building blocks of our BI project.

Schema objects are the metadata components that are logically closer to the physical structure of the database; they are used to create more complex elements (applications ...

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.