Automatically Recompiling Dynamic Resources in Reports
This topic describes how you can recompile dynamic formulas and aggregations in reports upon changes of business views, on Report Server as an administrator.
When you made changes to business views, such as modifying mapping names of data columns, and changing a referenced field, you need to recompile dynamic formulas and aggregations in reports that you created based on those business views, to work with the reports normally. You can achieve this directly on Server if you are an administrator. There is no longer the need to download reports into Report Designer, re-save the dynamic resources there, and then republish the reports back to Server. This is convenient and time-saving when there are many reports involved, especially when you do not have a Designer at hand.
To recompile dynamic resources in reports upon changes in business views, take the following steps:
- On the system toolbar of the Server Console, select Administration > Other > Batch Refresh Dynamic Resources from the drop-down menu. Server displays the following page.
- Select Browse to choose the catalog where the changed business views reside, from the server resource tree.
- Select the ellipsis button to choose a folder in which there are reports that run with the preceding catalog, from the server resource tree. Each time you can recompile based on one catalog and one folder. If your server's workload and performance enables and you have enough time, you can choose a parent folder that contains all such folders, or simply choose the root directory of the server resource tree if you are not quite clear about where the reports are. Otherwise, start from a folder without a subfolder in it and do the work multiple times.
- Select OK to start recompiling the dynamic resources in the reports that run with the specified catalog, in the specified folder (including its sub folders). The process might take a long while depending on the quantity of the dynamic resources to recompile and the reports to refresh.