# Definition

Section captures the definition details of template. To define basic details of template, such as: name, type and model. The mandatory fields to be filled include:

1. **Table** to enter desired name for template. Note to have the report name be in English words.
2. **Type** select the type of template from available dropdown values that include Input, Report, System Reports and Table for different usages.
   * **Input** selected when user wants to create input schedule for data entry. The input data can be used for calculations or to capture additional information based on business requirements.
   * **Report** selected when user want to report/ show  data for reporting purposes (read-only). Data can be outcome of calculations, financials , actuals etc.
   * **Table**  all transaction data will be retrieved based on selection of dimension members in table format, this data can also be used for dynamic charts as well.
   * **System Reports** to select to retrieve any system related Information, in structure data format on the excel Interface for user’s reference and validation. Once selected, further dropdown is listed to select what type of data to drilldown to - 
   * **Drilldown To** 
     * Model Data retrieves all the transaction data from model to excel from model selected with field filtering options available below
     * Audit Data pulls out the complete audittrail system Information from model / fields selected to display who has changed, what has changed Including detailed timestamp
     * Journals extracts all the journals Information created for consolidation purposes 
     * Notes retrieves Commentaries Information maintained onto the excel template
3. **Model** dropdown list with available modules in workspace for user to select & report on. 

Note Model is key components while defining the template design, as this forms the basis for template definition. As each Virtual Model is a subset of data combinations from Standard Model, this becomes the base or layout creation. When a Virtual Model is selected, all the dimensions predefined for it will be shown automatically in Row, Column and Filter axis in layout section. However, these filters act as the starting point & can be modified by users for layout & member selections filtered from virtual model.

Some References following are some comparison among different types of templates:

* Input is used for templates to enter data for combination of field members. There are some scenarios when input form is required:

  \- To provide data for key drivers marked as Input in Value driver tree

  \- To provide data for items unavailable in data source/ system

  \- Used by reviewers/approvers to adjust key index (if required)

  After entering value for required items, user has to save data for updating in system.

  When data is available for a specific field member, if modified or adjusted the new data will overwrite the existing.
* Report is for users to view the existing data and details of Key drivers after system calculation.

  User cannot enter any data in a report, even when data is entered in, it will not be saved.
* System Report is a kind of report created for user reference and validation. In this report, data available in backend/data source will be retrieved and shown in report according to user selection on level of details

Apart from above fields, there are few functions to help with definition of templates to support user

<img src="/files/esflfUvYkFrZsXuuRHUB" alt="" data-size="line"> **Insert** when a template is opened and user wants to create a new one, they can click on this button then a blank Design panel is displayed without any impact on existing template.

&#x20;<img src="/files/cL4VW0cuEOnMrqiUFAvn" alt="" data-size="line"> **Edit**  button can selected to modify or change the name of existing report or template.

<img src="/files/h2i3tXWcVvD60LaPntcR" alt="" data-size="line"> **Delete**  in a certain sheet, if any template is not used or required anymore, It can deleted  by clicking on this button. Note when a template is deleted from design pane, the excel template is not deleted automatically but the report definition is removed from the Tasks screen. User can also delete the template in the sheet by deleting relevant rows and columns (using normal delete function of Excel).

<img src="/files/MVLG4RWSlp5Q4a9a4eJc" alt="" data-size="line"> **Copy** used to create new template by copying an existing one. Once copied, can rename the new template and modify any required dimension selection.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.justperform.com/stories/excel-stories/stories-design-pane/definition.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.