Attribut-Drill trotz „Fact does not exist at a level“

MicroStrategy offers two different drilling techniques: to drill to an attribute (further in the text referred to as attribute-Drill) and the drilling template to a (Template-Drill). The attribute-Drill provides the user with greater flexibility available: by several sequentially executed Drilling …


Combining metrics with different dimensionalities

This time it’s about a very common idea: calculating several metrics with different dimensionality within one SQL parse. By term SQL parse I mean a single access to a fact table. Obviously, the most promising way for the performance optimization …


Smart metrics in the report limit

Today I want to show you a simple optimization technique that can be helpful in the reports showing Top X items and having at least one „smart metric“ on the template. As you know, smart metrics are necessary because of …