Class %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.

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
3		4

Summary

Properties
%factCount	%filterValues	%fromCache	%id
%message	%plugInListingKey	%rangeLower	%rangeUpper
%seriesCount	%seriesNames	%source	%sqlResultSet
%thresholdLower	%thresholdUpper

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

Parameters

• parameter BASECUBE = "*";

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

• parameter LISTINGSOURCE = "FactTable";

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";

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

• method %OnCompute(pSQLRS As %SQL.StatementResult, pFactCount As %Integer) as %Status

Compute the median of values within the result set.

• 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.

• method %OnGetMDX(ByRef pMDX As %String) as %Status

Get the base query for this plug-in.

• classmethod Median(k)

Find the median value within the temp file.

Class Reference IRIS for UNIX 2024.1.2
Documentation Search