Class %BI.KPI

persistent class %BI.KPI extends %Persistent, %XML.Adaptor

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
	18	6	3	3

Methods
%%OIDGet	%AddToSaveSet	%AddToSyncSet	%BMEBuilt
%BuildIndices	%CheckUnique	%ClassIsLatestVersion	%ClassName
%ComposeOid	%ConstructClone	%Delete	%DeleteExtent
%DeleteId	%DispatchClassMethod	%DispatchGetModified	%DispatchGetProperty
%DispatchMethod	%DispatchSetModified	%DispatchSetMultidimProperty	%DispatchSetProperty
%Exists	%ExistsId	%Extends	%GUID
%GUIDSet	%GetLock	%GetParameter	%GetSwizzleObject
%Id	%InsertBatch	%IsA	%IsModified
%KillExtent	%KillExtentData	%LoadFromMemory	%LockExtent
%LockId	%New	%NormalizeObject	%ObjectModified
%Oid	%OnBeforeAddToSync	%OnDetermineClass	%Open
%OpenId	%OriginalNamespace	%PackageName	%PhysicalAddress
%PurgeIndices	%Reload	%RemoveFromSaveSet	%ResolveConcurrencyConflict
%RollBack	%Save	%SaveDirect	%SaveIndices
%SerializeObject	%SetModified	%SortBegin	%SortEnd
%SyncObjectIn	%SyncTransport	%UnlockExtent	%UnlockId
%ValidateObject	FolderNameGet	GetDataMartName	GetMetricName
KPIValue	MetricNameGet	RangeKPIDRNameGet	XMLDTD
XMLExport	XMLExportToStream	XMLExportToString	XMLNew
XMLSchema	XMLSchemaNamespace	XMLSchemaType

• property DataMart as %String(TRUNCATE=1);

• property DataMartName as %String(TRUNCATE=1) [ Calculated ];

• property Folder as %String(TRUNCATE=1);

• property FolderName as %String(TRUNCATE=1) [ Calculated ];

• property Formula as %String(MAXLEN=20000,TRUNCATE=1);

• property IsActive as %Boolean;

• property KPIChild as array of %BI.KPIList;

• property KPIMaximum as %String;

• property KPIMinimum as %String;

• property KPIName as %String(MAXLEN=2000,TRUNCATE=1);

• property KPIQuery as %String(MAXLEN=20000,TRUNCATE=1);

• property MetricName as %String(TRUNCATE=1) [ Calculated ];

• property Metrics as %String(MAXLEN=200,TRUNCATE=1);

• property RangeDisplay as array of %BI.RangeDisplay;

• property RangeKPIDR as %String(MAXLEN=10,TRUNCATE=1);

• property RangeKPIDRName as %String(TRUNCATE=1) [ Calculated ];

• property StaticDays as %Numeric;

• property Variable as %String(MAXLEN=20000,TRUNCATE=1);

• method FolderNameGet() as %String

This is a Get accessor method for the FolderName property.

• classmethod GetDataMartName(dmid As %String) as %String

• classmethod GetMetricName(MetricID As %String) as %String

• method KPIValue() as %String

• method MetricNameGet() as %String

This is a Get accessor method for the MetricName property.

• method RangeKPIDRNameGet() as %String

This is a Get accessor method for the RangeKPIDRName property.

• query ListAll()

SQL Query :
SELECT ID,KPIName,DataMartName,Folder,DataMart
FROM KPI
Order by DataMart

• query ListAll2()

SQL Query :
SELECT ID,KPIName,DataMartName,Folder,DataMart
FROM KPI
Order by KPIName

• query byFolder(folderId As %String)

SQL Query :
SELECT ID,KPIName,DataMartName,DataMart,Formula,KPIQuery,Metrics FROM KPI
WHERE (Folder = :folderId)
ORDER BY KPIName

• index (DM on DataMart:Exact);

• index (Folder on Folder:Exact);

• index (KPINameIdx on KPIName) [Unique];


[BASEXML] > [%BI] > [KPI]		Private Storage