Skip to main content

%DeepSee.PlugIn.Median

Class %DeepSee.PlugIn.Median Extends %DeepSee.KPIPlugIn [ System = 4 ]

This Analytic plug-in computes the MEDIAN on a given measure for a given cube.

Parameters​

BASECUBE​

Parameter BASECUBE = "*";

Cube(s) that this plug-in is based on.

LISTINGSOURCE​

Parameter LISTINGSOURCE = "FactTable";

PLUGINTYPE​

Parameter PLUGINTYPE = "Aggregate";

XDatas​

KPI​

XData KPI [ XMLNamespace = "http://www.intersystems.com/deepsee/kpi" ]

Methods​

%OnGetMDX​

Method %OnGetMDX(ByRef pMDX As %String) As %Status

Get the base query for this plug-in.

%OnGetListingFields​

Method %OnGetListingFields() As %String

Returns the field list (RETURN clause) of the listing used to supply data for this plug-in. In this case, determine which measure we need.

%OnCompute​

Method %OnCompute(pSQLRS As %SQL.StatementResult, pFactCount As %Integer) As %Status

Compute the median of values within the result set.

Median​

ClassMethod Median(k)

Find the median value within the temp file.