EPMDriverBasedRefresh
This function enables you to refresh specific rows or columns of one or more reports, based on a specified range of data drivers whose values you can modify.
Additionally, you can specify to refresh a whole report that is outside of the specified range of data drivers.
This function can be used for example for what-if analysis.
| Parameter | Description |
|---|---|
| range | Range containing the data drivers. |
| InRangeReportID | ID of one or more reports in the range, to be refreshed. Optional. |
| OutOfRangeReportID | ID of a report outside of the range, to be refreshed. Optional. |
| ApplyToRow | Specify a report outside of the range, to be refreshed. |
- Report1 contains column B.
Data drivers are listed in column B.
When adding an EPMDriverBasedRefresh function:
- In the range parameter, you specify column B because this column contains the data drivers.
- In the ApplyToRow parameter, enter TRUE. When changing the data in B3 (cell belonging to the current report), all the data in row 3 are refreshed.
- Report2 is placed below
Report1.
When modifying the EPMDriverBasedRefresh function, you can specify the InRangeReportID parameter as follows:
- You do not specify a report (and "" is displayed in the parameter area, meaning that all reports are taken into account): if you modify data in any cell of the column B, the corresponding row will be refreshed, regardless of the report you are in.
- You specify the ID of Report1: if you modify the data in cell B3, row 3 will be refreshed because B3 belongs to Report1.
- However, if you modify the data in cell B11, row 11 will not be refreshed because B11 does not belong to Report1.
- Report3 is placed to the
right of Report1 and has no row or column in common with Report1 and Report2.
Report3 is linked to Report1 via an EPMDimensionOverride function.
You also want that Report3 be refreshed when there is a change in Report1 data drivers.
When modifying the EPMDriverBasedRefresh function, you can specify the ID of Report3. Report3 will be completely refreshed (members and data).Note the report specified must be in the same worksheet as the report in which data drivers are modified.