Bryan's BI Blog pushing what's possible

4

Using MicroStrategy as a Historical Data Store with Intelligent Cubes

This is more of an idea I had and not something that I’ve tried or necessarily would even do, but hear me out.  Intelligent Cubes work by pulling data from the database and storing it in memory for fast access.  The idea is that the in memory indexes and slicing is much faster for small to medium sized data sets than hitting a database that...

2

Using Object Prompts In Migrations

MicroStrategy Object Manager can be a stressful tool. There’s a lot of things going on in the background and always surprises waiting for you in the Conflict Resolution screen where you must decide what moves and what doesn’t.  A wrong decision could leave your Production project non-functional or worse, produce incorrect results.  Then there’s the New Objects section that seems to get paid by the...

9

Managing Job Prioritization

One of the most important features to control in tuning your MicroStrategy environment is controlling Job Prioritization in the Intelligence Server.  In the event that you have more concurrent jobs running than open slots on the database, queuing will occur.  When a Job is in the Waiting status, that could be giving a very poor user experience.  Fortunately, you do have some control to tell...

2

Using Views In Your Warehouse Model

One trick that I love to use is for my DBA to always create an associated View in the database for each Table in the warehouse.  I reference these Views just the same via Warehouse Catalog/Architect, and I make it a point to never hit the Tables directly.  There are some that will have a fit and say that I’m going to suffer greatly in...

0

Creating a Better Create Report Template

There’s nothing more satisfying that empowering a user.  In addition to the old adage, “… Teach a man to fish and you feed him for a lifetime”, the same is true when you can give a savvy Business User the ability to answer their own questions.  When a BI project is initially rolling out, there are always some analysts that are a little uneasy and...

1

Simultaneous Document Development Tricks

Sometimes project timelines or resource availability means we have to have multiple developers working on a single Report or Document.  While simultaneous Report development isn’t too hard, since the most time consuming steps are building the metrics and finding the right settings and filters.  Those can be developed separately and easily merged in the end.  But what about working on a major Dashboard where the...

6

How to Disconnect Data Sets in Document Layouts

A word of warning, I’m not exactly sure how the feature I’m going to talk about works.  It’s one of those features that most of us just tinker with all of the options until we get the result we want, like Level Metrics or Attribute Join Types.  Document Virtual Datasets have been confounding us for years, and with the addition of added control over Primary...

71

Triggering Events with Command Manager

MicroStrategy Command Manager is an external application that has basic scripting components that can be used for bulk operations.  While it’s designed to automate common tasks and save time in bulk changes, it does come with the ability to integrate external applications with MicroStrategy Events.  This allows you to integrate your process flow from sources such as ETL or source system events to trigger MicroStrategy...

15

Logical Views

While we usually focus on MicroStrategy and it’s role vs the Data Warehouse and it’s role, the truth is the lines are pretty blurred.  Nothing frustrates me more than when people tell me the “right way” to do something.  The truth is, only you could possibly know the right way when it comes to a solution, because you have all of the information.  You know...

0

Visual Insights with 9.2

I was fortunate enough to get a sneak peak at a very exciting feature at MicroStrategy World last year that attempted to transform the way we interact with data.  This new tool merged the benefits of Intelligent Cubes and Flash Visualizations to provide various graphical analyses instantly.  It was a brilliant display and I couldn’t wait to see where they were going to take it....