Class Reference
IRIS for UNIX 2019.3
InterSystems: The power behind what matters   
Documentation  Search
  [ENSLIB] >  [%DeepSee] >  [ComputedDimension] >  [SQL]
Private  Storage   

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
1 3


Summary

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

Methods
%%OIDGet %AddToSaveSet %BindExport
%BuildObjectGraph %ClassIsLatestVersion %ClassName
%Close %ComputeBitset %ComputeIndexKey
%ConstructClone %Count %Create
%CreateIndexFromSQL %CreateIndexFromSearchableMeasure %DispatchClassMethod
%DispatchGetModified %DispatchGetProperty %DispatchMethod
%DispatchSetModified %DispatchSetMultidimProperty %DispatchSetProperty
%Eval %Extends %FindComputedMemberByKey
%FindComputedMemberByName %GetAllMembers %GetBehavior
%GetComputedMembers %GetDimType %GetFactTable
%GetLevelNumber %GetMemberSpec %GetParameter
%GetPredefinedMembers %GetSourceTable %IncrementCount
%IsA %IsModified %MemberSearch
%MemberSearchByIndex %MemberSearchByMembers %New
%NormalizeObject %ObjectModified %OnComputeBitset
%OnGetComputedMembers %OnGetComputedMembersFiltered %OnKillFacts
%OriginalNamespace %PackageName %ProcessSQL
%RemoveFromSaveSet %ResolveKey %SerializeObject
%SetModified %ValidateObject


Parameters

• parameter BEHAVIOR = "SQL";
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

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


Copyright (c) 2019 by InterSystems Corporation. Cambridge, Massachusetts, U.S.A. All rights reserved. Confidential property of InterSystems Corporation.