Use the Define Semiadditive Behavior page to enable or disable semi-additive behavior. Semi-additive behavior determines how measures that are contained by a cube are aggregated over a time dimension.
.gif) Note: |
|---|
|
This page does not appear if the Business Intelligence Wizard was started from Dimension Designer or by right-clicking a dimension in Solution Explorer in Business Intelligence Development Studio.
|
-
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 Account (Analysis Services - Multidimensional Data).
-
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.
-
Measures
-
Displays the name of a measure contained by the cube.
-
Semiadditive Function
-
Select the aggregation function for the selected measure. The following table lists the aggregation functions that are available.
|
Value
|
Description
|
|---|
|
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.
|
|
FirstNonEmpty
|
Aggregated by returning the measure's first nonempty member.
|
|
LastChild
|
Aggregated by returning the measure's last child member.
|
|
LastNonEmpty
|
Aggregated by returning the measure's last nonempty member.
|
|
Max
|
Aggregated using the Max function.
|
|
Min
|
Aggregated using the Min function.
|
|
None
|
No aggregation performed.
|
|
Sum
|
Aggregated using the Sum function.
|
| Note: |
|---|
|
Selections made for this option apply only if Define semiadditive behavior for individual members is selected.
|
Reference
Business Intelligence Wizard F1 Help
Cube Designer (Analysis Services - Multidimensional Data)
Dimension Designer (Analysis Services - Multidimensional Data)
Help and Information
Getting SQL Server 2008 Assistance
