Specifying the Measure Type

The Type option specifies the kind of data the measure expects in the source data, as well as the type used in the generated fact table, as follows:

Measure Type	Expected Type of Source Data	Type Used by Measure	Measure Details
number (this is the default)	Numeric data	%DoubleOpens in a new tab	Numeric value. Default aggregation is SUM.
integer	Numeric data (any fractional values are removed by truncation)	%IntegerOpens in a new tab	Integer value. Default aggregation is SUM.
age	Date/time data in $Horolog format	%IntegerOpens in a new tab	Age value in days. Can be used only with AVG (default), MIN, and MAX aggregations. Age measures are not generally recommended, unless you perform nightly full cube rebuilds or nightly selective builds of those age measures.
date	Date/time data in $Horolog format	%DeepSee.Datatype.dateTimeOpens in a new tab	Date value (in $Horolog format, with seconds removed). Can be used only with AVG, MIN, and MAX (default) aggregations.
boolean	0 or 1	%BooleanOpens in a new tab	Boolean value that can be aggregated. Default aggregation is COUNT.
string	Any	%StringOpens in a new tab	String values to be stored in the fact table; these are not indexed. Can be used only with COUNT. This measure cannot be dragged and dropped in the Analyzer.
iKnow*	Text values	%GlobalCharacterStreamOpens in a new tab or %StringOpens in a new tab, depending on the selected source	Text values to be processed and indexed using the NLP Smart Indexing API. This measure cannot be dragged and dropped in the Analyzer.