Access File Attributes

Reference:

An Access File for a FOCUS data source can contain information for multiple Master Files.


Top of page

x
Reference: General Access File Attributes
MASTER

Identifies a Master File.

DATA

Is the fully-qualified physical file name of a partition.

WHERE test1 ;

Supplies a condition that identifies which records are stored in the associated partition.

LOCATION

Identifies a segment stored in a separate physical file. Has an associated DATA attribute to supply the physical file name.


Top of page

x
Reference: MDI Access File Attributes
MDI

Identifies the name of the MDI.

TARGET_OF

Identifies the segment that contains the measures to which the MDI points. If the measures are in multiple segments, identifies the top segment that contains measures.

DIM

Identifies a field that is a dimension. A minimum of two dimensions are required.

MAXVALUES

Is the number of distinct values the dimension field can have.

WITHIN

Defines a hierarchy of dimensions by naming a child dimension within a parent dimension.

MDIDATA

Identifies the physical name of the MDI file. Multiple MDIDATAs describe concatenated partitions.


Information Builders