Bryan's BI Blog pushing what's possible

0

Naming Conventions

Today’s post is from a request via Twitter by @timrcase who asked if I could talk about my naming conventions for objects in MicroStrategy.  Everyone is going to have different opinions, and while there may be more tried and true or common methods, there’s really no wrong answer as long as it works for your environment.  Just remember, that future generations will need to be able to find...

Month-to-Yesterday 6

Date Filters on the First

I’m sure everyone has some common date filters that are used in their projects, and more than likely you’ve got a Month to Date (or Month to Yesterday depending on your ETL strategy) filter.  That filter is usually defined as “1st of the Month through Yesterday”, but the filter breaks if today is the 1st of the month, doesn’t it?  Given if today was November...

Screen-Shot-2011-10-31-at-10.26.02-PM 4

Document Within A Dashboard

MicroStrategy Report Services is a great tool for laying out pixel perfect Documents and Dashboards.  You can feed data in from multiple data sets and make it look pretty much however you want.  The style of design is reminiscent of Crystal Reports as it’s based on types of sections including the Detail section which repeats for each row of data.  A Dashboard is a Document that just...

0

Will You Be Using MicroStrategy Social?

MicroStrategy unveiled Social Intelligence at MicroStrategy World 2011, and proceeded to roll out a host of Social apps this year that serve as kind of tech demos including Wisdom, Alert, and Emma.  The Enterprise version of the product is still in Beta, but promises to allow you to mine data from your Facebook Applications.  Surely the power of the Social phenomenon can’t be denied, and...

0

Testing as Other Users

Here’s a quick tip that could be really obvious or make a big difference in your ability to provide support if you haven’t used it before.  It’s pretty common to receive an email from a user who has some issue, usually security or preference related.  It could be easier to either physically visit the user (if you’re able) or do a screen sharing session (if you have...

Screen-Shot-2011-10-24-at-10.01.28-PM 4

Metrics

This post is the first in direct response to a request from Twitter, submitted by @praneethgoparaj, asking if I could spend a little bit of time on the broad topic of Metrics.  Metrics are of course the lifeblood of the system and drive the engine of the report by determining which tables your report will source itself from.  There are lots of tricks you can do with...

Screen-Shot-2011-10-19-at-8.28.35-AM 1

Linking Down in Documents

For as much fun as it is to develop solutions in MicroStrategy, it’s that much more fun to find creative solutions for problems you aren’t supposed to be able to solve out of the box.  The Discussion Forum‘s first Guru, AndreasK, once said (paraphrasing because I couldn’t find the link), “I never like to say it can’t be done, because someone always seems to find...

Screen-Shot-2011-10-08-at-11.37.29-PM 31

Embedding HTML in Attributes

Since MicroStrategy is primarily consumed via the Web, there is a unique opportunity to embed some extra value by slipping HTML into little pockets of a report.  While the HTML Container for Documents is obviously designed to do just that, you can also sneak it into Attributes which can help solve some pretty neat problems.  Today I’ll talk about how HTML Attributes work and a...

0

Intelligent Cube Statistics Bug and Fix in 9.2

There were some new statistics added to Enterprise Manager in 9.2 for tracking Intelligent Cubes.  This new table, IS_CUBE_ACTION_FACT allows you to see (among other things) the size and rows of the Cube the last time it was loaded.  While I’ve talked about building a Cube Tracking Report before, that strategy doesn’t work when you introduce Incremental Refresh.  Since Incremental Refresh only pulls back a...

Screen-Shot-2011-10-08-at-11.28.32-PM 8

Report Search Tool

I received an interesting request from our Power Users this week.  They only have Web access (no Desktop) and wanted to have a way to locate reports based on their components.  For example, when someone requests a report containing Region and Cost, currently they can only hope to either know where it is or search for a match in the Name / Description.  Using Desktop,...