%DeepSee.ComputedDimension.SQL

Class %DeepSee.ComputedDimension.SQL Extends %DeepSee.ComputedDimension.Base [ System = 4 ]

This class implements a computed dimension that uses SQL statements against the cube fact table to resolve members.
For example:
&[SELECT ID FROM $$$TABLE WHERE MxUnitsSold > 4]
-- $$$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.

Parameters

BEHAVIOR

Parameter BEHAVIOR = "SQL";

CACHECOMPUTEDBITSET

Parameter CACHECOMPUTEDBITSET As STRING [ Constraint = ",NEVER,CHECK", Flags = ENUM ] = "CHECK";

Controls whether results of %OnComputeBitset can be reused Available values are "NEVER", "CHECK", with NEVER meaning no values are cached and CHECK meaning the timestamp of previous %OnComputeBitset results is compared to the cube's latest update timestamp.

Methods

%ResolveKey

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.

%OnComputeBitset

Method %OnComputeBitset(pSpec As %String, pIndexKey As %String) As %Status

Build the bitset that corresponds to the given computed dimension "spec".

%MemberSearch

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)