You use this function to refresh your report data to get current data into your report from the database.
You refresh your report data when you change members using the current view, and when your report contains dynamic expansions. You set up automatic refresh settings in workbook options. See Workbook Options.
If the report contains EvSND functions, you are prompted to send updated data.
You can refresh data in the following ways:
Refresh Option |
Description |
---|---|
Retrieve active cell |
Refreshes data in the active cell. |
Retrieve active worksheet |
Refreshes data in the active worksheet. |
Retrieve active workbook |
Refreshes data in the active workbook. |
Retrieve supporting documents |
This option opens the Content Library, where you can retrieve a supporting document. See Content Library. |
Retrieve and refresh dimension members |
Fetches the latest dimension information from the database. |
Set automatic refresh |
This option automatically refreshes the report when you change the current view settings in the Workbook Options dialog box. See Workbook Options. |
To refresh data in a report, open the report for which you want to refresh data and choose Retrieve data from the action pane. Select one or more of the available options.