5.9.1 Creating a Materialized View
To create a materialized view for a Viewsheet, you must first log into Enterprise Manager on the Data Server machine. You cannot create a materialized view by using Enterprise Manager on the Report Server machine, unless this machine also hosts the Data Server.
For example, if Machine1 contains the Report Server, Machine2 contains the Data Server, and Machines3-MachineN contain the Data Nodes, you must log into Enterprise Manager on Machine2 to create materialized views, e.g.,
http://Machine2:8080/sree/EnterpriseManager
See Distributing Materialized Views (Data Grid) for more information about the available server architectures.
You can also set materialized views to generate automatically on-demand. See Performance Options and Safeguards.
To create the materialized view, follow the steps below:
1. Log into Enterprise Manager on the Data Server machine.
2. Expand the 'Repository' node under the Report tab.
3. (Optional) To list only Viewsheets in the Repository tree, deselect the other options from the bottom panel.

4. Select an existing Viewsheet from the Repository tree.
5. Select the Materialized View tab. This displays the 'Materialized View' page.
6. Select the 'Materialized View' option. This displays the 'Materialized Views' table for the Viewsheet.

7. (Optional) Select 'Apply VPM' if you wish to apply existing VPMs when creating the materialized view. If your VPM filters data based on particular users, enable 'Create Materialized View for all users in group'. This allows a custom materialized view to be generated for each user, if needed. (See Data Security with Materialized Views below for more details.) To keep the materialized view free from the effects of any existing VPMs, select 'Bypass VPM'.
8. (Optional) Select 'Full Data' to materialize the entire Worksheet Data Block associated with a materializable Viewsheet component. Select 'Minimum Data' to materialize only those columns of the Data Block that are directly supplying data to the Viewsheet component.
The 'Minimum Data' option conserves disk space, and is recommended when you do not expect the Viewsheet to undergo further editing after deployment. In cases when the Viewsheet will undergo further development (for example, end-user chart binding modifications), use the 'Full Data' option to ensure that all data is available for immediate use.
Only Viewsheets containing aggregated data can be considered candidates for materialized views.
9. Press the 'Analyze' button to have Enterprise Manager determine which assemblies in the selected Viewsheet are candidates for a materialized views.
When the analysis is complete, the 'Optimize Plan' dialog box displays information about the extent of possible materializations. See Transformations and Faults for more information about the materialization process.
10. Click 'OK' to dismiss the dialog box.
The table now shows the assemblies and their candidacy for materialized view generation. If the 'Status' column indicates 'Recommended' for a given assembly, then that assembly is likely to benefit from materialized view generation. If a materialized view has already been created for an assembly, the 'Status' column will report 'Existing.'
11. Press the 'Select All' button if you wish to generate all the listed materialized views. Otherwise select the subset of assemblies for which you want a materialized view to be generated.
Note: To schedule a materialized view, you must first set the mv.repository.servlet property in sree.properties to the complete URL of the Data Server. This allows the Scheduler to communicate the request to the web application.
12. In the 'Cycle' column of the table, select the cycle on which the materialized view should be generated. (See the Scheduler Cycle section for more information about defining cycles.)
13. Press the 'Create' button. This opens the 'Create Materialized Views' dialog box.

14. In the dialog box, choose one of the following options for initial materialized view configuration:
The actual materialization will take place on whatever cycle has been specified.
a. 'Immediately Without Data', to configure the materialized view, but skip the initial materialization process.
b. 'Immediately With Data', to configure the materialized view, and perform the full materialization process. (This may take a significant amount of time, during which the materialized view is constructed, and data files are saved into the WEB-INF/classes/bs directory.)
c. 'Scheduled', to specify a particular time at which the initial materialization should take place. Enter a 'Notification Email' to issue an alert on the status of the materialization.
15. Click 'Create' to perform the selected operation and close the dialog box.
The 'Status' column in the table on the 'Materialized View' page will now update to display the materialized views that are currently in existence.
Note: You must 'Create' the view before you 'Apply' the cycle.
16. Press the 'Apply' button at the top of the page. This saves the specified materialized views and their scheduled cycles.
See Also
Distributing Materialized Views (Data Grid), to improve materialization performance.
Managing Materialized Views, to manage existing materialized views. see the
Dashboard Design, for information about creating Viewsheets.
| << 5.9 Materialized Views | © 1996-2013 InetSoft Technology Corporation (v11.5) | 5.9.2 Incrementally Updating a Materialized View >> |