Bryan's BI Blog pushing what's possible

6

Real Time Job Monitor in Java

One thing that has always annoyed me in MicroStrategy is that the Job Monitor requires a manual refresh.  Sometimes when debugging issues, request come through so quickly, I have to sit there and spam the refresh button to catch a glimpse.  I could always look at the execution log in Enterprise Manager, but that’s usually less efficient.  Today I’ll share a quick Java application I...

34

Consolitdations vs Custom Groups

At MicroStrategy World 2011, my ETL/DBA colleague attended to gain a better perspective of where MicroStrategy fits in.  One of his comments struck me when he said he was pleasantly surprised that through the entire conference including all of the High Performance sessions, MicroStrategy always took the position of tweaking their side as opposed to pushing things to the database.  While it may seem obvious...

3

Find and Replace Object Dependencies

There was a very small feature introduced in MicroStrategy 9.0 with a very huge impact to the project I was working on at the time.  The feature was buried and undocumented, and I only knew about it because it was an enhancement request I had logged a year or so prior.  Even then I had trouble finding it, and technical support wasn’t even aware of...

7

Upgrading From Flex Builder 3 to Flash Builder 4

MicroStrategy 9.2 includes the Visualization Plugin for Flash Builder 4.  If you can obtain a copy (say, from a test environment), you can still use it against an older version of MicroStrategy.  The changes in the plugin are simply related to interfacing with Flash Builder 4 and have no consequence on the actual version of your MicroStrategy implementation.  Today I’ll walk through my upgrade experience...

9

9.2 Feature Round Up

MicroStrategy released version 9.2 yesterday and it’s currently available from the Download site.  I’ve been fortunate enough to work with the beta for a little over a month now, and I can say that in my experience of previous betas, this one was extremely stable even considering all of the new features added.  I didn’t run into any upgrade issues or compatibility issues, and all...

Screen-shot-2011-03-28-at-9.47.17-PM 30

Getting Started with MicroStrategy TaskProc

The MicroStrategy Task Processor is a light weight interface for performing basic events over the web.  It’s an easier API to interface with than Web Services, but doesn’t come with all of the features.  If you just need a quick administrative task or just need the results of a basic report, it can be easier to get off the ground than Web Services or Java...

ie1 1

Configuring Web Browsers for Automatic Authentication

Here’s a trick that I’ve found not that many people are aware of.  If you use Windows Authentication for your security, your users may be prompted with a login box when accessing MicroStrategy.  While they can type in their network credentials into this box, this acts as a saved password.  When the user changes their network password at regular intervals, this can then result in...

1

Making Your Widget Resize Dynamically

UPDATE: Check out A Better Way To Zoom Your Custom Widgets. If you’ve hand drawn a widget, one of the first problems you’ll run into is handling different resolutions.  It can be a daunting task after producing your first custom visualization, but it’s actually not too bad.  The main thing you’ll want to consider is relative positions to the controls width and height, and be...

2

Basic Graphics and Animation in Flex

One thing I’ve been spending a lot of time with these days is the Visualization SDK.  The MicroStrategy samples primarily talk about wiring MicroStrategy controls in your visualizations.  While those make good tutorials, it seems to me that if you wanted to use MicroStrategy controls, you wouldn’t need to use the Visualization SDK.  For me, I go to Flex when I need to build something...

6

Disabling All Schedules and Users with Command Manager

Today I’ll share two handy MicroStrategy Command Manager scripts I use quite often during upgrade testing.  When preparing for an upgrade, you’ll need to create a test copy of your metadata.  But  you may run into two problems: If you use Time Based schedules, they’re still active and could either email users or at least waste time processing during production schedules.   If you’re on...