Template Processing Specifications
This manual is in pilot operation.
|
The following explains the processing content when data retrieval, data retrieval and reflection, or data reflection is executed for the template processing target.
In cases where multiple link regions are set on one sheet, unless otherwise noted below, the processing order in each of the following processing steps will follow the order of the link region definitions (the order in the list on the link region definition screen).
Data Retrieval
1. Data Retrieval from Link Regions Outside the Template Range
Data is retrieved from link regions outside the template range in the same manner as for a normal sheet (not a template processing target).
2. Clearing the Template Range
Prior to data retrieval, the cells within the template range targeted for data retrieval are cleared.
3. Determining the Repetition Keys for Retrieval
Based on the specification "Display all combinations of members in the member list" for the repetition condition and the link region definition related to the control region, the repetition keys for retrieval are determined. The repetition row keys are sets of dimension member labels assigned to the repetition key columns (the term "set" is used because there may be multiple repetition key columns).
4. Data Retrieval in Each Link Region within the Template Range
Using the repetition keys obtained in the previous step, data is retrieved within the template range. This process is repeated until there is no change in the retrieved data (or until the number of repetitions exceeds 10).
⚠ Data changes only if the calculated key column exists. The key values held by each cell in the calculated key column may change due to data retrieved in other cells, so the values in the cells included in the link region using the calculated key column as a key column may change upon subsequent data retrievals.
⚠ If the retrieved data does not stabilize even after 10 repetitions, an error message will be displayed.
5. Writing Processing Results to the Result Display Area
(This process is executed only if a result display area is specified.)
The values of each cell in the template range, calculated based on the finally stabilized retrieved data, are copied to the result display area sequentially from the top for each processing unit (repetition key).
As specified, formulas, formats, and input rules of the result display area are also copied.
Data Retrieval and Reflection
Data from the link regions outside the template range, reflected as ledger data, is carried over to the template processing, and data reflected in the template processing is made available in the link regions outside the template range through the following iterative process.
1. Execution of Data Retrieval Process
The aforementioned data retrieval process is executed, except for writing the processing results to the result display area.
2. Execution of Data Reflection Process
A) Data Reflection for Link Regions Outside the Template Range
Data is reflected for link regions outside the template range in the same manner as for a normal sheet (not a template processing target).
3. Execution of Data Retrieval Process
The aforementioned data retrieval process is executed, except for writing the processing results to the result display area.
4. Repetition of Reflection and Retrieval
If the maximum repetition reflection count is specified, the above processes 2 and 3 are repeated until the maximum repetition reflection count is exceeded or until there is no change in the retrieved data after the reflection process.
5. Writing Processing Results to the Result Display Area
(This process is executed only if a result display area is specified.)
The values of each cell in the template range, calculated based on the finally stabilized retrieved data, are copied to the result display area sequentially from the top for each processing unit (repetition key). As specified, formulas, formats, and input rules of the result display area are also copied.
Data Reflection
1. Execution of Data Reflection Process
First, the data reflection process is executed as follows:
-
For link regions within the template range: The reflection process is carried out for the cell range within the corresponding result display area, not for the target range of the link region. The settings of the link regions within the template range are applied by reading the first and last rows of the target range as the first and last rows (the last row with data) of the result display area.
-
For link regions outside the template range: The process is carried out in the same manner as for a normal sheet.
The order of reflection processing, whether within or outside the template range, follows the order of the link region definitions (the order in the list on the link region definition screen).