Bookshelf Home | Contents | Index | PDF |
Siebel Analytics Server Administration Guide > Using Variables in the Analytics Server Repository > About Initialization Blocks > Tasks Using the Initialization Block Dialog Box—Variable TabThe Variables tab can list several variables in the Variables column, and the initialization block SQL in the Default initializer list can list multiple columns in the SELECT statement. The variables will be initialized in the same order that the columns are listed in the SQL statement; for example, the value returned in the nth column will be assigned to the nth variable in the list. For repository variables, when you open a repository in online mode, the value shown in the Default initializer column in the Variable tab of the Initialization Block dialog box is the current value of that variable as known to the Siebel Analytics Server. NOTE: The number of associated variables can be different from the number of columns being retrieved. If there are fewer variables than columns, extra column values are ignored. If there are more variables than columns, the additional variables are not refreshed (they retain their original values, whatever they may be). Any legal SQL can be executed using an initialization block, including SQL that writes to the database or alters database structures, assuming the database permits the user ID associated with the connection pool to perform these actions. To access the Initialization Block dialog box
To add a new variable to refresh with this block
To edit a variable refreshed by this block
To link a block with a variable not already refreshed by an initialization block
To remove a variable's association with this block Default InitializerFor repository variables, when you open a repository in online mode, the value shown in the Default initializer column of the Initialization Block—Variables tab is the current value of that variable as known to the Siebel Analytics Server. Initialization When the Siebel Analytics Server StartsIf you stop and restart the Siebel Analytics Server, the server will automatically execute the SQL in repository variable initialization blocks, reinitializing the repository variables. |
Siebel Analytics Server Administration Guide |