9.3 Feature Roundup
MicroStrategy has just released a major update in the form of 9.3 that’s packed with some very exciting features. Unfortunately, I haven’t been able to spend as much time with this release as I have in past, but I did get a little look at it and below I’ll highlight the features I’m most excited about.
- Dynamic Metric Aliasing is a feature everyone has wanted at one time or another. It basically lets you put certain macros directly into your Metric aliases so that the column names can contain context specific values for display. For example, if you choose “2012” in a report prompt, you can now have a column labeled “2012 Revenue”.
- Derived Elements are now supported in all reports, not just View Reports. I feel that this will add tremendous value and greatly help with report flexibility since previously we would have had to rely on Consolidations or Custom Groups. Consolidations always have the problem of being difficult to maintain while Custom Groups generally cause poor performance. With Derived Elements, you get easy maintenance and fast in-memory processing.
- Parallel SQL Execution will allow independent passes in a multisource report run at the same time instead of sequentially. This is especially useful with multisource reports so that you can leverage multiple databases running simultaneously instead of waiting for one to finish before the next can start.
- Installation files are replaced by compartmentalized installed per product. This means if you need to install Desktop on a user’s machine, you don’t have to send them 3gb of files.
VI saw a huge upgrade in this release with lots of commonly requested features added including combining multiple visualizations in a single view, support for selectors, multiple datasets, themes, new export modes and overall a 30% speed improvement. It’s interesting to me to see how much VI is borrowing and loaning features to the core product and I wonder if it’s a matter of time before the two merge and this becomes the standard UI across all of MicroStrategy (just my conjecture).
Enhancements include automatic aggregation for Date and Geography dimensions. If your data only provides a Date or Zip Code, MicroStrategy can automatically provide Week/Month/Quarter/Year and City/State/Country attributes as well.
- Searchbox Selector is the feature that excites me the most. It’s basically a list box style selector, except instead of giving you a long, endlessly scrolling list of options, it gives you a simple search box that updates live as you type. This will let you build a cleaner UI but still provide the user the flexibility to explore the data on the fly.
- Filter Panels are a new type of object with some pretty cool special properties. This special type of Panel Stack can only contain Selectors and allows you to collapse the controls leaving a short summary of the current view.
- Synchronized Drilling allows you to have multiple grids/graphs on a Dashboard, and drilling on one will cause the other linked ones to drill. This is not the same as a Selector which always allowed you to target multiple objects, but actually drilling inside a grid or graph.
- Google Maps integration gets a really cool feature called Density Maps, which are basically Geo Heat Maps and will allow you to create some really cool looking maps in your Dashboards.
- Bursting allows you to subscribe to a single report but slice it’s pages out into separate files. While Narrowcast also supports using this method to send emails, it appears that Distribution Services is only supporting file exports for now, but at least the foundation is there.
- Dynamic Recipient Lists were a life saving feature in Narrowcast if you ever needed it, and now it makes a welcome appearance in Distribution Services. This allows you to maintain a list of recipients in a database table instead of manually creating all of the subscriptions.
- R is a fast growing statistical programming language that now gets direct integration into MicroStrategy. This enables an analyst to quickly feed analyses from R directly into MicroStrategy Reports. You can grab the plugin from codeplex.
- R generated graphs can be displayed directly in Dashboards.
- A Network Visualization Widget was added to the visualization library and it allows you to visualize relationships between lots of elements in Flash.