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.