Show TOC

EPMDimensionPropertyLocate this document in the navigation structure

This function retrieves the properties of a specified dimension in a specified cell range.

Parameter Description
connection name Name of the connection.

For details about the syntax you must use, see Connection Name Parameter - Syntax.
dimension Name of the dimension for which you want to return the properties. Mandatory.
destination range Cell range in which the properties are displayed. Mandatory.
display ID

Specify whether you want to display the ID or the description of the properties. Optional.

To display the ID of the properties, enter TRUE.

To display the description of the properties, enter FALSE or do not enter anything.

Note One property is displayed in one cell. If you select a smaller number of cells than the number of properties, not all the properties will be displayed. Therefore, you should select a large destination range.