The LIBNAME Statement for Relational Databases |
Uniquely qualifies all member values in a result set.
Default value: |
NO
|
Valid in: |
SAS/ACCESS LIBNAME
statement
|
DBMS support: |
OLE DB
|
-
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.
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. ![[cautionend]](../../../../common/63294/HTML/default/images/cautend.gif)
For more information about MDX commands, see
Accessing OLE DB for OLAP Data.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.