Siebel Analytics Server Administration Guide > Using Variables in a Repository >

About Initialization Blocks

Initialization blocks are used to initialize dynamic repository variables, system session variables, and nonsystem session variables. (The NQ_SYSTEM initialization block is used to refresh system session variables.)

An initialization block contains the SQL that will be executed to initialize or refresh the variables associated with that block. The SQL must reference physical tables that can be accessed using the connection pool specified in the Connection Pool field in the Initialization Block dialog box.

If you want the query for an initialization block to have database-specific SQL, you can select a database type for that query. If a SQL initialization string for that database type has been defined when the initialization block is instantiated, this string will be used. Otherwise, a default initialization SQL string will be used.

CAUTION:  When you open the Initialization Block dialog box for editing in online mode, you will check out the initialization block object. While the initialization block is checked out, the Siebel Analytics Server may continue to refresh the value of dynamic variables refreshed by this initialization block, depending on the refresh intervals that are set. If you later check the initialization block back in, you will reset the value of the dynamic variables to the values shown in the Default initializer. If you do not want this to occur, use the Undo Check Out option.


 Siebel Analytics Server Administration Guide 
 Published: 23 June 2003