%DeepSee.PlugIn.Variance
class %DeepSee.PlugIn.Variance extends %DeepSee.KPIPlugIn
This plugin can be used to get the variance of distinct values for a given measure in a given cell. For example:%KPI("%DeepSee.Variance","VARIANCE",1,"%measure","[Amount Sold]","%CONTEXT")
The above returns the variance of the Revenues contained in the set of facts for a cell. Use the "%measure" parameter to tell the plugin which measure should be used
Method Inventory
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.
"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, Output pFactCount As %Library.Integer) as %Status
Compute the variance 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.
Get the base query for this plug-in.
Inherited Members
Inherited Properties
- %factCount
- %filterValues
- %fromCache
- %id
- %message
- %plugInListingKey
- %rangeLower
- %rangeUpper
- %seriesCount
- %seriesNames
- %source
- %sqlResultSet
- %thresholdLower
- %thresholdUpper
Inherited 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()
- %OnComputeKPITimestamp()
- %OnCopyDataFromModel()
- %OnCopyDataToModel()
- %OnDashboardAction()
- %OnDeleteModel()
- %OnDeleteSource()
- %OnExecute()
- %OnGetActionList()
- %OnGetAnalysisResultSet()
- %OnGetFilterList()
- %OnGetFilterMembers()
- %OnGetKPICaption()
- %OnGetKPIPropertyInfo()
- %OnGetListingMaxRows()
- %OnGetListingOrderBy()
- %OnGetListingResultSet()
- %OnGetListingSQL()
- %OnGetListingSource()
- %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()
- OnHTTPHeader()
- OnPage()
- OnPageError()
- OnPostHTTP()
- OnPostHyperEvent()
- OnPreHTTP()
- OnPreHyperEvent()
- Page()
- QuoteJS()
- RewriteURL()
- ShowError()
- StartTimer()
- StopTimer()
- ThrowError()
- UnescapeHTML()
- UnescapeURL()