Bryan's BI Blog pushing what's possible

1

Detecting Orphaned Objects in Production

One thing that has always annoyed me about MicroStrategy Object Manager is it’s insistence to migrate schema objects with even the slightest excuse.  In the same vein as Quantum Mechanics, “when things get small they get weird”, the same is true in the MicroStrategy metadata.  The Metadata Dependency table keeps all of the relationships between objects, for example, a Report is a parent of the...

2

Purging Element Caches with the Java SDK

The other day I had a requirement where I needed to give a single user access to clear Element Caches.  He didn’t have a Desktop license, but the permission to access the Caches isn’t tied to Desktop.  With a quick program written in Java using the MicroStrategy Java SDK, I was able to deploy a quick app to the user to execute a cache clear...

1

Participating in MicroStrategy Beta Programs

MicroStrategy offers access to Betas of upcoming releases to any existing customers that are interested.  While you can’t publicly talk about the features until they are Generally Available (GA), it does provide you with many benefits for you and your company.  Participation is totally free, and there are no obligations.  I’ve participated in every Beta since 8.1, and even gave a presentation at MicroStrategy World 2009 on...

5

Tracking Intelligent Cube Growth

One of the first concerns you may have after scheduling some Intelligent Cubes to update is their growth rate.  Each cube is not only loaded into memory, but also saved to disk, so managing their growth rate will have real impacts on system performance and stability.  If you haven’t made use of the 9.2 feature to roll off old data, then each time you add...

8

Passing Element Prompt Answers to Database Passthrough Functions

A common request is for the ability to use an element prompt to choose a month or day, and then based on that selection, choose a range such as a rolling months or rolling days.  The problem is that if you build out this prompt, ApplyComparison(“#0 in (select month from tblmonth where month >= #1”, Month@ID, ?Month), this would result in the SQL:  “a11.Month in...

4

Formatting Alternate Graph Bars in a Series

I had a requirement recently where I had a single metric on a bad graph that needed to use alternating colors for readability.  Unfortunately, the MicroStrategy Graph options for formatting a Series is limited to a single color.  Today I’ll share a quick trick on how I was able to work around it with Conditional Formatting to achieve the desired results.  This trick will also...

0

Adding an RSS News Feed to the Project Page

One of my favorite and yet easiest customizations is adding a News feed to the MicroStrategy entry point.  Ideally, this would be the first screen that a user sees after logging in.  A good fit for this requirement is the Projects page, even if you only have one project as there’s usually lots of empty space available.  Adding a News feed will allow you to...

13

Moving Subscriptions Between Users

I was once on a project in 8.x days where one group of users were responsible for managing the subscriptions for larger sets.  Most had anywhere between 10-20 subscriptions, and the largest were in the hundreds.  This was back in the Narrowcast days where the subscriptions metadata was separate from the IServer metadata, and the connection was loose at best.  When a person left or...

17

Exporting Flash Dashboards to PDF

Since the introduction of Flash Dashboards in 8.1, the only method of exporting them has been MHT.  This format is a container for a web page that keeps all of the files necessary for playing the animation (including the data to feed the dashboard).  The problem is that it’s only supported by Internet Explorer for reading, causes lots of security warnings or could even be...

9

Running Custom MicroStrategy Visualizations on the iPad: Part 1

The very first question I received after showing people my first custom visualization was “Can I run it on my iPad?“.  Surely, Mobile Business Intelligence is the hot item right now, and the fancier the visualization, the more it seems at home on an iPad for an equally fancy demo.  The feud between Apple and Adobe is legendary, and it seemed that as developers we...