Skip to main content


Showing posts from 2013

MicroStrategy - Setting the level of the view filter

While creating a dashboard in Desktop i came across a requirement where the view filter needs to be applied to the grid level, not the level of the data set which seems to be the default behavior. Here is how you can change it in MicroStrategy Web (based on the documentation):

Open your dashboard in Design Mode in MicroStrategy WebRight click on the grid to edit the view filter. Next to the filter you will see an arrow pointing up. If you hover over it gives you the info "Apply condition at the level of the report objects".Click on this arrow. It will change and point down. Hovering over it will say "Apply  condition at the grid level", which is what you want.
UPDATE: You can change the behavior in Desktop too. You have to right click on the info symbol to order to change the level. I did not expect that...
Have a great weekend!

MicroStrategy - Metric doesn't show in dashboard

Today I ran into an issue while moving a dashboard from our development environment to our testing environment and one of the metrics wouldn't show up, instead it would just show the name of the metric. I can imagine this is an issue that others might face too so here is my quick fix: Check the permissions for the metric.

You see below the metric doesn't show up, but all other ones, even from the same data set, work fine. I right clicked on the Metric and went to Properties -> Security and saw the perms where set to Administrator only. After changing it to allow the appropriate group to view the metric the dashboard displayed correct.

Derived Elements in MicroStrategy 9.3.1

I recently updated our development environment from MicroStrategy 9.2.1m to version 9.3.1. While testing if the update broke anything I found out that some of my attribute selectors are no longer working. All affected selectors used derived elements which were defined in the grid report - not in the dashboard.

If you run into the same issue try the following:

Remove derived elements from the grid reportOpen your dashboard in editable mode in the webAdd the attribute to your grid on the dashboardCreate derived elements in the dashboard. An example can be found in this technote.Create a selector from this attribute. Hope this helps.

MicroStrategy - Custom Formatting

My favorite blog on MicroStrategy is Bryan's MicroStrategy Blog. That's where I found a very helpful post on custom formatting which I have used a couple times.

The issue is the following: You have a metric that can contain very small and very large values. How can you make sure that the value is always useful for the user (10 Mio instead of 10,000,000 where you have to count the 0 to know what it is) and that it doesn't take too much space on the dashboard?

Products you don't expect to be 'Made in China' - Presidents Choice Organic Rice Rusks for babies

Yesterday I had a surprise once again while I was feeding our 9 months old sun "Risk Rusks". These are little rice crackers a baby can eat. I thought I did something good by buying organic and Presidents Choice is usually a decent brand but whenever I looked at the ingredients I saw the label "Made in China". Why on earth do we have to ship our baby food all the way from China? I guess I have to look for another brand for Risk Rusks now...

MicroStrategy - Show Null as Zero in Graph

The other day I was creating a dashboard that and one of the requirements was to show 0 in graphs if the value was Null. I searched the support forum and found this post but it didn't work. While looking through all the different graph options I finally found the one I needed. Under Options - Other you will find a drop down for "Use zero instead of null values". Set this value to Yes and your graph will work as expected :

Hope this helps someone else with the same issue.