Book Image

MicroStrategy Quick Start Guide

By : Fernando Carlos Rivero Esqueda
Book Image

MicroStrategy Quick Start Guide

By: Fernando Carlos Rivero Esqueda

Overview of this book

MicroStrategy is an enterprise business intelligence application. It turns data into reports for making and executing key organization decisions. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. It takes you from setting up and configuring MicroStrategy to security and administration. The book starts by detailing the different components of the MicroStrategy platform, and the key concepts of Metadata and Project Source. You will then install and configure MicroStrategy and lay down the foundations for building MicroStrategy BI solutions. By learning about objects and different object types, you will develop a strong understanding of the MicroStrategy Schema and Public Objects. With these MicroStrategy objects, you will enhance and scale your BI and Analytics solutions. Finally, you will learn about the administration, security, and monitoring of your BI solution.
Table of Contents (17 chapters)
Title Page
Copyright and Credits
Dedication
Packt Upsell
Foreword
Contributors
Preface
Index

Your building blocks – Schema Objects


The MicroStrategy Schema Objects are going to be the foundation of any project. These objects serve as building blocks on which other objects will be erected. Generally speaking, Schema Objects are mapped to database structures such as tables or columns with a few exceptions in which other Schema Objects are used as part of their components. Usually, there is only one person at a time creating or modifying Schema Objects. This person is called the project Architect. It is not recommended to have multiple persons modifying Schema Objects since this could lead to metadata inconsistencies and eventually corruption. Once any change has been performed to a schema object, it is necessary to commit this change into the metadata. To do so the Architect must Update Schema.

Exercise – updating Schema

It is very important to update the project's Schema every time there is a Schema Object change, addition, or deletion. In this exercise, you will learn how to update...