2.2 Creating a Materialized View
A materialized view is a method of storing data that permits a dashboard to retrieve data more quickly and improves dashboard responsiveness. (See Materialized Views in Administration Reference for more details.) Most dashboards will benefit from a substantial performance improvement when a materialized view is utilized.
This section illustrates how an administrator can create a materialized view for the dashboard you created in the previous section, Creating a Dashboard. Follow the steps below:
If the server is already running, just point a browser window to http://localhost:8080/sree/EnterpriseManager.
1. On Windows, launch the User Portal from the Windows 'Start' menu: Start > All Programs > Style Intelligence > Style Intelligence Server. This opens the browser to the server home page.
2. On Linux, run the InetsoftServer.sh file in the bin folder of the installation directory to start the server. In your browser, enter the URL http://localhost:8080/sree/ to access the server home page.
3. Select the 'Enterprise Manager' link to open Enterprise Manager.
4. Select the Report tab, expand the 'Repository' tree node, and select the 'Sample Viewsheet' dashboard in the tree.

5. Select the Materialized View tab.
6. Press the 'Analyze' button below the 'Materialized Views' table.

This opens the 'Optimize Plan' dialog box.
7. Press 'OK' to dismiss the 'Optimize Plan' dialog box. The 'Materialized Views' table now lists a materialized view with status 'Recommended'.

The cycle determines how often the materialized view is refreshed with data from the database.
8. To assign a cycle to the materialized view, choose the desired cycle from the 'Select Cycle' menu, and press 'Apply Cycle'. (See Scheduler Cycle in Administration Reference for more details about cycles.) The materialized view is now configured to be generated on the specified cycle.
9. To create the initial materialized view, press the 'Create' button below the 'Materialized Views' table.

This opens the 'Create Materialized Views' dialog box.
10. Choose the method for creating the materialized view, and press 'Create'.

Select 'Immediately With Data' to create the full materialized view. Select 'Immediately Without Data' to create just the materialized view framework. (In this case, the materialized view will be populated with data the next time the cycle runs.) Select 'Scheduled' to schedule the initial materialized view creation for a future time.
The 'Status' column of the 'Materialized Views' table now indicates that a materialized view exists for the dashboard, and this materialized view (rather than the database) will supply data to the dashboard in the future.

| << 2.1 Creating a Dashboard | © 1996-2013 InetSoft Technology Corporation (v11.5) | 2.3 Using a Dashboard >> |