The LISTBY program produces a report of the names of all objects in an analytic 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.
A list of one or more dimensions or composites, separated by spaces. When you list multiple dimensions, 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 ...
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.
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 10-31 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
.
LISTBY product market
1 objects dimensioned by or related to PRODUCT, MARKET ---------------------------------------------------------- UNITS.M