Please can somebody tell me how I can retrieve the setting for the MDX
Unique Names Style property of an Analysis server. I know where to
find it in the registry, but I need to be able to get it by querying
the Analysis server, either via ADO, DSO or a SQL query.

Thank-you!

Hi,

You can use the PivotTable Service Properties, see also BOL for more
information.

MDX Unique Name Style Property
This property determines which algorithm is used to generate unique names.

Property Name
MDX Unique Name Style

Property ID
DBPROP_MSMD_MDXUNIQUENAMES

Remarks
Because members in Microsoft® SQL Server™ 2000 Analysis Services can change
position in a dimension, the method for generating unique names in SQL
Server version 7.0 OLAP Services may result in an unstable unique name over
time. To accommodate this change, you can use this property to specify the
algorithm for generating unique names. Use the following table to specify
which algorithm to use.

Value Description
0 Default. For compatibility with earlier versions, this is the same as
Value 2. The meaning of this default value is subject to change in future
versions.
1 Key path algorithm: [dim].&[k1].&[k2]
2 Compatible with version 7.0, name path algorithm: [dim].[n1].[n2]
3 Compatible with SQL Server 2000 Analysis Services. The algorithm uses
guaranteed unique names, which are stable over time.

This property overrides the following registry setting:

HKEY_CLASSES_ROOT\CLSID\{a07ccd00-8148-11d0-87bb-00c04fc33942}

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."