Template Processing Specifications
This manual is in pilot operation.
|
This section describes the processing behavior when Data Retrieval, Data Retrieval and Reflection or Data Reflection is executed for template processing targets.
When multiple linked regions are defined on a single sheet, unless otherwise noted below, the processing order in each step follows the order of linked region definitions (the order shown in the list on the linked region definition screen).
Data Retrieval
1. Data Retrieval for Linked Regions Outside the Template Range
For linked regions outside the template range, data is retrieved in the same manner as for a normal sheet (that is, regions not subject to template processing).
2. Clearing the Template Range
Before data retrieval, target cells for data retrieval within the template range are cleared.
3. Determining Iteration Keys to Retrieve
Based on the specification of the repetition condition item “Display all combinations of members in the Member List” and the linked region definitions related to the Control Region, the iteration keys to be retrieved are determined. An iteration row key is a set of Dimension Member labels assigned to the iteration key columns (the term “set” is used because multiple iteration key columns may be specified).
4. Data Retrieval for Each Linked Region in the Template Range
Using the iteration keys obtained in the previous step, data is retrieved for the template range. This process is repeated until the retrieved data becomes stable or until the number of iterations exceeds 10.
⚠ Retrieved data changes only when a Calculated Key Column exists. Because the key values held by each cell in a Calculated Key Column may change depending on data retrieved into other cells, subsequent data retrieval may change the values of cells included in linked regions that use the Calculated Key Column as a key column.
⚠ If the retrieved data does not stabilize after more than 10 iterations, an error message is displayed.
5. Writing Processing Results to the Result Display Area
(This process is executed only when a Result Display Area is specified.)
Based on the final stabilized retrieved data, the values of each cell in the template range calculated for each processing unit (iteration key) are copied sequentially from top to bottom into the Result Display Area.
Depending on the settings, formulas, formats and input rules in the Result Display Area are also copied.
Data Retrieval and Reflection
To ensure that Ledger data reflected from linked regions outside the template range is carried over into template processing and that data reflected by template processing becomes available in linked regions outside the template range, the following iterative processing is performed.
1. Executing Data Retrieval Processing
The Data Retrieval processing described above is executed, except for writing processing results to the Result Display Area.
2. Executing Data Reflection Processing
A) Data Reflection for Linked Regions Outside the Template Range
For linked regions outside the template range, data is reflected in the same manner as for a normal sheet (that is, regions not subject to template processing).
3. Executing Data Retrieval Processing
The Data Retrieval processing described above is executed, except for writing processing results to the Result Display Area.
4. Repeating Reflection and Retrieval
If Maximum Iterations for Reflection is specified, steps 2 and 3 above are repeated until the number of iterations exceeds the maximum or until no change occurs in the retrieved data after reflection processing.
5. Writing Processing Results to the Result Display Area
(This process is executed only when a Result Display Area is specified.)
Based on the final stabilized retrieved data, the values of each cell in the template range calculated for each processing unit (iteration key) are copied sequentially from top to bottom into the Result Display Area. Depending on the settings, formulas, formats and input rules in the Result Display Area are also copied.
Data Reflection
1. Executing Data Reflection Processing
First, Data Reflection processing is executed as follows:
-
For linked regions inside the template range
Reflection processing is performed not on the target range of the linked region itself but on the corresponding cell range within the Result Display Area. The settings of linked regions inside the template range are applied by replacing the first and last rows of the target range with the first and last rows of the Result Display Area (the last row that contains data). -
For linked regions outside the template range
Processing is performed in the same manner as for a normal sheet.
The order of reflection processing follows the order of linked region definitions (the order shown in the list on the linked region definition screen), regardless of whether the regions are inside or outside the template range.
