Category: MicroStrategy

Screen-Shot-2012-07-16-at-8.27.35-PM 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 design without compromising performance.  One of the drawbacks though is that it can require a lot of redundant object creation that can become tedious.  Fortunately, MicroStrategy provided a simple little tool...

Screen-Shot-2012-07-07-at-9.07.36-PM 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 is that you can switch the underlying database platform without having to change anything except to tweak a couple of settings for performance.  Of course, that won’t apply to Freeform SQL reports...

41

Defaulting Element Selectors Using URL API

I’ve previously written about using the URL API to answer prompts of different types, but one feature that has been missing is the ability to default selectors using this method.  Being able to do so would open up some really cool use cases, such as linking between dashboards or linking from a subscribed email to a dashboard while keeping the context for the user. Well,...

Screen-Shot-2012-06-22-at-11.28.46-PM 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 of drilling without having to slide out of view.  In 9.2.1, Information Windows made the jump to Documents in Web.  There’s a lot of really cool things you can do with...

Screen-Shot-2012-04-24-at-8.58.58-PM 6

The Importance of Branding

Business Intelligence is much bigger than the application itself.  Driving user adoption is critical to it’s success, and the best way that I’ve found to do that is to create a Brand for your system.  Creating an identity and personality is important for increasing user confidence, building an image, and gaining mindshare with your users.  Don’t forget that you’re always competing against the manual analyst...

pd1 15

Project Documentation

Documentation isn’t the most exciting thing to work on, but fortunately, MicroStrategy provides a tool that does some of the leg work for you.  This free tool is included in Desktop and produces a nicely formatted, web browsable output that can be shared with users.  In addition to discussing how to access and create this documentation report, I’ll also outline a really simple Web Customization...

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