Returns or sets the name of the object. The name of a Range object is a Name object. For every other type of object, the name is a string.
The following table shows example values of the Name property and related properties, given an OLAP data source with the unique name "[Europe].[France].[Paris]" and a non-OLAP data source with the item name "Paris".
Property | Value (OLAP data source) | Value (non-OLAP data source) |
---|---|---|
Caption | Paris | Paris |
Name | [Europe].[France].[Paris] (read-only) | Paris |
SourceName | [Europe].[France].[Paris] (read-only) | (Same as SQL property value, read-only) |
Value | [Europe].[France].[Paris] (read-only) | Paris |
When specifying an index into the PivotItems collection, you can use the syntax shown in the following table.
Syntax (OLAP data source) | Syntax (non-OLAP data source) |
---|---|
expression.PivotItems("[Europe].[France].[Paris]") | expression.PivotItems("Paris") |
When using the Item property to reference a specific member of a collection, you can use the text index names shown in the following table.
Name (OLAP data source) | Name (non-OLAP data source) |
---|---|
[Europe].[France].[Paris] | Paris |