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

Drilling paths – Drill maps


 Drill Maps are Application Objects that provide navigation paths from a Report to levels of aggregation different from what is shown in the Report view or Template.

The following is a quick reference table for this MicroStrategy Object:

When a user executes a Report and right-clicks on any part of the view (a Template with data), three paths are shown by default:

  • Up: Shows any parent (or grandparent) Attribute from the one where the drill was initiated.
  • Down: Shows any child (or grandchild) Attribute from the one where the drill was initiated.
  • Other directions: Also known as Across. It will show all user-defined Hierarchies in the Project.

This behavior can be overwritten if a Custom Drill Map is associated with the Report. When a Drill Map is created, the developer decides what Attributes or Hierarchies are shown in each of the three mentioned paths (Up, Down, and Across). In addition, it is also possible to drill to an entirely different Template with diverse Attributes...