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

Dynamic filtering and report creation – Prompts


 Prompts are the most versatile Application objects in MicroStrategy since they provide flexibility to customize the SQL sent to the database, based on a user response to a question that is presented before Report execution.

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

 

Basically, when a Prompt is inserted in an object, MicroStrategy placesa wildcard on the corresponding portion of the SQL. After this when the user responds to the Prompt, that unknown SQL gets replaced accordingly.

Understanding types of Prompts

To better understand Prompts, it is necessary to explain the different types. Their type will determine what objects can be used to build them and how and where to use them.

  1. Filter definition prompt:
  • What is it for? To dynamically create a Filter based on the user response
  • What is made of? A Filter definition on a Hierarchy, Attribute, Metric, or by directly picking Attribute elements
  • Where can it be used? Since it...