Archive for the 'Tech Tip' Category
Tech Tip: HTML Document in the Body of an Email
By 
Ever tried to put the contents of a document into the body of an email using Distribution Services in MicroStrategy but it turned out looking nothing like your document? Follow these steps to fix that! The Problem: You created a document in web that looks great in a web browser: But when you send it [...]
Tech Tip: Managing Customizations when Migrating to MicroStrategy 9.3
MicroStrategy Web 9.3 has a fresh user interface, and good news- the underlying architecture for managing customizations remains the same as previous versions. This means two paths exist for migrating web customizations from previous versions to MicroStrategy 9.3, the path you use depends on how your system was customized. The first path is accessible if [...]
Tech Tip: Administrator Tool Tips for Linux
Within MicroStrategy, you can execute certain commands to perform various administrative tasks. You can issue the following commands from your ‘bin’ directory to support the following MicroStrategy tasks: Start/stop/get status of I-server ./mstrctl -s IntelligenceServer start ./mstrctl -s IntelligenceServer gs ./mstrctl -s IntelligenceServer stop Start/stop listener ./mstrctl -s Listener stop ./mstrctl -s Listener start To [...]
Tech Tip: Re-Prompt Workaround
How to create a filtered prompt to retain “Not in list” operator when selecting the “Re-Prompt” button in mstr Web V9.3.0 Issue Summary: Report SQL changes from “not in” to “in” when re-prompt a report using a ‘not in list’ filter in MicroStrategy Desktop 9.3.0 NOTE: This is a known issue in MicroStrategy V9.3.0. Refer [...]
Tech Tip: Use Graphic Image as Panel Selector in a Mobile Dashboard
In the past, there has not been a way to utilize graphic images as a selector to target different panels in a panel stack. With the release of 9.3, this is now an option for your mobile dashboards. Below are step by step instructions to follow after you have imported the images into your mobile [...]
Tech Tip: Extract object definitions from MSTR
The challenge of project for me and most of us are documenting the Objects that we have Created/Modified. Documenting parallel when creating MSTR Objects slows us down. I had the same challenge in my last project, so I wrote this command Manager script to get the list of objects in a formatted way so that [...]
Tech Tip: Disabling Grid Options in Your Dashboard
Some of you may have a multitude of MicroStrategy Web-based dashboards and do not require the right-click options on your data grids. For example, the grid on your dashboard might look like this: Lucky for you, there is a super simple solution for hiding this feature. Open your dashboard in MicroStrategy In MicroStategy Desktop, navigate [...]
Tech Tip: When Count Distinct doesn't work.
Trying to get distinct counts to work in an Intelligent Cube is frustrating. We found a workaround that involves getting dynamic aggregation to do the work for us – attached is the process we used: Create a new Custom Subtotal and add it to the Project ObjectsSubtotal folder. Make sure you set the Count function’s [...]
Tech Tip: How to Setup a Separate Log for Object Migrations
Having a seperate log for object migrations in MicroStrategy can be helpful when you want to see exactly what was done and moved during a specific migration. The following are steps needed to ensure you capture the migration in a separate log instead of in the DSS Error log, where it can get lost, mixed [...]
Tech Tip: Is IE8 or IE9 Failing to Run Your .MHT Files?
During the install of both IE8 and IE9 sometmes the file associations get disrupted. To fix this for our .MHT files, we just need to repair the file association. The following instructions work on a Vista/Windows 7 machine. The instructions are fairly similar for an XP machine. To fix the .MHT file association in Windows [...]
