Home > Class Reference > %SYS namespace > %DeepSee.PlugIn.Median


class %DeepSee.PlugIn.Median extends %DeepSee.KPIPlugIn

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


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.


method %OnCompute(pSQLRS As %SQL.StatementResult, pFactCount As %Integer) as %Status [ Language = objectscript ]
Compute the median of values within the result set.
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.
classmethod Median(k) [ Language = objectscript ]
Find the median value within the temp file.

Inherited Methods

%AddToSaveSet() %IsA() %OriginalNamespace()
%CheckResource() %IsAsync() %PackageName()
%ClassIsLatestVersion() %IsCacheable() %PrintValue()
%ClassName() %IsModified() %RemoveFromSaveSet()
%ClearKPICache() %IsPublic() %SaveKPIToCache()
%ComputeKPICacheKey() %IsReadOnly() %SaveModel()
%ComputeKPITimestamp() %LoadKPIFromCache() %SerializeObject()
%ConstructClone() %New() %SetModified()
%CreateKPIController() %NormalizeObject() %SetPercentComplete()
%CreateModelInstance() %ObjectModified() %SubmitHandler()
%DeleteModel() %OnComputeKPITimestamp() %TestKPICache()
%DispatchClassMethod() %OnCopyDataFromModel() %ValidateKPICache()
%DispatchGetModified() %OnCopyDataToModel() %ValidateObject()
%DispatchMethod() %OnDashboardAction() ConvertParameter()
%DispatchSetModified() %OnDeleteModel() Decrypt()
%DispatchSetMultidimProperty() %OnDeleteSource() Encrypt()
%Extends() %OnExecute() EscapeHTML()
%GetBaseCube() %OnGetActionList() EscapeURL()
%GetFilterDisplayValue() %OnGetAnalysisResultSet() HyperEventCall()
%GetFilterKey() %OnGetFilterList() HyperEventHead()
%GetFilterLogicalValue() %OnGetFilterMembers() Include()
%GetJSValidationCode() %OnGetKPICaption() InsertHiddenField()
%GetKPICaption() %OnGetKPIPropertyInfo() InsertHiddenFields()
%GetKPICaptionName() %OnGetListingMaxRows() IsPrivate()
%GetKPIClassTimeStamp() %OnGetListingOrderBy() Link()
%GetKPIName() %OnGetListingResultSet() OnHTTPHeader()
%GetKPIPropertyCaption() %OnGetListingSQL() OnPage()
%GetKPIValue() %OnGetListingSource() OnPageError()
%GetKPIValueArray() %OnGetPropertyInfo() OnPostHTTP()
%GetMDXContextFilter() %OnGetSQL() OnPostHyperEvent()
%GetMDXForFilter() %OnInvokeAction() OnPreHTTP()
%GetMDXText() %OnLoadKPI() OnPreHyperEvent()
%GetMaxListingRows() %OnLoadKPIFromCache() Page()
%GetMembersForFilter() %OnLoadModel() QuoteJS()
%GetParameter() %OnNewSource() RewriteURL()
%GetPlugInType() %OnOpenSource() ShowError()
%GetPropertyInfo() %OnSaveKPIToCache() StartTimer()
%GetSQLForFilter() %OnSaveSource() StopTimer()
%GetSQLText() %OnStoreModel() ThrowError()
%GetSourceType() %OnSubmit() UnescapeHTML()
%InvokeAction() %OpenModel() UnescapeURL()