116 QUALIFY_ROWS= LIBNAME Option Chapter 9
See Also
To apply this option to an individual data set, see the data set option “QUALIFIER=
Data Set Option” on page 202.
QUALIFY_ROWS= LIBNAME Option
Uniquely qualifies all member values in a result set
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support:
OLE DB
Default value:
NO
Syntax
QUALIFY_ROWS= YES | NO
Syntax Description
YES
specifies that when the OLE DB interface flattens the result set of an MDX
command, the values in each column are uniquely identified using a hierarchical
naming scheme.
NO
specifies that when the OLE DB interface flattens the result set of an MDX command,
the values in each column are not qualified, which means they may not be unique.
Details
For example, when this option is set to NO, a GEOGRAPHY column might have a value
of
PORTLAND for
Portland, Oregon, and the same value of
PORTLAND for Portland,
Maine
. When you set this option to YES, the two values might become
[USA].[Oregon].[Portland]
and [USA].[Maine].[Portland], respectively.
Note: Depending on the size of the result set, QUALIFY_ROWS=YES can have a
significant, negative impact on performance, because it forces the OLE DB interface to
search through various schemas to gather the information needed to created unique
qualified names.
For more information on MDX commands, see the SAS/ACCESS documentation for
OLE DB.
QUERY_TIMEOUT= LIBNAME Option
Specifies the number of seconds of inactivity to wait before canceling a query
Valid in: the SAS/ACCESS LIBNAME statement
