Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The OBJORG function takes, as input, the name of an OLAP cube or cube dimension as defined in the Oracle data dictionary (sometimes called a "logical OLAP object") and returns information about the lower-level, "physical," analytic workspace objects by which that cube or cube dimension is implemented.
Use this function in OLAP DML statements that require an analytic workspace object name rather than an OLAP cube or cube dimension name.
See also:
"Cube-Aware OLAP DML Statements"Analytic workspace object name or TEXT
; or NA
if an analytic workspace has the requested definition information, but the field is empty.
OBJORG(keyword [OWNER owner ] top-level-object-name [ sub-object-name ] )
The valid keywords vary by the type of top-level-object or sub-object specified, as documented in:
Table 8-4, "Keywords when the top-level-object is a Cube and the sub-object is a Measure".
Table 8-6, "Keywords when the top-level-object is a Cube Dimension".
Table 8-3 Keywords when the top-level-object is a Cube
Keyword | Returns |
---|---|
|
The aggmap for the cube. (Note: The function will never return NA when you specify this keyword.) |
|
When a composite is used for the cube, the name of the composite; or NA if the cube's sparsity type is DENSE, or if the cube is partitioned. (See also the keyword |
|
(Property.) The DML data type used for all of the cube's measures; or NA if there is no such single data type (that is, if different measures have different data types). |
|
When the value returned for the keyword |
|
The text variable, dimensioned by |
|
The analytic workspace dimension that contains the names of the partitions for the cube; or NA if the cube is not partitioned. |
|
The relation, dimensioned by |
|
The partition template relating each cube partition to its corresponding analytic workspace dimension values; or NA if the cube is not partitioned. |
|
When the cube has a storage type, the variable (of that type) that stores all of the cube's measures; or NA when it does not. |
|
(Property.) The cube sparsity type. Valid values are: COMPRESSED, SPARSE, DENSE, or SPARSE_GLOBAL. Corresponds to column SPARSE_TYPE in the USER_CUBES and ALL_CUBES views. |
Table 8-4 Keywords when the top-level-object is a Cube and the sub-object is a Measure
Keyword | Returns |
---|---|
|
When the value returned when you specify the |
|
The aggmap for the measure, if the measure has one; otherwise returns NA. (Note that when the measure has no aggmap, then the cube's aggmap is used.) |
Table 8-5 Keywords when the top-level-object is Cube and the sub-object is a Dimension Calculation Model
Keyword | Returns |
---|---|
|
If the cube's consistent solve specification specifies an aggregation at a specific level, the valueset consisting of all members of the dimension that belong to that level; otherwise, NA. |
|
The valueset containing the names of all hierarchies of the analytic workspace dimension over which the cube is aggregated. (Note that when you specify this keyword, the function never returns NA.) |
|
If at least one of the cube's measures has an |
|
When the cube organization specifies a precompute condition, the valueset containing all members of the dimension that satisfy that condition; otherwise NA. (In particular, when the cube organization specifies a precompute percent, returns NA.) |
Table 8-6 Keywords when the top-level-object is a Cube Dimension
Keyword | Returns |
---|---|
|
The relation, dimensioned by |
|
The relation, dimensioned by |
|
The relation, dimensioned by |
|
The analytic workspace physical dimension corresponding to this logical dimension. (Note that when you specify this keyword, the function never returns NA.) |
|
The variable, dimensioned by |
|
The relation, dimensioned by |
|
The relation, dimensioned by |
|
The dimension containing all hierarchies for this dimension. (Note that when you specify this keyword, the function never returns NA.) |
|
The valueset, dimensioned by |
|
The variable, dimensioned by |
|
The valueset, dimensioned by |
|
The dimension containing all levels for this dimension. (Note that when you specify this keyword, the function never returns NA, even if the dimension has no levels.) |
|
The relation, dimensioned by the |
|
The relation, dimensioned by |
|
The relation, dimensioned by |
|
The relation, dimensioned by |
|
The relation, dimensioned by |
Table 8-7 Keywords when the top-level-object is a Cube Dimension and the sub-object is a Base Attribute
Keyword | Returns |
---|---|
|
The value returned varies depending on whether or not the dimension is indexed.
(Note that when you specify this keyword, the function never returns NA.) |
|
When the attribute is indexed, the dimension that stores all of the attributes values; otherwise NA. |
|
When the attribute is a unique key attribute, the relation, dimensioned by |
|
When the attribute is a unique key attribute (that is, indexed), the relation, dimensioned by |
Table 8-8 Keywords when the top-level-object is a Cube Dimension and the sub-object is a Dimension Level
Keyword | Returns |
---|---|
|
The surrogate for the owning dimension's |
The owner of the cube or cube dimension identified by top-level-object. If you do not include this clause, the function uses the current owner.
A text expression that specifies the name of the cube or the cube dimension for which information is requested.
A text expression that specifies the name of the "logical" OLAP sub-object, if any, for which information is requested. Valid values vary depending on whether the top-level-object is a cube or a cube dimension:
When top-level-object is a cube, you can specify the name of a measure or dimensionality
When top-level-object is a cube dimension, you can specify the name of a base attribute, hierarchy, dimension level, or dimension calculation model.
Examples of using OBJORG with various keyword appear in several sample OLAP DML programs described within this manual:
For examples of using OBJORG with the Dim keyword, see the following sample OLAP DML programs:
ADD_L1_2 program in Example 9-5, "Adding Members to an OLAP Cube Dimension"
REMOVE_L2_1 program in Example 10-98, "Removing OLAP Cube Dimension Members From a Hierarchy"
SETUP_PRE_MODEL and SETUP_POST_MODEL programs in Example 10-118, "Creating Static and Dynamic Models for an OLAP Cube"
ADD_L1_2_DATES program in Example 10-169, "Updating the Attributes of an OLAP Cube Dimension"
For an example of using OBJORG with the Measure keyword, see the ADD_L1_2 program in Example 9-5, "Adding Members to an OLAP Cube Dimension".
For an example of using OBJORG with the Parentrel keyword, see the REMOVE_L2-1 program in Example 10-98, "Removing OLAP Cube Dimension Members From a Hierarchy".
For examples of using OBJORG with the Attribute keyword, see the following sample programs:
SETUP_POST_MODEL program in Example 10-118, "Creating Static and Dynamic Models for an OLAP Cube"
ADD_L1_2_DATES program in Example 10-169, "Updating the Attributes of an OLAP Cube Dimension"