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...
Category: MicroStrategy
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,...
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...
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...
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...
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...
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...
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...
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...
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...