To navigate

To select

esc To close

MODLR

Main NavigationTechnical Guides

Sidebar Navigation

Getting Started

Operational Expenditure Model

Introduction

Creating Model

Creating a Dimension

Creating the Year Dimension

Creating the Department Dimension

Creating the Account Dimension

Creating the Scenario Dimension

Creating a Cube

Using Instructions

Adding Data to the Report

Duplicating Workviews

Uploading data

Data Process

Adding Formula

Template for Operating Expenditure

Sets

Comparing Data Against Actuals for 2017

Phasing Method

Creating Phasing Dimension

Phasing Rule

Data Validation

Explain Value

Prior Year Trend formula

Custom Header

Hiding Dimension Headers

Disable Set Instruction

Revenue Model

Introduction

Creating Product Dimension

Creating Pricing Cube

Creating Month List

Creating Pricing Cube Workviews

Adding Styles

Creating Sales Cube

Creating Sales Cube Workviews

Linking Cubes

Number Formatting

Travel Planning Model

Introduction

Creating Year Dimension

Creating Month Dimension

Creating Trip Dimension

Creating Scenario Dimension

Adding a Department/Cost Centre Dimension

Destination Dimension

Creating the Travel Cube

Creating the Travel Planning Workview

Updating the Measures Dimension with Travel Measures

Configuring the Measures

Basic Formatting

Adding Data Validation

Creating Another Cube and Workview for Travel Rates

Modifying Travel Rates Measure

Adding Formula to a Cube (Business Logic)

Making the Report look nicer

Review the Model

Build a Departmental Workview

On this page

Table of Contents for current page

Review the Model

Close the current workview as it is ready for collaborators to plan with.

Note: The Model Overview now displays the link between the Travel and the Travel Rates cubes. This is because the formulas we added push data from the Travel Rates cube into the Travel cube in real time.

Updated Workview

Last updated:

Previous pageMaking the Report look nicer

Next pageBuild a Departmental Workview

Review the Model ​

Review the Model