Category: MicroStrategy

trigger 11

Triggering Cubes & Extracts

One of the functions that never seems to be included in BI tools is an easy way to kick off an application cache job once your ETL is finished.  MicroStrategy’s Cubes and Tableau’s Extracts both rely on manual or time based refresh schedules, but this leaves you in a position where your data will land in the database and you’ll either have a large gap before...

MicroStrategy vs Tableau 82

MicroStrategy vs Tableau

**DISCLAIMER** This post was written in May 2014, and so as it should be obvious, some parts of it are outdated.  I actually don’t use MicroStrategy or Tableau any more on a daily basis, so I’m not going to be able to update it.  I’m somewhat aware of both companies making some recent improvements that have addressed some of the weaknesses I talk about, but...

20

Creating Metrics in Bulk

Here’s a quick Command Manager script I wrote this morning when I had to create 60 metrics off of 60 Facts.  They were all simple Sum(Fact) Metrics.   //list all metrics in the project     String sProjectName = “PROJECT NAME”;   String sFactFolder = “\Schema Objects\Facts\Folder”;   String sMetricFolder = “\Public Objects\Metrics\Folder”;    ResultSet oFacts = executeCapture(“LIST ALL FACTS IN FOLDER ‘” + sFactFolder + “‘ FOR...

13

Moving Cubes

This is a hack, so proceed at your own risk!  I haven’t tested this or used it in a production environment, so things may break/crash/catch on fire. Say that you have built a really nice dashboard, deployed it to production, and everyone loves it.  This dashboard is based on a cube that takes an hour to load.  Now you’ve made modifications to the dashboard and...

Screen-Shot-2013-03-16-at-10.16.01-PM 9

Adding Interactive User Help with Intro.js

The other day I stumbled across this cool little JavaScript file called Intro.js that makes it really easy to provide user help in an interactive tutorial way.  I thought it would be a really cool thing to implement into some of my more complicated dashboards as opposed to the current technique of using tooltips or hoping that a user clicks on a wiki link to...

TN35767_TN35767_5 6

Embedding Instructions into Prompts

Sometimes, prompts can be complicated either in usage or in business implications.  While we can leave some notes for the user in the prompt description, sometimes it would be nice to be able to do a little more than that space provides.  Thanks to a tip from reader Arnold Slabbekoorn, here’s a method for embedding a popup with additional information directly into the prompt itself. Step 0...

39

Using jQuery in MicroStrategy Dashboards

I’ve written about a lot of cool things you can do with HTML Containers, but the best involve JavaScript because they add a new level of interaction to MicroStrategy.  Now it’s time to take that to the next level with jQuery, a free, open source library of functions that not only automate a ton of cool features for you but also whittles down the syntax...

tooltip_1 31

Fancy Tooltips with jQuery

Information Windows are a useful feature in MicroStrategy for adding context to your dashboard.  i’ve talked about alternatives before, but today I’ll talk about extending the functionality of Info Windows using jQuery to allow them to display as a tooltip replacement instead of only on click from grids.  In it’s modified state, we can display the Info Window from any location and not just from a...

pageby_1 18

Hiding Elements on the Page with jQuery

jQuery allows you to have total control over UI Components in MicroStrategy Web.  There’s really no end to what you can do and change, but one thing in particular that I’ve found to be very valuable is the ability to hide elements on the page.  This could be hiding sections, panels, or in the case of this post, page by drop downs or toolbar items....

inspect-element 7

Collapsible Sections with jQuery

I’ve previously posted about how to collapse sections using JavaScript in an HTML Container.  It’s a pretty cool trick, but the experience isn’t really that great because it’s jarring.  Also, the tax on the developer is high since you have to measure pixel perfect sections and deal with 0px height sections in your design mode.  Today, I’m going to show how to do this using...