Export (0) Print
Expand All
Expand Minimize

MDX Unique Name Style Property

SQL Server 2000

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}
Show:
© 2014 Microsoft