Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
|
|
View PDF |
The LISTBY program produces a report of the names of all objects in a workspace that are dimensioned by or related to one or more specified dimensions or composites. You can use LISTBY with a dimension or composite in any attached workspace.
Syntax
LISTBY dimensions
Arguments
A list of one or more dimensions or composites, separated by spaces. When you list more than one dimension, all the dimensions must be in the same workspace. LISTBY returns a list of objects that are dimensioned by all the dimensions you specify. When you specify an unnamed composite, use the following format:
LISTBY SPARSE dim1 dim2 ...
Notes
Composites and Conjoint Dimensions
The report produced by LISTBY includes any named or unnamed composite, or conjoint dimension, whose base dimension list includes the dimensions you specify.
The report also includes any object whose dimension list includes a named or unnamed composite that in turn has the specified dimensions as base dimensions.
Examples
Example 16-26 Using LISTBY
LISTBY is used here to list the name of every object that is dimensioned by or related to product
. The statement
LISTBY product
produces the following output.
15 objects dimensioned by or related to PRODUCT ---------------------------------------------------------------- ADVERTISING DIVISION.PRODUCT EXPENSE INDUSTRY.SALES NAME.PRODUCT NATIONAL.SALES PRICE PRODUCT.MEMO PRODUCTSET SALES SALES.FORECAST SALES.PLAN SHARE UNITS UNITS.M
Example 16-27 Specifying More Than One Dimension
In this example LISTBY is used to list the name of every object that is dimensioned by or related to both product
and market
. The statement
LISTBY product market
produces the following output.
1 objects dimensioned by or related to PRODUCT, MARKET ---------------------------------------------------------- UNITS.M