Template tables can be driven from Excel ranges in the same way that other Anaplan XL report objects can be.
In this example, you want to change a Time butterfly report to be dynamic as a month's input changes. When the template columns are generated, the months selected each create a new column with a fixed month in it. Instead of having many columns to update, you want to have a small number of columns defined and then use the Excel range to create the month selection.
This will be done using MDXSet:. In this case, you have a simple switch-over cell, but you could create more complex logic, for example, using XL3MemberNavigate could be useful.
Initial table and columns:
Within the Design Table window, the initial column for January for the Value section indicates the data hierarchy the column belongs to, which is Date.Calendar in this case. The Selection shows the specific member selected within the hierarchy, currently January 2022.
You can keep the Hierarchy value to Date.Calendar within the Value section to specify the hierarchical structure of the value being displayed. Then, modify the Selection to point to the data source for the value, for example, referencing a cell in a spreadsheet: Sheet5'!$A$4.
MDXSet: definition cells, columns driven from a range, and result:
