EPMDimensionList

This function retrieves the list of dimensions of the model or cube for the specified connection. You can display the dimensions:

in the current cell, where a specified character separates the dimension names.
in one or more dropdown lists.

Note When using an SAP BW (INA Provider) connection, all the dimensions included in the query are listed, even the ones that are not available in the resulting report in the EPM plug-in.

Parameter	Description
connection name	Name of the connection. For details about the syntax you must use, see Connection Name Parameter - Syntax.
range	To display the dimensions in one or more dropdown lists, specify a cell or a range of cells. A drop-down list will be created in each cell. If the list of dimensions 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.
separator	Specify a separator if you want the dimensions to be displayed in the current cell. If you do not specify a separator, the list separator from your local settings is applied. Optional.
all-value range	Specify the range (a row or a column) where to retrieve all the dimensions. All the dimensions will be consequently displayed in the drop-down list(s) of the range specified in the Range parameter. Optional.