Category: MicroStrategy

17

Fact and Attribute Anchoring

Carrying on with this week’s theme of Aggregate tables is an exploration of a concept I call Anchoring.  As your data volume grows and reporting complexity increases, an inevitable outcome is the growth of complex Aggregate and Sub-Set tables.  While as Architects we are effectively teaching MicroStrategy the “best” way to write a query by laying out rules such as key tables and parent/child relationships,...

4

Handling Count Metrics For Aggregates

Here’s a quick tip for a scenario that I encountered in a project today.  Say that you’ve got a schema where one of the metrics will be a Count(*) from the Fact Table.  This is a common occurrence when the Fact Table contains Events that may or may not have traditional facts, such as Revenue/Cost, but also the existence of the record is a fact itself. For...

16

Aggregate Tables

Arguably the most powerful feature of MicroStrategy is that it is Aggregate Aware.  Since it writes ROLAP SQL, you as the Architect have the ability to simply drop in an Aggregate Table and MicroStrategy will automatically use it when appropriate.  The amount of development time required to increase the performance of your reports across the board is minimal. Today, I’l talk about what Aggregate Tables are and...

dropbox1 0

Developing With Version Control Using Dropbox

Anyone who has done any kind of programming will attest to the value of version control (a feature that is sorely missing from MicroStrategy, but that’s a discussion for another day).  For me, when developing in Flex or Java, using some level of version control has saved me on many occasions.  To be specific, version control is the ability to view different versions of source code...

17

Deploying MicroStrategy Widgets as Plugins

There are a few different ways to deploy your widget from Flex to MicroStrategy.  The easiest, in my opinion, is to simply use the Deploy menu directly from Flex Builder.  This will handle all of the configurations you need on web, and even place the SWF in the proper locations if you can directly map to them (if not, it’s a simple copy/paste).  Another option...

6

Tagging User Email Addresses

In MicroStrategy 9.0, Web Subscriptions were moved from Narrowcast into the Intelligence Server in a new function called Distribution Services.  In the Narrowcast days, you had to maintain a separate metadata of user accounts and rely on a link between User and Email address.  Today, those are more tightly integrated, and the results is having Email addresses directly tied to User accounts as well as...

6

Real Time Job Monitor in Java

One thing that has always annoyed me in MicroStrategy is that the Job Monitor requires a manual refresh.  Sometimes when debugging issues, request come through so quickly, I have to sit there and spam the refresh button to catch a glimpse.  I could always look at the execution log in Enterprise Manager, but that’s usually less efficient.  Today I’ll share a quick Java application I...

34

Consolitdations vs Custom Groups

At MicroStrategy World 2011, my ETL/DBA colleague attended to gain a better perspective of where MicroStrategy fits in.  One of his comments struck me when he said he was pleasantly surprised that through the entire conference including all of the High Performance sessions, MicroStrategy always took the position of tweaking their side as opposed to pushing things to the database.  While it may seem obvious...

3

Find and Replace Object Dependencies

There was a very small feature introduced in MicroStrategy 9.0 with a very huge impact to the project I was working on at the time.  The feature was buried and undocumented, and I only knew about it because it was an enhancement request I had logged a year or so prior.  Even then I had trouble finding it, and technical support wasn’t even aware of...

7

Upgrading From Flex Builder 3 to Flash Builder 4

MicroStrategy 9.2 includes the Visualization Plugin for Flash Builder 4.  If you can obtain a copy (say, from a test environment), you can still use it against an older version of MicroStrategy.  The changes in the plugin are simply related to interfacing with Flash Builder 4 and have no consequence on the actual version of your MicroStrategy implementation.  Today I’ll walk through my upgrade experience...