Class %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.

Inventory

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
		2

Summary

Properties
%baseCube	%cube	%dimNumber	%factName	%factNumber
%hierNumber	%levelNumber

Methods
%%OIDGet	%AddToSaveSet	%ClassIsLatestVersion	%ClassName
%ComputeBitset	%ComputeIndexKey	%ConstructClone	%Count
%Create	%CreateIndexFromSQL	%DispatchClassMethod	%DispatchGetModified
%DispatchGetProperty	%DispatchMethod	%DispatchSetModified	%DispatchSetMultidimProperty
%DispatchSetProperty	%Eval	%Extends	%GetComputedMembers
%GetDimType	%GetFactTable	%GetParameter	%IsA
%IsModified	%MemberSearch	%New	%NormalizeObject
%ObjectModified	%OnComputeBitset	%OnGetComputedMembers	%OnGetComputedMembersFiltered
%OriginalNamespace	%PackageName	%ProcessSQL	%RemoveFromSaveSet
%ResolveKey	%SerializeObject	%SetModified	%ValidateObject

Methods

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


[BASEXML] > [%DeepSee] > [ComputedDimension] > [SQL]		Private Storage