DataMemberCaptionTemplate (Dimension Interface)

ms133413.note(zh-cn,SQL.90).gif注意:
  下一版本的 Microsoft SQL Server 将删除该功能。请不要在新的开发工作中使用该功能,并尽快修改当前还在使用该功能的应用程序。

The DataMemberCaptionTemplate property of the Dimension interface contains a template string that is used to create captions for system-generated data members.

Applies To:clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension

Data Type

String

Access

Access depends on the value of the ClassType property of the object.

Class type Access

clsDatabaseDimension

R/W*

clsCubeDimension

R

clsPartitionDimension

R

clsAggregationDimension

R

*Read/write for objects of ClassType clsDatabaseDimension with a SubClassType of sbclsParentChild or sbclsMining, read-only for all others.

备注

This property is used in conjunction with the MembersWithData property. It is used to automatically generate captions for system-generated data members.

The data member captions are generated by substituting the caption of the associated member for the asterisk (*) placeholder character in the property string. The default data member caption template is "(* Data)".

For example, the template "(* Salary)" produces the caption "(John Doe Salary)" for the system-generated data member associated with the member John Doe.

This property is ignored when the MembersWithData property is dataforLeafMembersOnly.

示例

The following code example constructs a template for data members that will supply captions similar to (Subtotals for John Doe):

' Assume the existence of a database dimension named dsoDim.
dsoDim.DataMemberCaptionTemplate = "(Subtotals for *)"

请参阅

参考

Dimension Interface
MembersWithData (Dimension Interface)

帮助和信息

获取 SQL Server 2005 帮助