Skip to main content

%DeepSee.PlugIn.CreateTable

Class %DeepSee.PlugIn.CreateTable Extends %DeepSee.KPIPlugIn [ System = 4 ]

This plugin runs code to generate a new source class from a selection in a pivot table.

Parameters​

CACHEABLE​

Parameter CACHEABLE = 0;

ASYNC​

Parameter ASYNC = 0;

BASECUBE​

Parameter BASECUBE = "*";

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

LISTINGSOURCE​

Parameter LISTINGSOURCE = "SourceTable";

PLUGINTYPE​

Parameter PLUGINTYPE = "Aggregate";

XDatas​

KPI​

XData KPI [ XMLNamespace = "http://www.intersystems.com/deepsee/kpi" ]

Methods​

%OnGetMDX​

Method %OnGetMDX(ByRef pMDX As %String) As %Status

Get the base query for this plug-in.

%OnGetListingFields​

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.

%OnGetAnalysisResultSet​

Method %OnGetAnalysisResultSet(Output pRS As %SQL.StatementResult, pSQL As %String) As %Status

Return an %SQL.StatementResult object that will iterate over the facts used for analysis.

%OnCompute​

Method %OnCompute(pSQLRS As %SQL.StatementResult, pFactCount As %Integer) As %Status

Read the listing's resultset and generate a new class to contain the records.