Category: MicroStrategy

8

Passing Element Prompt Answers to Database Passthrough Functions

A common request is for the ability to use an element prompt to choose a month or day, and then based on that selection, choose a range such as a rolling months or rolling days.  The problem is that if you build out this prompt, ApplyComparison(“#0 in (select month from tblmonth where month >= #1”, Month@ID, ?Month), this would result in the SQL:  “a11.Month in...

4

Formatting Alternate Graph Bars in a Series

I had a requirement recently where I had a single metric on a bad graph that needed to use alternating colors for readability.  Unfortunately, the MicroStrategy Graph options for formatting a Series is limited to a single color.  Today I’ll share a quick trick on how I was able to work around it with Conditional Formatting to achieve the desired results.  This trick will also...

0

Adding an RSS News Feed to the Project Page

One of my favorite and yet easiest customizations is adding a News feed to the MicroStrategy entry point.  Ideally, this would be the first screen that a user sees after logging in.  A good fit for this requirement is the Projects page, even if you only have one project as there’s usually lots of empty space available.  Adding a News feed will allow you to...

13

Moving Subscriptions Between Users

I was once on a project in 8.x days where one group of users were responsible for managing the subscriptions for larger sets.  Most had anywhere between 10-20 subscriptions, and the largest were in the hundreds.  This was back in the Narrowcast days where the subscriptions metadata was separate from the IServer metadata, and the connection was loose at best.  When a person left or...

17

Exporting Flash Dashboards to PDF

Since the introduction of Flash Dashboards in 8.1, the only method of exporting them has been MHT.  This format is a container for a web page that keeps all of the files necessary for playing the animation (including the data to feed the dashboard).  The problem is that it’s only supported by Internet Explorer for reading, causes lots of security warnings or could even be...

9

Running Custom MicroStrategy Visualizations on the iPad: Part 1

The very first question I received after showing people my first custom visualization was “Can I run it on my iPad?“.  Surely, Mobile Business Intelligence is the hot item right now, and the fancier the visualization, the more it seems at home on an iPad for an equally fancy demo.  The feud between Apple and Adobe is legendary, and it seemed that as developers we...

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