Initialization blocks (IB) : Refresh interval

Hi All,

The SQL query in the Initialization block gets fired based on the refresh interval set while defining the Initialization block. So if the refresh interval is set to 2 hours, the BI server will execute the query and refresh the variable after every 2 hours. The BI server will always follow the schedule. Whatever value is stored in the variable will be used by the BI server to replace any references to the variable.

The query is also fired every time the BI server is started. So essentially, the query is fired for the first time when the BI server is started. The BI server then refreshes the variable based on the refresh interval specified in the IB.

Thanks and Regards 
Rp - rakeshpatil002@gmail.com