net.pricefx.formulaengine

Interface DatamartContext.DataProfilerResult

Enclosing interface:

DatamartContext

public static interface DatamartContext.DataProfilerResult

Method Summary

Modifier and Type	Method and Description
ResultMatrix	getDimensions()
Map<String,Object>	getMap() All the results in map format, for fluent access in Groovy
ResultMatrix	getMeasures()

Method Detail

getDimensions

ResultMatrix getDimensions()

Returns:

ResultMatrix with a row for each dimension profiled. Columns are

• "Min": Lowest value according to the natural order of the dimension field type (String, Date...)
• "Max": Lowest value according to the natural order of the dimension field type (String, Date...)
• "#": Number of values in total (matching the number of rows in the query result set)
• "#Nulls" Number of rows with a null value (i.e. missing value)
• "#Distinct": Number of distinct values
• "Sample": The first 10 such values

getMeasures

ResultMatrix getMeasures()

Returns:

ResultMatrix with a row for each numeric projection profiled. Columns are

• "Min": Lowest value
• "Max": Highest value
• "Mean": The population' mean or average value
• "Std"": The population's standard deviation
• "#": Number of values in total (matching the number of rows in the query result set)
• "#Nulls" Number of rows with a null value (i.e. missing value)

getMap

Map<String,Object> getMap()

All the results in map format, for fluent access in Groovy

Returns:

Map containing entries ."Sample", ."Mean" etc.