Skip to content

MODLR

Main Navigation Technical Guides

Cube Functions

Process Functions

Set Instructions

Excel Addin

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

Phasing Rule

We will store the phasing method and amount in the middle columns set.

Open FY18 Opex Budgeting workview from our Model page.

Double click on the highlighted cell and choose Phasing under Default and click Add to Selection Instruction and hit Save

Add Phasing to Instruction Editor

Last updated:

Pager

Previous pageCreating Phasing Dimension

Next pageData Validation

Phasing Rule ​

Phasing Rule