Example of exceptions to dynamic aggregation.This section provides the following information related to functions and metrics that do not support dynamic aggregation by default: For information on changing the display of null values, see Changing the display of null values. When you use dynamic aggregation at a level the Analytical Engine considers erroneous for a metric defined with one or more of the functions listed above, null values, represented by dashes (-), are displayed on the report. For instructions to create shortcut metrics, which are a type of derived metric, see the MicroStrategy Web Help. Dynamic aggregation and subtotals are calculated correctly for these shortcut metrics, even if they contain the functions listed above. Dynamic aggregation is supported for a shortcut metric defined in a report, document, or Visual Insight quick dashboard created in MicroStrategy Web. Non-group functions or arithmetic operators: Metrics defined in this way are called compound metrics.įor information on supporting dynamic aggregation for compound metrics, see Dynamic aggregation for compound metrics.Variance (Var): Square of the standard deviation of input values.Standard Deviation (Stdev) : Statistical distribution of input values.Mode: Most frequently found input value.
Median: Middle value when input values are sorted.Geometric mean (Geomean): Square root of the product of input values.Count (Distinct=true): Number of distinct input values.Average (Avg): Sum of input values divided by number of input values.Metrics have their default aggregation function set to none if they are defined with the following functions: Metrics that cannot be calculated correctly using a dynamic aggregation function have the default dynamic aggregation function set to none. The metrics would need to be re-executed against the data warehouse to return correct values. For certain metric aggregation functions, recalculating the data at the higher level would yield erroneous or null values if using only the data in the report. However, due to their aggregation function, some metrics cannot be dynamically aggregated. The ability to aggregate data at a higher level in memory is useful for quick report interaction and analysis. Metrics that are not dynamically aggregated by default
0 kommentar(er)
