Skip to main content

%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:
&[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.

Method Inventory

Parameters

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.
parameter CACHECOMPUTEDBITSET = 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

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

Inherited Methods

FeedbackOpens in a new tab