AggregationMeasureFactCount
Defines the fact count measure in an aggregation table that tracks the number of fact table rows contributing to each aggregated row. The fact count is essential for computing accurate averages, weighted calculations, and other statistical operations that require knowledge of the underlying data density.
Extends
Attributes
Name | Id | Type | Lower | Upper |
---|
References
Name | Type | Lower | Upper | Containment |
---|---|---|---|---|
column | Column🔗 | 1 | 1 | false |
Required reference to the column in the aggregation table that stores the fact count values. This column contains the number of fact table rows that were aggregated to produce each aggregated row. | ||||
factColumn | Column🔗 | 1 | 1 | false |
Required reference to a column in the fact table that is used as the basis for counting fact table rows. Typically references a non-null column in the fact table to ensure accurate row counting. |
Used by
- AggregationTable🔗 → aggregationMeasureFactCounts