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

Reusing your report designs – Templates


In the previous section, you learned how to create a Report and that its definition is made of one Template and one or more Filters.

The following is a quick reference table for MicroStrategy Templates:

The Template is an Application Object that organizes the information in a certain way (provides a layout) with a specific formatting (colors, fonts, numbers, percentages, and so on) within the Report. Most of the time, Templates are created locally to the Report (embedded), but if the developer wants to reuse a Template, it can be created externally.

The two most common objects used to build Templates are Attributes, which provide the business context, and the Metrics, which provide the aggregation and the business measure. However, we will see in subsequent chapters that other more advanced objects could also be used, such as Prompts and Custom Groups.

Note

The Template will determine the SELECT/FROM clause in the SQL that MicroStrategy sends to the database...