ValQ - Plan
FormulaProductChangelogStart Trial
  • Introduction to ValQ
    • Get ValQ
    • The ValQ Workflow
  • Model
    • Get Data
    • Create Model
      • Dynamic Model
      • Custom Model
      • Import a Model
    • Model Editor
      • Node Operations
      • Editor Features
    • Node Settings
    • Templates
      • Apply Template
      • Manage Template Nodes
      • Import Template
      • Export Template
    • Formula Functions
      • Logical Functions
        • IF
        • SWITCH
        • AND
        • OR
        • NOT
        • XOR
        • IFNAN
      • Math Functions
        • SUM
        • SUBTRACT
        • PRODUCT
        • DIVISION
        • AVERAGE
        • AVERAGEEXZERO
        • AVERAGEEXNEG
        • AVERAGEEXZERONEG
        • COUNT
        • ABS
        • MIN
        • MAX
        • POWER
        • SQRT
        • EXP
        • LOG
        • ROUND
        • FLOOR
        • CEILING
      • Finance Functions
        • IRR
        • NPV
        • PMT
        • IPMT
        • FV
        • PV
        • CUMIPMT
        • CUMPRINC
        • RATE
      • Range Functions
        • RANGE
        • LastNPeriods
        • Get
        • ForEach
        • findByTitle
        • GETCURRENTRANGE
        • GETROWVALUE
        • THIS_SOURCE_KEY
        • PERIOD_LOOKUP
        • PRIOR_SERIES_PERIOD_LOOKUP
      • Static Identifiers
        • THIS/ME
        • CURRENT_SERIES*
        • CURRENT_SERIES_ID*
        • CURRENT_PERIOD_INDEX
        • CURRENT_NODE_VALUES
        • DS.SERIES
      • Node Properties
        • Node Properties Explanation
    • Global Settings
  • Plan
    • Create New Plan
    • Time Series Forecasting
    • Allocation Features
      • Goal Seek
      • Distribute
      • Copy to Periods
    • Driver Based Planning
      • Enabling Driver Based Plan
      • Configuring Driver Inputs
      • Bulk Configuration of Drivers
    • Plan Interface
  • Simulate
    • Create a Scenario
    • Perform Simulations
    • Manage Scenarios
    • Simulation Interface
    • Add Notes
    • Compare Scenarios
    • Scenario Analysis by Node
    • Create Initiatives in a Scenario
      • Steps to create initiatives
    • Create your Presentation
    • Understanding the Node Components
  • Report
    • Variance Analysis Report
  • ValQ Premium FAQs
  • Glossary
  • Resources
  • Release Notes
Powered by GitBook
On this page
  • Add/Edit/Delete Template Rules
  • Remove Template from the model
  • Copy Template Rules to Dynamic Children
  1. Model
  2. Templates

Manage Template Nodes

PreviousApply TemplateNextImport Template

Last updated 1 year ago

After applying the template, the template nodes can be edited, copied, or deleted by clicking on the Manage Template Nodes icon as shown below.

The 'Manage Template Nodes' pop-up shows all the templated nodes used in the model, including their name, whether they have replaced the nodes or were added as new nodes, and a list of actions to select from.

The number on the icon indicates the total number of templates applied in the model. In the example below, there are two templates applied to the model - one to replace the nodes and one to add new nodes.

Note:

Another way to open the datasource node editor and edit the templates is to use the shortcut icon near the node name.

The following actions are possible through the DataSource Node Editor window.

Add/Edit/Delete Template Rules

  1. Add a new template to the model by clicking Add Rule to configure that template into the model.

  1. Edit the applied templates.

  • You can change the template using the 'Select Template' dropdown.

  • To edit the level at which the template is applied, click on the 'Select Level' dropdown.

  • Templates can be applied to all the nodes or specific nodes using the filter.

  1. Re-apply to different nodes using filter conditions.

  • Edit the Category and Member fields to change the filter conditions.

  • Add more than one filter condition and combine them using AND/OR operators.

  1. You can delete a specific template by clicking on Delete beside that template rule.

In case of multiple template rules applied to the model, if they overlap, the latest added rule overrides the previous rules.

Remove Template from the model

To remove the template completely and revert the model to its initial state, click on the bin icon that appears next to the applied template.

This option removes only the template references from the model and does not delete the actual template that had been created.

The template would still be available in the Templates window.

Copy Template Rules to Dynamic Children

Click on the Copy rule icon beside the template that you want to copy.

In the pop-up that opens, choose the dynamic nodes to which the existing template rules are to be applied. Click Apply.

This applies the templates to the newly added dynamic child nodes.

You can also click on the 'data source node editor' icon beside the node to configure a template for it manually.

Alternatively, to delete the actual template, it is mandatory to remove its references from the model first, by using .

In case of being added to the model (adding new nodes from data), you can apply the existing template rules to them.

this option
dynamic children
Click 'Manage Templates' icon
Manage Template Nodes
Click To Open the DataSource Node Editor
Add a new template rule
Edit the applied template
Changing filter conditions
Add more than one condition
Delete rule
Remove Template
Copy Rule
Copy Template Rules
Configuring a template