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

Performing Report manipulations


This section of the book will guide you through the main Report manipulations in a cookbook-exercise style.

Note

Manipulations (with the exception of drilling) are performed in memory and don't generate a new SQL. Therefore, the Report won't re-execute as a result of performing them.

Manipulation – Autostyle format

Objective/usefulness: To change a Report's color scheme, font types, alignment, and so on. Proceed as follows:

Execute My First Report | Grid menu | AutoStyle Selected |Agent. Your Report should turn blue and gray. Try a few different AutoStyles.

Manipulation – Grand total

Objective/usefulness: To provide summation of Metrics in the Report at the highest-possible level. Proceed as follows:

With the Report executed, press F11 | scroll to the bottom of the Report. You should see a grand total | press F11 again to remove it.

Manipulation – Subtotal

Objective/usefulness: To provide summation of Metrics in the Report at different aggregation levels. Proceed as...