Category: MicroStrategy

Ask Bryan

SUPPORT DISCONTINUED Unfortunately, I don’t have the time or energy to continue providing this support service.  It’s been fun and I’ve met a lot of interesting people and learned a lot of things myself, but I can’t keep up with it anymore.  This will also apply to comments in this post (they’re locked now).  I’ll try to still reply to topical clarification questions on other...

2

A Better Way To Zoom Your Custom Widgets

One common issue I’ve had when deploying widgets and visualizations is handling scaling for different resolutions.  I wrote a post a long time ago (one of my first) about the subject in which I detected the size change, cleared the screen and just redrew everything based on the new scale.  This worked fined when my widgets were simple, but as they’ve grown more and more...

3-1-2012-9-50-09-PM 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 prompt under their profile.  I think this is an important feature to enable, especially if you use a lot of element prompts on large dimensions.  Loading a prompt answer from this...

44

Automatic Export via URL API

The URL API can give you a lot of flexibility in designing report interactions.  I’ve previously talked about using it to Answer Prompts to simulate drill downs from Documents, customize the layout by Removing Sections, or providing links to Reports and Folders as a Landing Page.  Today, I’ll talk about how you can use the URL API to setup export defaults for a variety of formats....

Bryan 65

Building Your Own Custom Map

The MicroStrategy Area Mashup widget is a handy (and free!) Widget for adding a simple map to your Report or Dashboard.  This serves as a nice alternative to using full fledged Google Maps or ESRI.  The widget itself has undergone a lot of changes in each version, and the 9.2.1 release removed (and added) many hoops we had to jump through to use this widget in previous...

18

Database Passthrough Functions

MicroStrategy’s unquestionable strength is it’s SQL Engine.  The ability to define an object layer over your data that empowers end users with no technical knowledge of the data structure to build any report is truly remarkable.  Of course, it’s still just a set of options, and while it accomplishes probably 90% of use caes that you’d ever need, there’s still some room left for cases that it...

TN5200-8X-2439_7 5

Data Mining Services

Data Mining Services is perhaps MicroStrategy’s best kept secret.  It’s a powerful set of tools and functions built right into the product that offers advanced statistic report capability including predictive analytics, market basket analysis, networking and trending.  This functionality is free and is included out of the box.  There’s no additional software needed and no special permissions to use it.  Since it’s not sold separately,...

compare 3

Recommended Tools

I wanted to share some tools I use in my day to day work that make my life a lot easier.  They’re all free, so give them a try!  This post will probably grow over time, and if you have any tools that make a difference in your day, please feel free to share them in the comments. Compare It! – http://www.grigsoft.com/wincmp3.htm Compare It! This tool is...

pic 1

Gephi

Today’s post isn’t directly related to MicroStrategy, though it does have it’s roots there.  At the last two MicroStrategy World conferences, one of my favorite presentations has been the ones by LinkedIn.  They have some very unique data and challenges, and hearing the story of how they overcome them is very interesting.  They utilize a wide range of tools to run their business, including MicroStrategy...

0

Connecting Flex Mobile to MicroStrategy

Starting with Flex SDK 4.5, Adobe began supporting compiling your application to natively run on iOS and Android.  This presented a great opportunity to write code one time and then have it functional on several platforms.  Unfortunately, MicroStrategy Visualization SDK currently only supports Flex SDK 4.1, just missing out on all of the Mobile goodness.  That got me thinking though, that I personally only use...