QUALIFY_ROWS= LIBNAME Option

Uniquely qualifies all member values in a result set.

Valid in:	SAS/ACCESS LIBNAME statement
Default:	NO
Data source:	OLE DB
See:	Accessing OLE DB for OLAP Data

Syntax

Details

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 might 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. This can occur because it forces the OLE DB interface to search through various schemas to gather the information needed to created unique qualified names.