Home > Class Reference > ENSLIB namespace > %DeepSee.PlugIn.CreateTable
Private  Storage   


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

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


Parameters Properties Methods Queries Indices ForeignKeys Triggers
5 4


%factCount %filterValues %fromCache %id
%message %plugInListingKey %rangeLower %rangeUpper
%seriesCount %seriesNames %source %sqlResultSet
%thresholdLower %thresholdUpper

%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
%GetPropertyInfo %GetSQLForFilter %GetSQLText %GetSourceType
%InvokeAction %IsA %IsAsync %IsCacheable
%IsModified %IsPublic %IsReadOnly %LoadKPIFromCache
%New %NormalizeObject %ObjectModified %OnCompute
%OnComputeKPITimestamp %OnCopyDataFromModel %OnCopyDataToModel %OnDashboardAction
%OnDeleteModel %OnDeleteSource %OnExecute %OnGetActionList
%OnGetAnalysisResultSet %OnGetFilterList %OnGetFilterMembers %OnGetKPICaption
%OnGetKPIPropertyInfo %OnGetListingFields %OnGetListingMaxRows %OnGetListingOrderBy
%OnGetListingResultSet %OnGetListingSQL %OnGetListingSource %OnGetMDX
%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


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