Attribute Mapping vs.. Attribute Relationships

Consider the time attributes of the system hierarchy. Even in projects with highly normalized data models snowflake the dimension of time is usually an exception: alle Eltern-Attribute des attribute Tag (also Monat, Quarter, Year and possibly. Week) are stored in the same table. …


Unrelated Filters

If an attribute does not (ggf. indirect) Connection to one of the attributes of the SQL engine selected fact table ( = „fact entry level“) has, we call it unrelated attributes ("Unrelated" is in German MicroStrategy surface as "unrelated" or. in some places …


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 …


Fact extensions

MicroStrategy does not store static SQLs for the reports, but the queries generated dynamically during execution. Probably the most common mistake of SQL engines is “Fact does not exist at a level that can support the requested analysis”. This error message is always …


The current business as a standard response to a prompt

Many companies use the so-called Business Calendar. The business time differs usually from time Calendar: the “current business” is not absolutely “today”, but can often be the last loaded into the data warehouse day. Here is an example, …


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 …