Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • MicroStrategy Quick Start Guide
  • Toc
  • feedback
MicroStrategy Quick Start Guide

MicroStrategy Quick Start Guide

By : Rivero Esqueda
5 (1)
close
MicroStrategy Quick Start Guide

MicroStrategy Quick Start Guide

5 (1)
By: 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 (10 chapters)
close

Improving Reporting Performance – MicroStrategy Cache


When a Report is executed, it goes through the cycle we described in Chapter 1, Architecture - Installing and Configuring MicroStrategy, (Refer to Intelligent Server Engines): SQL Generation-Query Execution-Results format and Crosstab. However, for both complex Reports and very large Result sets, this process could take time and resources each time the Report is executed. For scenarios where ad hoc reporting is not needed, the result set from a previously executed Report can be stored in what MicroStrategy calls a cache. When a user executes a Report, a cache is created within a file and the Intelligence Server loads the result set into its memory.  Report caching can be enabled either at the Project level or at the Report level.

Note

Ad hoc reporting involves Reports that require users to answer one or more Prompts. These are sometimes also known as OLAP Reports.

There are two otherobjects that generate caches too: Intelligent Cubes and...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
bookmark search playlist download font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete