Attribute Roles The support of attribute roles is among the most requested features in the schema/modeling area. It is the result of a common modeling practice where two or more attributes are defined using the same lookup table and column. When these attributes are placed on the same report, the result may return no data. […]

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

Very Large DataBase VLDB is an acronym for Very Large DataBase. VLDB properties enable MicroStrategy products to take advantage of the unique optimizations that different databases offer. There are over 100 settings that affect how the MicroStrategy Engine handles functions such as: Join options (star join, full outer join, and so forth) Metric calculation options […]