Skip to main content


class HoleFoods.KPISalesVsTarget extends %DeepSee.KPI

Sample KPI for HoleFoods Demo. This KPI provides real sales data compared with budget targets.

Property Inventory

Method Inventory


property FilterClause as %String;
Used to pass filter clause among methods.
Property methods: FilterClauseDisplayToLogical(), FilterClauseGet(), FilterClauseIsValid(), FilterClauseLogicalToDisplay(), FilterClauseLogicalToOdbc(), FilterClauseNormalize(), FilterClauseSet()
property RowClause as %String;
Used to pass ROWS clause among methods.
Property methods: RowClauseDisplayToLogical(), RowClauseGet(), RowClauseIsValid(), RowClauseLogicalToDisplay(), RowClauseLogicalToOdbc(), RowClauseNormalize(), RowClauseSet()


classmethod %OnGetFilterMembers(pFilter As %Library.String, Output pMembers As %Library.List, pSearchKey As %Library.String, pDataSourceName As %Library.String = "", ByRef pFilterValues As %Library.String) as %Status
Callback to get additional members for a KPI filter. This takes the form:
method %OnGetMDX(ByRef pMDX As %String) as %Status
Return an MDX statement to execute.
method %OnLoadKPI() as %Status
Notification that this KPI is being executed. This is a good place to override properties, such as range and threshold.

Inherited Members

Inherited Properties

Inherited Methods

FeedbackOpens in a new tab