Readers: To make it easier to find all of the MicroStrategy Tips & Tricks I posted, I have added a new page that contains a quick reference to all of them (see screenshot below). I will update this page after every five new tips & tricks have been added. Best Regards, Michael

A Star Schema is a design that contains only one lookup table for each hierarchy in the data model instead of having separate lookup tables for each attribute. With only a single lookup table for each hierarchy, the IDs and descriptions of all attributes in the hierarchy are stored in the same table. This type […]

Readers: In my last blog post, I blogged about the new MicroStrategy Community. Jaime Perez, VP of Worldwide Customer Services, and his crew have come up with a better way for us to engage with MicroStrategy as well as his team. Speaking of Jaime, last June, he posted this great tip on the MicroStrategy Knowledgebase […]

The Issue Each report and document has a URL path that could be used to directly execute the object when pasted in the browser address bar. The URL path can be found in the properties section when a user right-clicks on the object. The expected view of that window is as follows: The view observed by some […]

This is another one of those little tricks that can save you from pulling your hair out trying to figure it out. By default, hyperlinks in a Report Services document are underlined. The underlining can not be removed by changing the format of the attribute or metric. There is an Enhancement Request open with MicroStrategy […]

In MicroStrategy Report Services Documents, document datasets and their original source reports  (such as a grid report being used as a dataset) are not completely connected to each other. Depending on the changes made on the source report, it can be reflected differently on the document. Basically, the change can be divided into two types. Type […]

This is something that I actually had the opportunity to use this week. It really came in handy and helped satisfy my client’s requirements. Just a reminder as we discuss this tip, I am using MicroStrategy v9.4.1 and MicroStrategy Developer. Developer is the new name for MicroStrategy Desktop as of v9.4.1 This example demonstrates how […]

By default, when users apply subtotals in a report, the name of the subtotal is displayed in the subtotal line items that appear in the report. Users can use custom subtotals to give more control over the characteristics of a subtotal. Custom subtotals allow users to define custom subtotal line items that appear on the […]

I had this error the other day. Fortunately, I had just been reading about working set governor settings the other night to prepare for the CPA and MCE exams. First, let’s discuss the issue. Issue/Problem In MicroStrategy Web, when I executed a report, I received the following error message (also, see screenshot below). (Results for this […]

There are cases in which a dynamic prompt is used to qualify attributes selected to be part of a report, but the attribute list is very long. Attributes like ‘Street Address’ may contain keywords like ‘St’, ‘Ave’, ‘Dr’ that can be used to reduce the list of selected elements. It is possible to filter the […]