%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.
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
Execute a search for members.
Return a list of the form:
pList(n) = $LB(value,key)
Return a list of the form:
pList(n) = $LB(value,key)
Build the bitset that corresponds to the given computed dimension "spec".
Resolve any special tokens or expression in a key value and return the result.
Inherited Members
Inherited Properties
Inherited Methods
- %AddToSaveSet()
- %ClassIsLatestVersion()
- %ClassName()
- %ComputeBitset()
- %ComputeIndexKey()
- %ConstructClone()
- %Count()
- %Create()
- %CreateIndexFromSQL()
- %CreateIndexFromSearchableMeasure()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Eval()
- %Extends()
- %GetAllMembers()
- %GetBehavior()
- %GetComputedMembers()
- %GetDimType()
- %GetFactTable()
- %GetLevelNumber()
- %GetParameter()
- %GetPredefinedMembers()
- %GetSourceTable()
- %IsA()
- %IsModified()
- %MemberSearchByIndex()
- %MemberSearchByMembers()
- %New()
- %NormalizeObject()
- %ObjectModified()
- %OnGetComputedMembers()
- %OnGetComputedMembersFiltered()
- %OnKillFacts()
- %OriginalNamespace()
- %PackageName()
- %ProcessSQL()
- %RemoveFromSaveSet()
- %SerializeObject()
- %SetModified()
- %ValidateObject()