![]() Previous |
![]() Next |
Table: Objects in Expressions summarizes how Oracle OLAP uses the data in an object used as an argument in an expression.
Objects in Expressions
Object | Use in Expressions |
---|---|
Variables |
As a one-dimensional or multi-dimensional array of data, depending on its definition. For example, as the target or source expression in an assignment statement. See also: "Using Variables and Relations in Expressions" and "Using Objects in Assignment Statements". |
Relations |
As a one-dimensional or multi-dimensional of data, depending on its definition. For example, as the target or source expression in an assignment statement as outlined in "Using Objects in Assignment Statements".
See also: "Using Variables and Relations in Expressions" , "Using Related Dimensions in Expressions". |
Dimensions |
As a one-dimensional array of data. When you use a See also: "Specifying a Value of a CONCAT Dimension" and "Using Related Dimensions in Expressions". |
Composites |
You can use a composite wherever you can use a dimension. See also: "Specifying a Value of a Composite" . |
Valuesets |
As a list of dimension values. See also: "Using Variables and Relations in Expressions" and the DEFINE VALUESET command. |
Dimension surrogates |
As a one-dimensional array. A surrogate provides an alternative set of values for a dimension. When you use a Note: You can use a surrogate rather than a dimension in a model, in a LIMIT command, in a qualified data reference, or in data loading with statements such as FILEREAD, FILEVIEW, SQL FETCH, and SQL IMPORT. A surrogate cannot be a participant object in any argument in a DEFINE statement that defines another object. |
Formulas |
As a sub-expression or as an expression in a statement. |
Programs |
For a program that does not return a value, use the program name as you would an OLAP DML command. For a program that returns a value, invoke the program the same way you invoke an OLAP DML function— use the program name in then expression and enclose the program arguments, if any, in parentheses. |