Category: MicroStrategy

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 3

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

6

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