Properties Dialog Box, Layout Properties, Advanced

The Advanced options in the Layout Properties section of the Properties dialog box include options for enabling incremental fetch.

Incremental fetch divides large documents or layouts into pages, thereby loading the data in batches (or blocks) rather than all at the same time. This improves the usability and performance of a large document or layout, by reducing the load and overall memory usage on the web server.

For example, each row in the Details section of a document contains the Item attribute and several metrics. Incremental fetch is applied, with a block size of ten. In Editable Mode or Presentation Mode in MicroStrategy Web, only ten rows of items are displayed on a single page. You can navigate to another page to display more information.

To enable incremental fetch for a different layout, select that layout by clicking its tab at the top of the Layout area, then opening the Layout Properties dialog box.

You can define the incremental fetch options in both MicroStrategy Web and in MicroStrategy Developer, but incremental fetch is applied when the document is executed in MicroStrategy Web. MicroStrategy Developer does not apply incremental fetch to documents.

Incremental Fetch:

Enable incremental fetch: Determine whether to enable incremental fetch, and the choose from the following properties:

• Fetch Level: Determine the level at which to apply incremental fetch. If the document or layout is grouped, you can select any group from the drop-down list. For example, a document is grouped by Call Center. You can select Call Center from the Fetch Level drop-down list and define the Block Size as five to display data for five Call Centers on a single page. Groups that are displayed as single element only are not shown on this list, since "All" needs to be the selected grouping option.

  If the document or layout is not grouped or all the groups are displayed as single elements only, the only option is the Detail section.

• Block Size: Determine the number of objects, specified in the Fetch Level option above, that are returned in each block. The incremental fetch properties are applied to the selected layout of a multiple layout document or for the document as a whole, if it does not contain multiple layouts.

Related Topics

About the Properties Dialog Box

Document Creation Help for background information on incremental fetch, including examples