Category: MicroStrategy

17

Tagging Metric Formulas in Tooltips

A handy feature in MicroStrategy Web is the ability to show the description of an object as a Tooltip when you hover over it.  This can be a really useful way to get extra information on Metric in a report.  For example, you may add text to your Profit metric to say “Revenue – Cost” so that a user knows what the formula was.  I...

9

Metric Filtering: Report Filter or Report Limit?

The most common way of filtering a Report in MicroStrategy is via the Report Filter.  Anything placed into this filter appears in the SQL Statement that is sent to the database.  But what exactly happens to the SQL when you place a Metric in the Report Filter?  How does that compare to a Report Limit which also filters on Metric values?  Which is more efficient?...

98

Intelligent Cubes: Dynamic Sourcing vs View Reports

MicroStrategy 9 introduced a game changing feature in Intelligent Cubes.  Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried.  Traditional Report Caching in MicroStrategy is done on a matching basis.  The Intelligence Server checks to see if there is an existing cache for the same Report Template, Report Objects, Prompt Answers and User Security, and if a...

19

Getting Started with the Java Web SDK

MicroStrategy offers several SDKs, but two in particular kind of overlap: the iServer COM SDK and the Java Web SDK.  At first, it sounds like they are for two different things, but in reality they have long since been merging.  Desktop is effectively built from the IServer COM SDK, so anything you can do in Desktop, you can do using that SDK.  Web is built...

32

Getting MicroStrategy Data Into Your Control

MicroStrategy provides a very easy to use methodology for wiring controls in Flex to MicroStrategy Data.  They provide a model which represents the Grid that your Widget is ultimately tied to, and most of the out of the box controls can be wired to that widget by basically setting the modelKey=”ModelName”.  Like magic, the component will consume the data and populate itself without you having...

2

Proactive Alerting for Immediate Support

One thing that is critical in administering any system is alerts.  You never want to get a call from an end user to let you know that your system is down.  Not only does it make you look foolish, but now you have to scramble while users are waiting on you.  For critical alerting like “Is your machine running”, you’ll usually need to turn to...

36

Setting up a Flex Environment for Building MicroStrategy Widgets

As of MicroStrategy 8.1, you can build custom widgets and visualizations using Adobe Flex.  Today, I’ll walk through the steps to setup the environment and some of the issues I’ve run into in the past (as well as some common issues other’s have run into). Step 1: Obtaining the MicroStrategy Flex Plugin This ships with the MicroStrategy SDK, so you’ll need to own a license...

4

Welcome, a Brief Introduction

I wanted to start things off by first introducing myself and some of my qualifications.  I’ve been working with MicroStrategy for the last 6 years, fulfilling every role from Developer to Architect to working with all of the SDKs.  I feel like I have a lot of interesting nuggets of information on a topic that is sparsely documented, so I’d like to share.I’m currently a MicroStrategy...