MicroStrategy ONE
Layout Properties dialog box: Advanced
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 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, Interactive Mode, or View 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.
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.
Once you select the Enable Incremental Fetch check box, the following properties become available:
-
Fetch Level: the object to be counted for the incremental fetch.
If the document or layout is grouped, the groups are displayed in the drop-down list. 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: the number of objects (of the Fetch Level) 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.
To enable incremental fetch for a different layout, select that layout before opening the Layout Properties dialog box. To select a layout, click its tab at the top of the Layout area.