Defer Session Variable Processing

To decrease logon time and save system resources, you can defer the processing of an initialization block containing many session variables.

Any new initialization blocks that you create are set to deferred execution by default. When you import a model created in Model Administration Tool, the deferred execution property set in its variables is imported into Semantic Modeler.

If you defer the processing of a session variable initialization block, then any variable included in the initialization block is processed when it's accessed for the first time during the session rather than at logon time. And Oracle Analytics doesn't run initialization blocks that contain session variables that aren't used during the session.

The deferred run of an initialization block also triggers the processing of all unprocessed predecessor initialization blocks. All associated variables of the initialization block and its unprocessed predecessors are updated with the values returned from the deferred processing.

A message is displayed when you can't defer the processing of a session variable initialization block. See When You Can't Defer Session Variable Processing.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Variables .
4. In the Variables pane, browse or search for the initialization block that you want to defer execution for and double-click it.
5. In the Initialization Block, click the General tab and then click Allow deferred execution.
6. Click Save.