This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Home > Class Reference > %SYS namespace > %DeepSee.ComputedDimension.SQL


class %DeepSee.ComputedDimension.SQL extends %DeepSee.ComputedDimension.Base

This class implements a computed dimension that uses SQL statements against the cube fact table to resolve members.
For example:
-- $$$TABLE is replaced with Fact Table name.
WHERE %SEARCH.&[MxUnitsSold > 4]
-- Expression is used as WHERE clause in query on FactTable WHERE %SEARCH.&[$$$FACT > 4]
-- $$$Fact is fact defined for the computed dimension.

Method Inventory (Including Private)


parameter BEHAVIOR = SQL;
Inherited description: Controls the run-time behavior of the dimension. Available values are "BITSET", and "MDX".
BITSET (default) indicates that this class will compute a set of bits that define membership within a given dimension member.
MDX indicates that this class will return a set of valid MDX expressions that will be used to resolve the members of the dimension.

Methods (Including Private)

method %MemberSearch(pSearchKey As %String, Output pList As %List) as %Status
Execute a search for members.
Return a list of the form:
pList(n) = $LB(value,key)
method %OnComputeBitset(pSpec As %String, pIndexKey As %String) as %Status
Build the bitset that corresponds to the given computed dimension "spec".
method %ResolveKey(pSpec As %String, Output pRKey As %String) as %Status
Resolve any special tokens or expression in a key value and return the result.

Inherited Members

Inherited Properties (Including Private)

Inherited Methods (Including Private)