Add Dependencies to an Initialization Block

When a semantic model has multiple initialization blocks, you can set the order that the blocks are initialized in.

If you don't set dependencies, then Oracle Analytics runs all initialization blocks at the same time. This results in null values because the variable values aren't returned in the necessary order.

To add dependencies, you first open the initialization block that you want to be run last and then add the initialization blocks that you want to be run before the block you've opened. For example, suppose a semantic model has two initialization blocks, A and B. You open initialization Block B, and then specify that Block A runs before Block B. If you're setting dependencies for session initialization blocks that include schedules, then Block A runs according to Block B's schedule in addition to its own schedule.

  1. On your home page, click Navigator Navigator icon and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Variables Variables icon.
  4. In the Variables pane, browse or search for the initialization block that you want to add a dependency to.
  5. In the Initialization Block, click the Dependencies tab.
  6. Click Add Initialization Block and browse for and select an initialization block to add it to the Dependencies list.
  7. Click Save.