Define Semiadditive Behavior (Business Intelligence Wizard)
Applies To: SQL Server 2016
Use the Define Semiadditive Behavior page to enable or disable semi-additive behavior on measures. Semi-additive behavior determines how measures that are contained by a cube are aggregated over a time dimension.
Turn off semiadditive behavior
Disables semi-additive behavior in all measures contained by the cube.
The wizard has detected the <dimension name> account dimension, which contains semiadditive members. The server will aggregate members of this dimension according to the semiadditive behavior specified for each account type.
Enables semi-additive behavior for account dimensions that contain semi-additive members. Selecting this option sets the aggregation function of all measures in measure groups that reference the account dimension to ByAccount.
For more information about account dimensions, see Create a Finance Account of parent-child type Dimension.
Define semiadditive behavior for individual members
Enables semi-additive behavior and specifies the semi-additive aggregation function for specific measures. The aggregation function applies to all dimensions that are referenced by the measure group that contains the measure.
Displays the name of a measure contained by the cube.
Select the aggregation function for the selected measure. The following table lists the aggregation functions that are available.
|AverageOfChildren||Aggregated by returning the average of the measure's children.|
|ByAccount||Aggregated by the aggregation function associated with the specified account type of an attribute in an account dimension.|
|Count||Aggregated using the Count function.|
|DistinctCount||Aggregated using the DistinctCount function.|
|FirstChild||Aggregated by returning the measure's first child member over a time dimension.|
|FirstNonEmpty||Aggregated by returning the measure's first nonempty member over a time dimension.|
|LastChild||Aggregated by returning the measure's last child member over a time dimension.|
|LastNonEmpty||Aggregated by returning the measure's last nonempty member over a time dimension.|
|Max||Aggregated using the Max function.|
|Min||Aggregated using the Min function.|
|None||No aggregation performed.|
|Sum||Aggregated using the Sum function.|