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 […]