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...
Monthly Archive: April 2011
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...
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...
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...
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...
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...
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...
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...
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...
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...