The Varigence company brand logo
Products
BimlFlexBimlStudioBimlExpress
Pricing
Solutions
IndustriesUse Cases
Resources
DocumentationKnowledge BaseBlog
About
CompanyContact Us
Products
BimlFlexBimlStudioBimlExpress
Pricing
Solutions
IndustriesUse Cases
Resources
DocumentationKnowledge BaseBlog
About
CompanyContact Us
Schedule Demo
Account
Schedule Demo
Account

SsasAggregationFunction Enumeration

The SsasAggregationFunction enumeration provides a list of functions that can be used to aggregate the column values for a measure.

Enumeration Values

NameSummary
Sum
Specifies that the sum of column values should be used.
Count
Specifies that the count of column values should be used.
Min
Specifies that the minimum of the column values should be used.
Max
Specifies that the maximum of the column values should be used.
DistinctCount
Specifies that a count of the distinct column values should be used.
None
Specifies that no aggregation should be used.
ByAccount
Specifies that each CurrentMember of the Account dimension will have an aggregation chosen based on its account type. The default is Sum.
AverageOfChildren
Specifies that the average of all non-empty leaf descendants in time should be used.
FirstChild
Specifies that the first child member on the time dimension should be used.
LastChild
Specifies that the last child member on the time dimension should be used.
FirstNonempty
Specifies that the first non-empty child on the time dimension should be used.
LastNonempty
Specifies that the last non-empty on the time dimension should be used.

© Varigence