InterSystems IRIS Data Platform 2021.1Opens in a new window > Class Reference > %SYS namespace > %DeepSee.PlugIn.Percentile

%DeepSee.PlugIn.Percentile

class %DeepSee.PlugIn.Percentile extends %DeepSee.KPIPlugIn

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

Method Inventory (Including Private)

Parameters

parameter BASECUBE = *;
Cube(s) that this plug-in is based on.
parameter LISTINGSOURCE = FactTable;
Inherited description: Specifies the source of the listing data used by this plugin: "SourceTable" - the data source supplies the listing values; "FactTable" - the fact table supplies the listing values.
parameter PLUGINTYPE = Aggregate;
Inherited description: Specifies the type of this plug-in. This indicates the context in which this plug-in is used.
"Pivot" -- the plug-in is visible within the Analyzer dimension tree.
"Aggregate" -- the plug-in is not visible within the Analyzer dimension tree.

Methods (Including Private)

method %OnCompute(pSQLRS As %SQL.StatementResult, pFactCount As %Integer) as %Status [ Language = objectscript ]
Compute the median of values within the result set.
method %OnGetAnalysisResultSet(Output pRS As %SQL.StatementResult, pSQL As %String) as %Status [ Language = objectscript ]
Return an %SQL.StatementResult object that will iterate over the facts used for analysis.
method %OnGetListingFields() as %String [ Language = objectscript ]
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.
method %OnGetMDX(ByRef pMDX As %String) as %Status [ Language = objectscript ]
Get the base query for this plug-in.

Inherited Members

Inherited Properties (Including Private)

Inherited Methods (Including Private)

FeedbackOpens in a new window