Category: MicroStrategy

1

9.2.1 Feature Round Up

MicroStrategy released the latest update to their product suite, version 9.2.1.  This is a Service Pack release to the 9.2 platform and contains lots of fixes, but also a few new key features and rounds off the major announcements they made at MicroStrategy World 2011.  Today, I’ll highlight the big new features, and a few gems I’ve found along the way. Transaction ServicesThis is the...

2

Last Function

There are lots of interesting functions in MicroStrategy’s Analytical Engine, but every once in awhile I stumble across one that really saves my day (though often long after the day needed saving).  I work with a Type 2 Model aka. Slowly Changing Dimensions aka. As-is vs As-was, and unfortunately it can cause a lot of hoops for me to jump through.  In this model, we...

2

Running Custom MicroStrategy Visualizations on the iPad: Part 2

Last month, I posted about some exciting new features in Flash Builder 4.5 that allowed us to port existing Flash visualizations directly to the iPad without any major code modifications.  One of the issues I previously hadn’t worked out (and admittedly, the most important feature) was the ability for the iPad version of the visualization to pull data directly from MicroStrategy at runtime. I’m happy...

9

Retaining Object IDs From Copied Objects

The most obvious reason to maintain multiple environments (Development, Test, Production) is so that you can make changes to objects while building/modifying without impacting Production. Once the changes are complete/tested, they can be migrated with MicroStrategy Object Manager into the target project. In order for this theme to work, MicroStrategy relies on the Object IDs to be synced for objects between projects. So what do...

14

Utilizing Database Prefixes

A handy little feature available in the MicroStrategy Warehouse Catalog is the ability to add a prefix to a table.  This can be done either manually or automatically and gives you a little bit of flexibility in your database schema as well as opening a few tricks for you.  While it’s not necessary in every situation, it does come in handy in a pinch and...

20

Integrating the Properties Viewer in Your Widget

One of the nicest features of the MicroStrategy Visualization Framework is that widget default properties are stored in the metadata along with the report.  The framework comes with a very easy to use Properties editor automatically saves the current settings with the report when it’s saved.  This allows you to use the widget in multiple locations, provide flexible configurations that users can change, but also...

1

Detecting Orphaned Objects in Production

One thing that has always annoyed me about MicroStrategy Object Manager is it’s insistence to migrate schema objects with even the slightest excuse.  In the same vein as Quantum Mechanics, “when things get small they get weird”, the same is true in the MicroStrategy metadata.  The Metadata Dependency table keeps all of the relationships between objects, for example, a Report is a parent of the...

2

Purging Element Caches with the Java SDK

The other day I had a requirement where I needed to give a single user access to clear Element Caches.  He didn’t have a Desktop license, but the permission to access the Caches isn’t tied to Desktop.  With a quick program written in Java using the MicroStrategy Java SDK, I was able to deploy a quick app to the user to execute a cache clear...

1

Participating in MicroStrategy Beta Programs

MicroStrategy offers access to Betas of upcoming releases to any existing customers that are interested.  While you can’t publicly talk about the features until they are Generally Available (GA), it does provide you with many benefits for you and your company.  Participation is totally free, and there are no obligations.  I’ve participated in every Beta since 8.1, and even gave a presentation at MicroStrategy World 2009 on...

5

Tracking Intelligent Cube Growth

One of the first concerns you may have after scheduling some Intelligent Cubes to update is their growth rate.  Each cube is not only loaded into memory, but also saved to disk, so managing their growth rate will have real impacts on system performance and stability.  If you haven’t made use of the 9.2 feature to roll off old data, then each time you add...