Latest from Pandera Systems

Leaders in Enterprise Decision Automation®.


3 ways that Enterprise Manager Does Your Job for You.

If you’re not leveraging MicroStrategy Enterprise Manager, you are truly missing out on easy improvements to your MicroStrategy implementation. It’s easy to turn on, costs nothing, and does your job for you in three major ways:

1. It tells you exactly how successful your project is.

Enterprise Manager holds all the statistics for you. Measure successful user adoption by the hard facts of how many times a dashboard ran, how many distinct users ran it, and the timing and performance of those renderings.

With Enterprise Manager, it’s easy to build a report that tells you how many of your MicroStrategy reports have run monthly over the last two years, for example. You can filter out scheduled jobs, certain reports, or even executions by specific users to ensure BI Testers are not spiking your results.

Enterprise Manager provides the evidence for MicroStrategy’s contribution to data-driven decision-making.

2. It tells you how to prioritize development efforts.

The BI Team’s attention is always in high demand. When prioritizing which development effort should come next, there’s no better justification for ranking than users’ history (see below for a quick how-to).

Enterprise manager makes it possible to measure the change in user behavior for any time periods. If your team squeezed a 200 hour development effort into last sprint with go-live on March 1, it is extremely powerful to analyze whether the effort was matched by customers who actually utilized the deliverable. Enterprise manager can tell you if that is the case.
Reward those who value your team’s effort, and present the case for prioritization with Enterprise Manager.

3. It tells you how to speed up performance.

Analyze which reports lag in the database and how frequently they’re used. Let that information be your guide when creating MSTR Intelligent Cubes and condensing datasets. If a prompted report is the driver of the issue, then consider a cube with a prompt.

Alternatively, find weekly reports where the cache is cleared daily, and redefine the caching strategy to match the weekly grain of the report.

In short, use enterprise manager to effectively avoid hitting the database with redundant queries for large result sets, and make everyone happier from database admins to end users.


Interested in learning more about Enterprise Manager?

Pandera is offering a new one-day online course that covers all you need need to know about how to maximize your use of Enterprise Manager. We currently have openings for the course on April 1, May 11, and July 1. If you’re interested in attending, get in touch with us at


How to build a user history report

To expand on number 2 above, you can build a report that tells exactly how many times users ran the document you created in a specific timeframe, as well as how many distinct users utilized it. Use the following steps to do so:

1. Place the following objects on the rows, columns, and page-by:

  • Schema Objects/Attributes/Application Objects/Document
  • Schema Objects/Attributes/Date/Day
  • Public Objects/Metrics/Document Processing Analysis/DP Number of Jobs
  • Public Objects/Metrics/Document Processing Analysis/DP Number of Jobs with Cache Hit
  • Public Objects/Metrics/Document Processing Analysis/DP User Count

2. Create a filter utilizing the following objects:

  • Schema Objects/Attributes/Application Objects/Document
  • Schema Objects/Attributes/Date/Day

3. Run it!

Here’s what that report would look like in design mode:


The following two tabs change content below.
Re-engineering decision-making environments to mobilize business intelligence and immerse employees in knowledge, producing peak performance and ongoing success.