12.3.2 Templates as a Base for Sandbox Table Creation

Templates can be physicalized into sandbox tables to enable scenario-based and time-based execution.

When a template is saved, users are prompted to confirm whether the template should be physicalized. If confirmed, the system performs the following actions:

• Creates the required sandbox tables
• Registers the tables in the Data Catalog with a Template tag
• Applies glossary mappings

Note:

• The Micro or Macro variables must be created on the physicalized table and associated with the scenario.
• You can physicalize the tables with custom column.

Each Cartesian table defined in the template generates a corresponding sandbox table.

An additional fic_mis_date column is automatically added to support time-based execution.

Note:

Base reference data is stored using fic_mis_date = 01/01/1990.

During execution, scenario-specific data is written to the sandbox table for each applicable fic_mis_date, enabling structured scenario and temporal analysis.