Bryan's BI Blog pushing what's possible

5

Detecting Incorrect Security in Production

Even the most seasoned administrator can run into unforeseen side effects with MicroStrategy Object Manager.  The scariest is wrangling object security.  Despite how careful you are or the defaults you’ve selected, it seems developers gaining full access to objects in production always seems to happen somehow.  One of my favorite tricks is getting a daily summary report from MicroStrategy Enterprise Manager that gives me basic...

77

Left Joins in MicroStrategy

An interesting stance by MicroStrategy is that they really push you for proper warehouse modeling (or at least what they consider proper).  At the same time, the tool’s flexibility can really handle just about any model, and I’ve seen the SQL Engine come through in some amazing scenarios where other vendors laughed and walked out.  One commonly requested feature is the ability to left join...

23

MicroStrategy Interview Questions

It seems like a tradition for MicroStrategy Blogs to post interview questions.  I’ve interviewed a lot of Developers and Architects, but giving them a quick version of a Certification Exam never really seemed prudent to me.  I’m less interested with their ability to recite textbook definitions and more about their thought process and competancies.  Here is a list of interview questions I always ask, my...

25

Using MicroStrategy Web Services for System Reliability Checks

A standard MicroStrategy Web installation comes with MicroStrategy Web Services which exposes some basic tasks for your consumption.  While not as powerful as any of the full featured SDKs, it does have two distinct advantages: 1) It’s free! and 2) It’s easier to use and get started with than the other SDKs. But what use can you make of it?  In my environments, utilizing Web...

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...