Steps to Define Semiadditive Behavior<\/strong><\/h4>\n\n\n\nNow, on the Define Semiadditive Behavior<\/strong> page of the wizard, you can select how to define semiadditivity by selecting one of the given option –<\/p>\n\n\n\nTurn off semiadditive behavior<\/strong> <\/h5>\n\n\n\n- Firstly, it is used to remove semiadditive behavior from a cube in which semiadditive behavior was previously defined. <\/li>
- This selection resets a measure to SUM<\/strong> if it is set to any of the given aggregation function types including By Account, Average of Children, First Child, Last Child, Last Nonempty Child, First Nonempty Child and None<\/li>
- Also, this option does not change measures with a regular aggregation function: Sum<\/strong>, Min<\/strong>, Max<\/strong>, Count<\/strong>, or Distinct****Count<\/strong>.<\/li>
- The wizard has detected the ‘Account” account dimension, which contains semiadditive members. The server will aggregate members of this dimension according to the semiadditive behavior specified for each account type.<\/li>
- Further, it causes the system to set all measures from a measure group dimensioned by an Account type dimension to the By Account aggregation function and the server will aggregate members of the dimension according to the semiadditive behavior specified for each account type.<\/li><\/ul>\n\n\n\n
Define semiadditive behavior for individual measures<\/strong><\/h5>\n\n\n\nIt is used to select the semiadditive behavior of each measure individually. The default setting is SUM<\/strong> (fully additive). Now, for each measure, you can select from the types of semiadditive functionality described in the following table.<\/p>\n\n\n\nSemiadditive function<\/th> Description<\/th><\/tr><\/thead> Average of Children<\/td> It is used for the aggregation of a member is the average of its children.<\/td><\/tr> ByAccount<\/td> It allows the system to reads the semiadditive behavior specified for the account type.<\/td><\/tr> Count<\/td> The aggregation is a count of members.<\/td><\/tr> Distinct Count<\/td> The aggregation is a count of unique members.<\/td><\/tr> First Child<\/td> The member value is evaluated as the value of its first child along the time dimension.<\/td><\/tr> FirstNonEmpty<\/td> The member value is evaluated as the value of its first child along the time dimension that contains data.<\/td><\/tr> LastChild<\/td> The member value is evaluated as the value of its last child along the time dimension.<\/td><\/tr> LastNonEmpty<\/td> The member value is evaluated as the value of its last child along the time dimension that contains data.<\/td><\/tr> Max<\/td> It is used to apply the standard maximum aggregation function.<\/td><\/tr> Min<\/td> It is used to apply the standard minimum aggregation function.<\/td><\/tr> None<\/td> No aggregation is applied.<\/td><\/tr> Sum<\/td> It is used to apply standard summation function <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Turn off semiadditive behavior<\/strong> <\/h5>\n\n\n\n- Firstly, it is used to remove semiadditive behavior from a cube in which semiadditive behavior was previously defined. <\/li>
- This selection resets a measure to SUM<\/strong> if it is set to any of the given aggregation function types including By Account, Average of Children, First Child, Last Child, Last Nonempty Child, First Nonempty Child and None<\/li>
- Also, this option does not change measures with a regular aggregation function: Sum<\/strong>, Min<\/strong>, Max<\/strong>, Count<\/strong>, or Distinct****Count<\/strong>.<\/li>
- The wizard has detected the ‘Account” account dimension, which contains semiadditive members. The server will aggregate members of this dimension according to the semiadditive behavior specified for each account type.<\/li>
- Further, it causes the system to set all measures from a measure group dimensioned by an Account type dimension to the By Account aggregation function and the server will aggregate members of the dimension according to the semiadditive behavior specified for each account type.<\/li><\/ul>\n\n\n\n
Define semiadditive behavior for individual measures<\/strong><\/h5>\n\n\n\nIt is used to select the semiadditive behavior of each measure individually. The default setting is SUM<\/strong> (fully additive). Now, for each measure, you can select from the types of semiadditive functionality described in the following table.<\/p>\n\n\n\nSemiadditive function<\/th> Description<\/th><\/tr><\/thead> Average of Children<\/td> It is used for the aggregation of a member is the average of its children.<\/td><\/tr> ByAccount<\/td> It allows the system to reads the semiadditive behavior specified for the account type.<\/td><\/tr> Count<\/td> The aggregation is a count of members.<\/td><\/tr> Distinct Count<\/td> The aggregation is a count of unique members.<\/td><\/tr> First Child<\/td> The member value is evaluated as the value of its first child along the time dimension.<\/td><\/tr> FirstNonEmpty<\/td> The member value is evaluated as the value of its first child along the time dimension that contains data.<\/td><\/tr> LastChild<\/td> The member value is evaluated as the value of its last child along the time dimension.<\/td><\/tr> LastNonEmpty<\/td> The member value is evaluated as the value of its last child along the time dimension that contains data.<\/td><\/tr> Max<\/td> It is used to apply the standard maximum aggregation function.<\/td><\/tr> Min<\/td> It is used to apply the standard minimum aggregation function.<\/td><\/tr> None<\/td> No aggregation is applied.<\/td><\/tr> Sum<\/td> It is used to apply standard summation function <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Define semiadditive behavior for individual measures<\/strong><\/h5>\n\n\n\nIt is used to select the semiadditive behavior of each measure individually. The default setting is SUM<\/strong> (fully additive). Now, for each measure, you can select from the types of semiadditive functionality described in the following table.<\/p>\n\n\n\nSemiadditive function<\/th> Description<\/th><\/tr><\/thead> Average of Children<\/td> It is used for the aggregation of a member is the average of its children.<\/td><\/tr> ByAccount<\/td> It allows the system to reads the semiadditive behavior specified for the account type.<\/td><\/tr> Count<\/td> The aggregation is a count of members.<\/td><\/tr> Distinct Count<\/td> The aggregation is a count of unique members.<\/td><\/tr> First Child<\/td> The member value is evaluated as the value of its first child along the time dimension.<\/td><\/tr> FirstNonEmpty<\/td> The member value is evaluated as the value of its first child along the time dimension that contains data.<\/td><\/tr> LastChild<\/td> The member value is evaluated as the value of its last child along the time dimension.<\/td><\/tr> LastNonEmpty<\/td> The member value is evaluated as the value of its last child along the time dimension that contains data.<\/td><\/tr> Max<\/td> It is used to apply the standard maximum aggregation function.<\/td><\/tr> Min<\/td> It is used to apply the standard minimum aggregation function.<\/td><\/tr> None<\/td> No aggregation is applied.<\/td><\/tr> Sum<\/td> It is used to apply standard summation function <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
| Semiadditive function<\/th> | Description<\/th><\/tr><\/thead> |
|---|---|
| Average of Children<\/td> | It is used for the aggregation of a member is the average of its children.<\/td><\/tr> |
| ByAccount<\/td> | It allows the system to reads the semiadditive behavior specified for the account type.<\/td><\/tr> |
| Count<\/td> | The aggregation is a count of members.<\/td><\/tr> |
| Distinct Count<\/td> | The aggregation is a count of unique members.<\/td><\/tr> |
| First Child<\/td> | The member value is evaluated as the value of its first child along the time dimension.<\/td><\/tr> |
| FirstNonEmpty<\/td> | The member value is evaluated as the value of its first child along the time dimension that contains data.<\/td><\/tr> |
| LastChild<\/td> | The member value is evaluated as the value of its last child along the time dimension.<\/td><\/tr> |
| LastNonEmpty<\/td> | The member value is evaluated as the value of its last child along the time dimension that contains data.<\/td><\/tr> |
| Max<\/td> | It is used to apply the standard maximum aggregation function.<\/td><\/tr> |
| Min<\/td> | It is used to apply the standard minimum aggregation function.<\/td><\/tr> |
| None<\/td> | No aggregation is applied.<\/td><\/tr> |
| Sum<\/td> | It is used to apply standard summation function <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n |
![\"Microsoft](\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\")
<\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"