Skip to main content


class %DeepSee.PlugIn.CreateTable extends %DeepSee.KPIPlugIn

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

Method Inventory


parameter ASYNC = 0;
Inherited description: If true, then this KPI can be executed asychronously.
parameter BASECUBE = *;
Cube(s) that this plug-in is based on.
parameter CACHEABLE = 0;
Inherited description: If true, then results for this KPI can be cached.
parameter LISTINGSOURCE = SourceTable;
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.


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