Skip to main content

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

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.
method %OnGetMDX(ByRef pMDX As %String) as %Status
Get the base query for this plug-in.

Inherited Members

Inherited Properties

Inherited Methods

FeedbackOpens in a new tab