|
IRISLIB database
|
|
|
IRISLIB database
|
|
This class implements a computed dimension that uses SQL statements against the cube fact table to resolve members. More...
Static Public Attributes | |
| CACHECOMPUTEDBITSET = None | |
| Controls whether results of <method>OnComputeBitset</method> can be reused. More... | |
 Static Public Attributes inherited from Base | |
| BEHAVIOR = None | |
| Controls the run-time behavior of the dimension. More... | |
| CACHECOMPUTEDBITSET = None | |
| Controls whether results of <method>OnComputeBitset</method> can be reused. More... | |
| DIMTYPE = None | |
| Type reported back to the UI. More... | |
| Static Public Attributes inherited from RegisteredObject | |
| CAPTION = None | |
| Optional name used by the Form Wizard for a class when generating forms. More... | |
| JAVATYPE = None | |
| The Java type to be used when exported. | |
| PROPERTYVALIDATION = None | |
| This parameter controls the default validation behavior for the object. More... | |
Private Member Functions | |
| _.Library.Status | MemberSearch (_.Library.String pSearchKey, _.Library.List pList) |
| Execute a search for members. More... | |
| _.Library.Status | OnComputeBitset (_.Library.String pSpec, _.Library.String pIndexKey) |
| Build the bitset that corresponds to the given computed dimension "spec". | |
| _.Library.Status | ResolveKey (_.Library.String pSpec, _.Library.String pRKey) |
| Resolve any special tokens or expression in a key value and return the result. | |
Additional Inherited Members | |
| Public Member Functions inherited from Base | |
| _.DeepSee.Query.query | GetCurrentQuery () |
| Returns the DeepSee.Query.query object for the current query context, if any. | |
| Public Member Functions inherited from RegisteredObject | |
| _.Library.Status | OnAddToSaveSet (_.Library.Integer depth, _.Library.Integer insert, _.Library.Integer callcount) |
| This callback method is invoked when the current object is added to the SaveSet,. More... | |
| _.Library.Status | OnClose () |
| This callback method is invoked by the <METHOD>Close</METHOD> method to. More... | |
| _.Library.Status | OnConstructClone (_.Library.RegisteredObject object, _.Library.Boolean deep, _.Library.String cloned) |
| This callback method is invoked by the <METHOD>ConstructClone</METHOD> method to. More... | |
| _.Library.Status | OnNew () |
| This callback method is invoked by the <METHOD>New</METHOD> method to. More... | |
| _.Library.Status | OnValidateObject () |
| This callback method is invoked by the <METHOD>ValidateObject</METHOD> method to. More... | |
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.
|
private |
Execute a search for members.
Return a list of the form:
pList(n) = $LB(value,key)
Reimplemented from Base.
|
static |
Controls whether results of <method>OnComputeBitset</method> 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.
1.9.1