Siebel Analytics Server Administration Guide > Using Variables in a Repository > About Initialization Blocks >

Initializing Dynamic Repository Variables

The values of dynamic repository variables are set by queries defined in the Initialization string field of the Initialization Block dialog box. You also set up a schedule that the Siebel Analytics Server will follow to execute the query and periodically refresh the value of the variable. If you stop and restart the Siebel Analytics Server, the server will automatically execute the SQL in repository variable initialization blocks, reinitializing the repository variables.

The Siebel Analytics Server logs all SQL queries issued to retrieve repository variable information in the NQQuery.log file when the Administrator logging level is set to 2 or higher. You should set the logging level to 2 for the Siebel Analytics Server Administrator user ID to provide the most useful level of information. The default location for the NQQuery.log file is the Log folder in the Siebel Analytics Server software installation folder. For more information about user-level logging, see Administering the Query Log.


 Siebel Analytics Server Administration Guide 
 Published: 23 June 2003