Class %DeepSee.PlugIn.CreateTable

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

Summary

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

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

Parameters

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

Methods

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

Class Reference IRIS for UNIX 2024.1.2
Documentation Search