All posts by Sorin Suciu

About Sorin Suciu

Sorin is a MicroStrategy specialist, experienced in Retail, Telecom and Customer Operations. Blogging is where his passion for writing met his geek nature and decided they should do some crazy things together. Though not a funny guy himself, he is obsessed with arguably funny stuff, such as Terry Pratchett, Monty Python, Douglas Adams and live parrots.

Report Data Options in version MicroStrategy 9

You know how, after you execute a report, every time you make a change to the Report Data Options the report gets re-executed in order to apply those changes?
Well, in version 9 (not sure about 9.01 yet) this doesn’t happen for the Metric Join Type and Attribute Join Type options. I don’t know if this is a bug or a feature, though the behaviour appears to be intended by the developers. If someone from MicroStrategy is reading this, please provide some background details.
The downside of this is, of course, that if you are debugging a report by modifying one of those options, you might get the idea that your change had no effect whatsoever. This is because you were used with automatic re-execution after you pressed OK, as in the previous versions.

Microcharts as Tree View Selector

Apparently this functionality has been there for quite a while, but I only chanced upon it recently.
Microcharts are not only an awesome way of displaying tons of data in a meaningful way, but they can also be used as a tree view selector. Try to imagine how would it be to use a combination of drop down selectors (each in its own panel, with complex targeting), and you will see why the tree view is so much better.

Here is how to do it:

The tree view can have up to three levels, which means you can have a total of three attributes before the dummy one. You need a dummy attribute (can be Year, or whatever) and a couple of dummy metrics, in order to have the widget render.
You also have to use one of the attributes (preferably the lowest grain) as a selector for other panels.

Have fun with it!