The Refresh Metadata function is used to refresh the metadata in the trees, including existing business logic, and clear the metadata cache for the Pyramid server. This is important in ensuring that changes that have been made to the data model are reflected in the trees.
In these scenarios, the user simply clicks the Refresh Metadata button to ensure any changes in the underlying model are reflected in Pyramid.
Access Refresh Metadata
Report and Query Ribbons
The Refresh Metadata button can be accessed from both the Report and Query ribbons.
Clicking this button will refresh metadata in the Dimensions, Measures, and Elements trees, including business logic.
The Refresh Metadata function also clears the metadata cache on the Pyramid server, ensuring that cached results are not returned. If refreshing the model metadata results in changes in the metadata impacting on the existing query or slicer(s), the query and/ or affected slicer(s) will be rerun automatically.
Both the Measures and Elements trees feature a Refresh icon; clicking this icon refreshes the metadata for custom measures or custom lists respectively, without clearing the cache for the Pyramid server. Use of this icon does not refresh the model metadata, does not clear the metadata cache on the Pyramid server, and does not rerun the query or slicers. It is used to refresh custom business logic lists.