Tagged: Developer

25

Hide/Show Sections on a Document

I originally had this idea for a method to hide and show elements on the fly on a Document last year, but it didn’t quite work out.  The two major problems that prevented me...

14

Using Object Prompts with Documents

Object Prompts are incredibly useful objects that allow you to build some very dynamic experiences in MicroStrategy.  You can customize a report experience with them and alter the layout based on user input.  Unfortunately,...

11

Create Graph Popups with Javascript

I’ve previously written about Information Windows and how useful they can be for packing context and detailed information into your dashboard.  While very slick and useful, they unfortunately are limited in the ways you...

8

Advanced Metric Creation Tool

I’m a big fan of Conditional Metrics, especially since the passes they generate get merged when using the SQL Global Optimization VLDB Setting.  I find these types of metrics provide the most flexibility in...

3

Detecting Freeform SQL Reports

I’ve written about the merits of Freeform SQL reports before, and how they can become very useful in a pinch but with a few consequences.  For example, one of the great advantages of MicroStrategy...

42

Information Windows

One of the cooler features when the MicroStrategy Mobile iPad app launched was a new concept known as the Information Window.  It was originally demoed along side the mapping capabilities as a natural extension...

Implementing Slowly Changing Dimensions 14

Implementing Slowly Changing Dimensions

One of the characteristics of the Data Warehouse is that it stores more historical data than the transactional systems.  While this is traditionally in the form of years and years of old data, it...

8

Saved Prompt Answers

A feature that I don’t think gets a lot of press is the ability to save personal prompt answers.  This ability, in both Desktop and web, allows a user to store answers to a...