Displaying a Multi-Dimensional Index (MDI)

How to:

The ? MDI command generates statistics and descriptions for multi-dimensional indexes. You can display information about MDIs for a given FOCUS or XFOCUS Master File that hosts the target of your MDI.

Syntax: How to Query a Multi-Dimensional Index

To display MDIs, issue the command

? MDI mastername {mdiname|*} [HOLD [AS holdfile]]

where:

mastername

Is the logical name of the Master File. If you do not include any other parameters, a list of all MDI names specified is displayed with the command TARGET_OF in the Access File for this mastername. If the Access File for the mastername does not have any MDI information, an error message will display.

mdiname

Is the logical name of an MDI. Specifying this parameter displays all the dimensions that are part of this MDI.

*

Displays a list of all dimensions, by MDI, whose targets are specified inside the Access File for this mastername.

HOLD

Saves the output in a text file.

holdfile

Is the file in which the output is saved. If the AS phrase is omitted, the file name is HOLD.

Example: Displaying MDIs

Issuing the command

? mdi car *

produces results similar to the following, showing the MDI name and a segment and field for each dimension:

CARMDI
 COMP.CAR
 ORIGIN.COUNTRY
 CARREC.MODEL

Information Builders