🎓
Models University
  • Alpha Testing
    • 👋Welcome to Alpha
    • Installation and Setup
    • Support and Help
    • Terms and Licence
  • Start Here
    • What is Models?
    • Quick start
    • Tutorials
  • Using Taglo Software
    • The Taglo Interface
      • Navigating in Models
      • List Views
      • Adding Items
      • Deleting Items
      • Searching and Filtering
      • Previewing and Editing
      • Using Wizards
      • Save/Undo/Redo
      • Keyboard Shortcuts
    • Data Storage
    • Namespaces
    • Inbuilt data
  • Tags
    • Introduction to Tags
    • Tag Basics
    • Tags Applet
    • Advanced Tags
  • Models
    • Home Tab
      • Creating a Model
        • Timings
      • Version History
      • Application Settings
    • Model Editor
  • Variables
    • Variable Basics
      • Variable Setup
      • Unit and Calculations
    • Time Segments
      • Time Segment Setup
    • Summaries
    • Default Assumptions
  • Units
    • Introduction to Units
    • Key Unit Concepts
    • Advanced Units
    • Defining a Unit
    • Unit Factors
  • Dimensions
    • Introduction to Dimensions
    • Dimension Setup
    • Defining Unit Variance by Dimension
  • Data Types
    • Data Types
  • Assumptions
    • Introduction to Assumptions
    • Creating/Referencing Assumptions
    • Assumptions Wizard
      • Assumption Dates Step
      • Assumption Values Step
      • Linking to external Data
      • Linking to Excel Inserts
      • Sensitivity Values
  • Calculations
    • Introduction to Calculations
    • The Calculation Page
      • The Formula Entry Bar
      • Unit Analysis
    • Calculation Parts
      • Variable References
        • Referencing Time
        • Referencing Dimensions
        • Lookups
        • Summarising Variables
      • Period References
      • Functions
        • Advanced Functions
  • Aggregation
    • Introduction to Aggregation
    • Creating Aggregations
  • Rearranging
    • Introduction to Rearranging
    • Rearranging Example
    • Rearranging Tips
  • Cases
    • Introduction to Cases
    • Managing Scenarios
    • Managing Sensitivities
  • Layout
    • Generating Excel
    • Auto Layout
    • Sheets
      • Sheet Content
      • Adding and Editing Content
    • Excel Formatting
      • Excel Themes and Styles
      • Line Formatting
    • Data Tables
    • Excel Generation Troubleshooting
  • Excel Inserts and Outputs
    • Excel Inserts
    • Excel Outputs
  • Number Formats
    • Number Formats
  • Dashboards
    • Dashboards Basics
    • Dashboard Layout
    • Dashboard Items
    • Excel Dashboards
  • Metrics
    • Metrics
  • Charts
    • Introduction to Charts
    • Chart Customisation
  • Importing Models
    • Importing Models
  • Data
    • Introduction to Data
    • Creating Data
    • Data Sources
Powered by GitBook
On this page
  • Overview
  • Multiple Dimensions
  • Summarising Dimensions
  1. Dimensions

Introduction to Dimensions

How Dimensions allow us to build Models more efficiently

PreviousUnit FactorsNextDimension Setup

Last updated 11 months ago

Overview

Dimensions allow you to work with a collection of items without having to repeat calculations.

A Dimension might be:

  • Widget Model | Model A, Model B, and Model C

or

  • Sales Region | North, East, West, and South

Dimensions are extremely powerful, time-saving, and improve the quality of your Models.

In the example screenshot below, the Revenues by membership type Variable has the Membership Tier Dimension applied. The Membership Tier has 3 children: Basic, Premium, Platinum.

The Variable has a single formula, Gym members * Revenue per member. The [Auto] suffixes in the formula imply that the Calculation is able to automatically reference the appropriate line of the referenced Variables, which both also have the Membership Tier Dimension applied.

Using Dimensions, you can replace multiple sets of calculations with a single one, without worrying about copy/paste errors.

Multiple Dimensions

You can apply as many Dimensions as you like to a Variable.

In the example screenshot below, the Revenues by region and membership type Variable has two Dimensions applied: Membership Tier and Region. Models calculates a value for each combination of the children of the two Dimensions, in this case 6 lines in total.

Summarising Dimensions

Models can create summaries of Dimensions easily - you don't need to worry about referencing the correct lines in a Calculation.

To do this we simply create a new Variable with the Region Dimension applied, and reference the Revenues by region and membership type Variable. Models does the rest for us automatically.

In the example screenshot below, we want to show the total Revenues across the North and South regions from the Revenues by region and membership type Variable (see above example).

Multiple Dimensions
Variable with a Dimension applied
Variable with 2 Dimensions applied
Variable summarising a Dimension