Tagged: Developer

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

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

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

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

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

8

The Hidden Cost of the History List

The History List is one of my favorite features in MicroStrategy.  It can be convenient to quickly jump back to a previously run report and handy to retrieve a long running report later instead of having to wait around for it.  Instinctively, I’ve always used the “Automatically send reports to the History List” setting, because why not?  Well, as I recently discovered, there’s actually a...

2012-09-15_21-27-58 5

Hacking an Object Prompt into a Metric on a View Report

I think I’ve done some pretty crazy things in MicroStrategy.  It’s a lot of fun to push the limits of the tool and use it in ways that it wasn’t originally designed for.  Today, I think I’ve pushed it farther than I ever have before in terms of just how crazy this post is.  Surely, other things I’ve done probably have more usefulness and provide...

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