Change the Order of Variables in an Initialization Block

If you test an initialization block's query and the variables are populated with the wrong values, then you might need to change the order of the variables.

The initialization query's column order and the variable order specified in the initialization block determines the column value assigned to each variable. When you associate variables with an initialization block, the first column specified in the query is assigned to the first variable in the list. If the initialization query's column order doesn't match the variables' order, then the variables are populated with the wrong values.

The number of associated variables could differ from the number of columns retrieved. If there are fewer variables than columns, extra column values are ignored. If there are more variables than columns, the additional variables aren't refreshed and the variables retain their original values.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Variables .
4. In the Variables pane, browse or search for the initialization block that you want to disable or enable and double-click it.
5. In the Initialization Block, click the Variables tab.
6. Go to the variables list and click to highlight the variable that you want to move. Click Move Up or Move Down.
7. Click Save.