Bryan's BI Blog pushing what's possible

SNAG-0032 14

Renaming Columns Without Breaking the Schema

This is just a quick tip that came up in the Ask Bryan comments the other day that I thought was post-worthy. MicroStrategy creates logical objects that relate to the database model for the schema to build off of.  This includes logical objects for Database Tables and Columns.  Unfortunately, this can mean that Database level changes can become cumbersome to apply.  In 8.x, if you...

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 can also store modifications over time.  If a property is changed in the source, more often than not it’s in the form of an update.  But if you’re trying to perform...

7

Multisource

Sometimes the speed of business can’t wait for the perfect model and information flows to feed it.  Or perhaps it’s just not practical to ship data around to and from multiple locations due to it’s size or timing.  Maybe you just need to do a proof of concept or to borrow a few bits from an operational system.  MicroStrategy’s Multisource feature aims to assist in...

59

Getting Started with MicroStrategy

MicroStrategy and Business Intelligence in general has been a fantastic career space to me.  I love doing it (as evidenced by this blog I hope), and there’s definitely no shortage of opportunities in the market.  It’s exciting to be on ever changing projects as your priorities are always directly in line with the company’s.  Working on the front end aspect of Business Intelligence gets you...

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