Calculating Data: Metrics

The table below summarizes the Metrics VLDB properties. Additional details about each property, including examples where necessary, are provided in the sections following the table.

Property	Description	Possible Values	Default Value
Absolute Non-Agg Metric Query Type	The Analytical Engine can either: Perform the non-aggregation calculation with a subquery, or Place the results that would have been selected from a subquery into an intermediate table and join that table to the rest of the query.	Use subquery Use temp table as set in the Fallback Table Type setting	Use subquery
Compute Non-Agg Before/After OLAP Functions (For Example, Rank) Calculated in Analytical Engine	This property controls whether the non-aggregation calculation is performed before or after an Analytical Engine calculation. Use this property to determine, for example, whether the engine ranks the stores and then performs a non-aggregation calculation, or performs the non-aggregation calculation first.	Calculate non-aggregation before OLAP Functions/Rank Calculate non-aggregation after OLAP Functions/Rank	Calculate non-aggregation before OLAP Functions/Rank
Count Compound Attribute	Compound attributes are usually counted by concatenating the keys of all the attributes that form the key. If the database platform does not support COUNT on concatenated strings, this property should be disabled.	COUNT expression enabled COUNT expression disabled	COUNT expression enabled
COUNT(column) Support	Some database platforms do not support count on a column (COUNT(COL)). This property converts the COUNT(COL) statement to a COUNT(*).	Use COUNT(column) Use COUNT(*)	Use COUNT(column)
Default to Metric Name	Allows you to choose whether you want to use the metric name as the column alias or whether to use a MicroStrategy- generated name.	Do not use the metric name as the default metric column alias Use the metric name as the default metric column alias	Do not use the metric name as the default metric column alias
Integer Constant in Metric	This property determines whether to add a ".0" after the integer.	Add ".0" to integer constant in metric expression Do Not Add ".0" to integer constant in metric expression	Add ".0"' to integer constant in metric expression
Join Across Datasets	Determines how values for metrics are calculated when unrelated attributes, from different datasets of a dashboard or document, are included with metrics.	Disallow joins based on unrelated common attributes Allow joins based on unrelated common attributes:	Disallow joins based on unrelated common attributes
Max Metric Alias Size	Maximum size of the metric alias string	User-defined	256
Metric Join Type	Type of join used in a metric.	Inner Join Outer Join	Inner Join
Non-Agg Metric Optimization	Influences the behavior for non-aggregation metrics by either optimizing for smaller temporary tables or for less fact table access.	Optimized for less fact table access Optimized for smaller temp table	Optimized for less fact table access
Null Check	Indicates how to handle arithmetic operations with NULL values.	Do nothing Check for NULL in all queries Check for NULL in temp table join only	Check for NULL in temp table join only
Separate COUNT DISTINCT	Indicates how to handle COUNT (and other aggregation functions) when DISTINCT is present in the SQL.	One pass Multiple count distinct, but count expression must be the same Multiple count distinct, but only one count distinct per pass No count distinct, use select distinct and count(*) instead	No count distinct, use select distinct and count(*) instead
Smart Metric Transformation	Determines the evaluation order to support variance and variance percentage transformations on smart metric or compound metric results.	False True	False
Subtotal Dimensionality Use	Determines how the level of calculation is defined for metrics that are included on reports that utilize the OLAP Services feature dynamic aggregation.	Use only the grouping property of a level metric for dynamic aggregation (default): Use only the grouping property of a level subtotal for dynamic aggregation: Use both the grouping and filtering property of a level metric for dynamic aggregation: Use both the grouping and filtering property of a level subtotal for dynamic aggregation:	Use only the grouping property of a level metric for dynamic aggregation
Transformable AggMetric	Define metrics that should be used to perform transformations on compound metrics that use nested aggregation.	False True	False
Transformation Role Processing	Indicates how to handle the transformation dates calculation.	7.1 style. Apply transformation to all applicable attributes 7.2 style. Only apply transformation to highest common child when it is applicable to multiple attributes	7.1 style. Apply transformations to all applicable attributes
Zero Check	Indicates how to handle division by zero.	Do nothing Check for zero in all queries Check for zero in temp table join only	Check for zero in all queries