Show TOC

Function documentationEvDRE Syntax Locate this document in the navigation structure

 

The EvDRE function has two required parameters and one optional parameter.

Syntax

EVDRE (AppName, Key range, Expand range)

Parameter

Description

AppName

(Required) The name of the application from which to retrieve, or where to send data. See EvDRE Parameters.

Key range

(Required) The cell range that displays the dimension IDs that are either static or dynamic from the current view. See Key Range Parameter.

Expand range

(Optional) The definition of the expansion to perform. See Expand Range Parameter. When you are defining a static report, that is, one where no expansions are used, you can leave the Expand range parameter in EvDRE blank.

Error Checking

When you build a workbook using EvDRE, the system checks the syntax of the function, and displays a descriptive status message within the control panel section of the workbook. The status message informs you of syntax and other data-related issues. If the status is OK, the EvDRE parameters have the correct syntax. If the status starts with #ERR, an error has been detected. The status message provides a short description of the problem.