Measure columns
Column reporting design properties
Measures are usually numeric columns containing a value or measurement that you want to aggregate in reports. They are filtered by attributes in dimensions.
If selected, the column is used as a measure and the sub-properties (Aggregation and Format String) become active.
Aggregration. Defines how the corresponding measure is summarized when used in the context of a report.
Sum - Simple addition.
Min - The minimum value.
Max - The maximum value.
Distinct count - The count of distinct values. One distinct count measure is allowed per measure group.
Last non-empty - This aggregation type gives the most recent value of the measure.
The Last non-empty feature works only with the Enterprise or Business Intelligence Editions of SQL Server. Attempting to use it with Standard edition will display an error message. (The LastNonEmpty measure aggregation is not supported on SQL Server Analysis Services Standard Edition.)
The SQL Server version is only detected when you click Test Connection for a model server). If you have upgraded Data Hub from an earlier version and have not tested the model server connection, the error message above may incorrectly display.
To fix the problem, open a model server, test the connection and save the model server. Then, select another aggregation type and reselect the Last non-empty aggregation type. As a date dimension is required to determine the most recent non-empty value, this feature requires the pipeline to be related to a date dimension. Using it with a pipeline not related to a date dimension will display an error.
Note
If an average aggregation is needed, choose Sum as the aggregation here.
Make sure Count Measure is enabled for the pipeline. Then calculate the average as a calculated member in your Data Hub report by dividing the sum by the count.
Format String - Specify the default format for measures when used in reports. You can select from the corresponding drop-down or type a format string directly into the text box.
Hidden - When selected, the measure will not be available when the model is used to create a resource, although it will still be part of the data model.
Note
Bypass this column-specific setting, forcing the inclusion of any hidden measures and displaying all cube objects, using the Show Hidden Cube Objects setting on a Cube Server or Model Server screen.