Tagged: 9.2

Screen-Shot-2012-07-07-at-9.07.36-PM 3

Detecting Freeform SQL Reports

I’ve written about the merits of Freeform SQL reports before, and how they can become very useful in a pinch but with a few consequences.  For example, one of the great advantages of MicroStrategy is that you can switch the underlying database platform without having to change anything except to tweak a couple of settings for performance.  Of course, that won’t apply to Freeform SQL reports...


Defaulting Element Selectors Using URL API

I’ve previously written about using the URL API to answer prompts of different types, but one feature that has been missing is the ability to default selectors using this method.  Being able to do so would open up some really cool use cases, such as linking between dashboards or linking from a subscribed email to a dashboard while keeping the context for the user. Well,...

Screen-Shot-2012-06-22-at-11.28.46-PM 42

Information Windows

One of the cooler features when the MicroStrategy Mobile iPad app launched was a new concept known as the Information Window.  It was originally demoed along side the mapping capabilities as a natural extension of drilling without having to slide out of view.  In 9.2.1, Information Windows made the jump to Documents in Web.  There’s a lot of really cool things you can do with...



Sometimes the speed of business can’t wait for the perfect model and information flows to feed it.  Or perhaps it’s just not practical to ship data around to and from multiple locations due to it’s size or timing.  Maybe you just need to do a proof of concept or to borrow a few bits from an operational system.  MicroStrategy’s Multisource feature aims to assist in...


Intelligent Cube Statistics Bug and Fix in 9.2

There were some new statistics added to Enterprise Manager in 9.2 for tracking Intelligent Cubes.  This new table, IS_CUBE_ACTION_FACT allows you to see (among other things) the size and rows of the Cube the last time it was loaded.  While I’ve talked about building a Cube Tracking Report before, that strategy doesn’t work when you introduce Incremental Refresh.  Since Incremental Refresh only pulls back a...


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


Google Map Widget

One of the eagerly anticipated features added to 9.2 was the addition of an out of the box Google Map Widget.  Well, not technically out of the box, but at least a provided plugin with easy to follow instructions for setting it up.  While the steps seem straight forward, I often see a lot of questions surrounding it.  There’s also a surprise waiting for you...


Changes to Object IDs in 9.2

While testing my 9.2.1 upgrade, I encountered quite a surprise.  It seems that in their continued effort to increase the performance of the metadata, MicroStrategy changed the way they store Object IDs, at least in SQL Server 2008.  Instead of storing the values as varchar(32), they are now stored as UniqueIdentifier.  Before you panic about your Reports and Documents with hardcoded Object ID links, they...


9.2.1 Feature Round Up

MicroStrategy released the latest update to their product suite, version 9.2.1.  This is a Service Pack release to the 9.2 platform and contains lots of fixes, but also a few new key features and rounds off the major announcements they made at MicroStrategy World 2011.  Today, I’ll highlight the big new features, and a few gems I’ve found along the way. Transaction ServicesThis is the...


Using MicroStrategy as a Historical Data Store with Intelligent Cubes

This is more of an idea I had and not something that I’ve tried or necessarily would even do, but hear me out.  Intelligent Cubes work by pulling data from the database and storing it in memory for fast access.  The idea is that the in memory indexes and slicing is much faster for small to medium sized data sets than hitting a database that...