Show TOC

EPMDimensionPropertyValuesLocate this document in the navigation structure

This function retrieves the values of a specified property, for 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. Mandatory.
property Name of the property for which you want to return the values. Mandatory.
cell

Specify the cell in which the dropdown list containing the values will be displayed. If the list of values exceeds 255 characters, specify a range in the all-value range parameter. Optional.

If not specified, the values are displayed in the cell in which you have entered the function.

all-value range Specify the range (a row or a column) where to retrieve all the values. All the values will be consequently displayed in the drop-down list of the cell specified in the cell parameter. Optional.