MicroStrategy ONE

Improving document performance in MicroStrategy Web: 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.

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

The blocks of data are defined by the number of objects (the block size) to return at a certain level. If the document or layout is grouped, you can select any group as the level. If it is not, then the block size is applied to the Detail section.

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

If the same document is grouped by Call Center, incremental fetch can be applied at the level of Call Center, with a block size of five. In MicroStrategy Web, data for five Call Centers is displayed on a single page.

For more detailed examples, see the Document Creation Help.

Groups that are displayed as only a single element cannot be used as the level, 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.

You can also apply incremental fetch to a specific Grid/Graph. For more information, see Improving document performance in MicroStrategy Web: Incremental fetch on Grid/Graphs.

To apply incremental fetch to a document

  1. Open a document in the Document Editor. How?

  2. If the document contains multiple layouts, select the layout to apply incremental fetch to.

  3. From the Format menu, choose Document Properties. The Document Properties dialog box opens.

  4. Under Layout Properties on the left, select Advanced.

  5. Select the Enable Incremental Fetch check box.

  6. From the Fetch Level drop-down list, select the object to be counted for the incremental fetch level.

    • If the document or layout is grouped, the groups are displayed in the drop-down list. Groups that are displayed as a single element only are not shown on this list.

    • 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.

  7. Enter the Block Size, which is the number of objects (of the Fetch Level) that are returned in each block.

  8. Click OK to return to the document.

To see the results of the incremental fetch, run the document in MicroStrategy Web in Editable Mode, Interactive Mode, or Express Mode.

Related Topics