Open Exchange
Global Masters
Home / Class Reference / ENSLIB namespace / %DeepSee.PlugIn.Median
Private  Storage   


class %DeepSee.PlugIn.Median extends

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


Parameters Properties Methods Queries Indices ForeignKeys Triggers
3 4


%cacheKey %cellContext %cubeName %data
%factCount %filterValues %fromCache %id
%message %plugInListingKey %queryKey %rangeLower
%rangeUpper %seriesCount %seriesNames %source
%sqlResultSet %thresholdLower %thresholdUpper

%%OIDGet %AddToSaveSet %ApplyDefaults %BindExport
%BuildObjectGraph %CheckResource %ClassIsLatestVersion %ClassName
%ClearKPICache %Close %ComputeKPI %ComputeKPICacheKey
%ComputeKPITimestamp %ConstructClone %CopyDataFromModel %CopyDataToModel
%CreateKPIController %CreateLocalController %CreateModelInstance %DeleteModel
%DispatchClassMethod %DispatchGetModified %DispatchGetProperty %DispatchMethod
%DispatchSetModified %DispatchSetMultidimProperty %DispatchSetProperty %ExecuteMDX
%ExecuteSQL %Extends %Generate %GetActionList
%GetAnalysisResultSet %GetBaseCube %GetFilterDisplayValue %GetFilterKey
%GetFilterList %GetFilterLogicalValue %GetFilterMembers %GetJSValidationCode
%GetKPICaption %GetKPICaptionName %GetKPIClassTimeStamp %GetKPIName
%GetKPIPropertyCaption %GetKPIPropertyInfo %GetKPIValue %GetKPIValueArray
%GetListingResultSet %GetLookupSQL %GetMDX %GetMDXContextFilter
%GetMDXForFilter %GetMDXText %GetMembersForFilter %GetParameter
%GetPlugInType %GetPropertyInfo %GetPropertyList %GetSQL
%GetSQLForFilter %GetSQLText %GetSourceType %IncrementCount
%InvokeAction %InvokeDashboardAction %IsA %IsAsync
%IsCacheable %IsModified %IsPublic %IsReadOnly
%LoadKPIFromCache %New %NormalizeObject %ObjectModified
%OnCompute %OnComputeKPICacheKey %OnComputeKPITimestamp %OnCopyDataFromModel
%OnCopyDataToModel %OnDashboardAction %OnDeleteModel %OnDeleteSource
%OnExecute %OnGetActionList %OnGetAnalysisResultSet %OnGetFilterList
%OnGetFilterMembers %OnGetKPICaption %OnGetKPIPropertyInfo %OnGetListingFields
%OnGetListingMaxRows %OnGetListingOrderBy %OnGetListingResultSet %OnGetListingSQL
%OnGetListingSource %OnGetMDX %OnGetPropertyInfo %OnGetSQL
%OnInvokeAction %OnKPICleanup %OnLoadKPI %OnLoadKPIFromCache
%OnLoadModel %OnNewSource %OnOpenSource %OnSaveKPIToCache
%OnSaveSource %OnStoreModel %OnSubmit %OpenModel
%OriginalNamespace %PackageName %PrintValue %QueueKPI
%RemoveFromSaveSet %SaveKPIToCache %SaveModel %SerializeObject
%SetModified %SetPercentComplete %SplitList %SubmitHandler
%TestKPICache %ValidateKPICache %ValidateObject ConvertParameter
Decrypt Encrypt EncryptBroker EscapeHTML
EscapeURL HyperEventBody HyperEventCall HyperEventFrame
HyperEventHead Include InsertHiddenField InsertHiddenFields
IsPrivate Link Median OnHTTPHeader
OnPage OnPageError OnPostHTTP OnPostHyperEvent
OnPreHTTP OnPreHyperEvent Page QuoteJS
RewriteURL ShowError StartTimer StopTimer
ThrowError UnescapeHTML UnescapeURL


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


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