Class Reference
Cache for UNIX 2018.1.3
InterSystems: The power behind what matters   
Documentation  Search
Private  Storage  

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

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
18 6 3 3


Summary

Properties
DataMart DataMartName Folder FolderName Formula
IsActive KPIChild KPIMaximum KPIMinimum KPIName
KPIQuery MetricName Metrics RangeDisplay RangeKPIDR
RangeKPIDRName StaticDays Variable

Methods
%AddToSaveSet %AddToSyncSet %BMEBuilt %CheckConstraints
%CheckConstraintsForExtent %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 %IsNull
%KillExtent %KillExtentData %LoadFromMemory %LockExtent
%LockId %New %NormalizeObject %ObjectIsNull
%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 %ValidateIndices %ValidateObject FolderNameGet
GetDataMartName GetMetricName KPIValue MetricNameGet
RangeKPIDRNameGet XMLDTD XMLExport XMLExportToStream
XMLExportToString XMLNew XMLSchema XMLSchemaNamespace
XMLSchemaType


Properties

• 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);

Methods

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

Queries

• 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

Indices

• index (DM on DataMart:Exact);
• index (Folder on Folder:Exact);
• index (KPINameIdx on KPIName) [Unique];


Copyright © 1997-2019, InterSystems Corporation