Defining a Refresh Materialized View: This screen capture of the Materialized View tab of the Cubes property sheet shows the following settings: Enable Materialized View Refresh is selected, Refresh Method is Force, Refresh Mode is On Demand. Constraints are Trusted. Enable Query Rewrite is not selected. All compatibility checks on the cube and its dimensions passed successfully. The Relational Schema Advisor button is available because the materialized view has already been created.