Category: MicroStrategy

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

15

MicroStrategy TaskProc Enhancement in 9.2 SDK

One thing that you’ll notice when trying to use the TaskProc as a method of feeding MicroStrategy data into an external application is that the various options for results are none too friendly.  The XML options are all very bloated with metadata/formatting overhead and the other delivery packages are just wrappers for the XML, so they make it worse.  The handy ReportViewer style that can...

3

Improving Query Flexibility with Partition Mapping

Partition Mapping is a traditional database concept that MicroStrategy has adopted in the SQL Engine to give you even more options for performance and tuning.  Traditional Database Partitioning involves taking a large table and breaking it up into smaller pieces by separating it at logical break points, such as one table per year or per region.  The database would then be intelligent enough to know...

50

Incremental Refresh of Intelligent Cubes

Arguably, the headliner feature of MicroStrategy 9 was the introduction of Intelligent Cubes.  This powerful feature revolutionized project speed and design by allowing for lightning fast data access directly from memory.  After implementation, it gives the developer the best of both ROLAP and MOLAP worlds without either of the draw backs.  You get the speed of MOLAP data requests, but the flexibility of ROLAP ad-hoc analysis. With...

19

Tracking Table Usage with Enterprise Manager

Capping off this week of Aggregate Table talk, one piece of insight you’ll definitely want to have is which tables are being used by which reports.  Sometimes it can be handy to know if a particular table is no longer needed and can be discarded, or to identify reports that are hitting detail tables instead of aggregates.  MicroStrategy Enterprise Manager comes with lots of statistical...