Bryan's BI Blog pushing what's possible


Answering Prompts via URL API

MicroStrategy offers a lot of built in manipulations that can be performed directly within the URL.  This can provide a lot of benefits for seamlessly linking to MicroStrategy reports from either within MicroStrategy itself or from an external system.  Today I’ll highlight the most common and useful thing you can do in the URL: answering prompts using several different methods. The URL API may sound complicated, but...


9.2.1 Hotfix 1

Just a quick note that 9.2.1 Hotfix 1 is released.  (release notes). Minor bug fixes all around, with the biggest features being certification for Firefox 5 and Chrome 12 (sadly, Chrome 13 came out today .. just can’t keep up!) Additional certifications include SUSE Linux 11.1, Red Hat 6.1 and Blackberry OS 7


MicroStrategy Administrator iPhone App: Part 1

Since I first started in MicroStrategy, I really wanted the ability to administer the system from my mobile phone.  I’ve built applications to intelligently start/stop subscriptions based on system resources, ETL status, data integrity and monitor system availability, but no matter what I could do, it would inevitably lead to me having to email myself to take action.  And if I’m away from my desk...


Creating Training Videos

A classical problem is that you launch your BI initiative and do lots of hands on training and send your analysts out into the world.  They’ll retain some small fraction of what you’ve shown them (more than likely where the Export to Excel button is) and call you if they get stuck.  Eventually, everyone finds their place in BI and business moves along. The problem...


Extranet Project Filter

One nice feature with MicroStrategy Web is that you can point multiple web instances to a single IServer.  For example, if you have separate server implementations for Intranet and Extranet sites, you can manage them separately or load balance the web side while still utilizing the same physical IServer.  One consideration though is not all projects may be suitable for being exposed externally.  A classical...


Managing Job Priority with Report Cost

In my previous post, Managing Job Prioritization, I discussed different methods and reasons for handling multiple requests with limited resources.  Specifically, scenarios where you wouldn’t want to run reports “First In First Out”, but in a more intelligent manor (such as, Prompts go first, Subscriptions go last, everyone else in the middle).  There’s another option that can be used to control the order of things,...


Removing Sections of a Report via URL API

While working with the Web SDK to try to make a small customization, I stumbled on a pretty useful set of URL API codes that allow you to quickly modify the Report Page by removing various elements.  While such customizations are common, I wasn’t aware that they were available out of the box.  I would think that these would be very useful in doing simple...


MicroStrategy Gateway and MicroStrategy Cloud

At last week’s MicroStrategy World Europe event in Monte Carlo, MicroStrategy announced two new enterprise products. MicroStrategy Gateway integrates with Facebook and allows you to easily query and analyze against the richest customer information database ever built.  An iPhone app has already been created based on this technology and is available today for free as well as a free Facebook data mining service. MicroStrategy Cloud moves MicroStrategy...


Landing Page Part 2: Dynamic User Report Links

Following up on the post Creating a Portal Style Landing Page, you may want to add a little bit of dynamic flair to the page.  While you may or may not agree with the case I built for the advantages of Static / Manually maintained links, I think dynamic content can live side by side with it.  Today, I’ll discuss adding two panels to the...


Building a MicroStrategy Site Map

I once worked on a very large projet where there were so many users and reports, that the team decided to build and maintain a Site Map.  This provided users with the ability to quickly find reports and browse what they had access to overall.  This was a manually maintained Document, and as new reports rolled out they were considered for whether or not to...