Author: bryan

Screen-Shot-2012-10-13-at-9.46.35-AM 13

Prompting a View Filter in a Cube Report

Here is a very valuable tip that not everyone is aware of.  While you normally can’t add prompts into the View Filter of your report, you can if you’re using a View Report, which is a report that is explicitly linked to an Intelligent Cube.  You can use existing Element and Expression Prompts in it’s View Filter,  which allows you to create prompted reports off of...

Screen-Shot-2012-10-13-at-9.22.18-AM 25

Hide/Show Sections on a Document

I originally had this idea for a method to hide and show elements on the fly on a Document last year, but it didn’t quite work out.  The two major problems that prevented me from using it in production were that I couldn’t find a way to have the object start out hidden, and once hidden it just left a gap or space instead of...

2012-09-15_20-52-56 14

Using Object Prompts with Documents

Object Prompts are incredibly useful objects that allow you to build some very dynamic experiences in MicroStrategy.  You can customize a report experience with them and alter the layout based on user input.  Unfortunately, it’s not very straightforward to use Object Prompts with Documents.  This is largely due to the Object Prompt being a property of the Grid Report that doesn’t get carried over into...

45

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. Search The headlining feature of this release is the...

Screen-Shot-2012-09-06-at-8.54.09-AM 11

Create Graph Popups with Javascript

I’ve previously written about Information Windows and how useful they can be for packing context and detailed information into your dashboard.  While very slick and useful, they unfortunately are limited in the ways you can use them.  Specifically, you can only call them from an attribute on a grid.  In one scenario recently, I had a grid that showed only metric values and I wanted...

Screen-Shot-2012-07-16-at-8.27.35-PM 8

Advanced Metric Creation Tool

I’m a big fan of Conditional Metrics, especially since the passes they generate get merged when using the SQL Global Optimization VLDB Setting.  I find these types of metrics provide the most flexibility in design without compromising performance.  One of the drawbacks though is that it can require a lot of redundant object creation that can become tedious.  Fortunately, MicroStrategy provided a simple little tool...

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

41

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

Screen-Shot-2012-04-24-at-8.58.58-PM 6

The Importance of Branding

Business Intelligence is much bigger than the application itself.  Driving user adoption is critical to it’s success, and the best way that I’ve found to do that is to create a Brand for your system.  Creating an identity and personality is important for increasing user confidence, building an image, and gaining mindshare with your users.  Don’t forget that you’re always competing against the manual analyst...