MicroStrategy Report Optimization: Introduction

Readers:

I have received an e-mail from a reader that wanted me to discuss how to optimize MicroStrategy Reports.

I think this is an excellent topic and will today start a new blog topic called MicroStrategy Report Optimization. This will be a multi-part series (I will leave it open-ended so I can continue to add to it).

Before we start the series, it is important to understand report execution flow in MicroStrategy. That is what I will start with today.

Best Regards,

Michael

Source: MicroStrategy University, Deploying MicroStrategy High Performance BI, V9.3.1, MicroStrategy, Inc. September, 2013.

Report Execution Flow

To better understand how some of the components affect the report performance in a MicroStrategy environment, it is important to become familiar with the report execution flow.

The following image depicts the different steps involved in the report execution process.

Report Execution Flow

The following steps and components are involved in the report execution flow.

Report Execution Flow Steps

 

3 thoughts on “MicroStrategy Report Optimization: Introduction

  1. Also we can create indexes on commonly used column in database to improve report performance.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.