Skip to main content

%DeepSee.PlugIn.Percentile

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

This Analytic plug-in computes the PERCENTILE 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.

%OnGetAnalysisResultSet​

Method %OnGetAnalysisResultSet(Output pRS As %SQL.StatementResult, pSQL As %String) As %Status

Return an %SQL.StatementResult object that will iterate over the facts used for analysis.