Version 2021

Project Design Guide

The MicroStrategy Project Design Guide provides comprehensive information on planning, creating, and modifying a project in MicroStrategy and covers a wide range of project-related topics, including the following:

BI Architecture and the MicroStrategy Platform, provides an introduction to business intelligence architecture and some of the main components within the MicroStrategy platform.
The Logical Data Model, explores logical data modeling and how it can help you identify the different elements within your business data and plan your project.
Warehouse Structure for Your Logical Data Model, describes components of the physical warehouse schema such as columns and tables and explores how you can map components from the logical data model to components in the database to form the physical warehouse schema.
Creating and Configuring a Project, describes the major components involved in project creation and guides you through the process of creating a project in MicroStrategy.
Creating a Project Using Architect, guides you through the process of creating a project in MicroStrategy using Architect.
The Building Blocks of Business Data: Facts, describes the structure of facts and explores different types of facts and how they relate to your business data. This chapter also covers all the steps necessary to create facts for your project.
The Context of Your Business Data: Attributes, provides a conceptual look at the structure of attributes and explores different types of attributes and how they relate to your business data. This chapter also covers all the steps necessary to create attributes for your project.
Creating Hierarchies to Organize and Browse Attributes, discusses the different types of hierarchies in MicroStrategy, and explains how you can create user hierarchies to help organize and enhance your project.
Optimizing and Maintaining Your Project, describes methods you can implement to better optimize and maintain your project for both the short and long term.
Creating Transformations to Define Time-Based and Other Comparisons, discusses the different types of transformations in MicroStrategy and describes how you can create transformations in your project.
Designing a Project for Financial Reporting, provides a step-by-step example of using your own data to design a project for financial reporting and analysis, including profit and loss reporting.

The appendixes contain the following additional reference information, which you may or may not require depending on your specific needs:

MicroStrategy Tutorial, provides information on the MicroStrategy Tutorial project, which includes a metadata and warehouse, and a set of demonstration applications designed to illustrate the features of the MicroStrategy platform.
Logical Tables, discusses logical tables, the different types of logical tables, and how to create logical tables and views in MicroStrategy.
Data Types, provides information about the different data types in MicroStrategy.

Information on integrating MicroStrategy with your MDX Cube sources such as SAP BW, Microsoft Analysis Services, and Hyperion Essbase is provided in the MDX Cube Reporting Help.