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

Template for Operating Expenditure

Double click on 800 - Profit and add the instructions shown in the screenshot by using the dropdown present in the Instruction editor. Click Save.

Editing instructions for Account Dimension

Let's rearrange the dimensions to put Account on rows and everything else on columns.

Arranging the dimensions

Last updated:

Pager

Previous pageAdding Formula

Next pageSets

Template for Operating Expenditure ​

Template for Operating Expenditure