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

Uploading Data

We will load the Actuals for Financial Year 2017 from the Sample Data file that you may have downloaded earlier.

From our Model page, we will click on File Manager.

Manage Data

Click on Upload File and click Choose File and select the Sample Data csv file and hit Upload.

Uploading data

Last updated:

Pager

Previous pageDuplicating Workviews

Next pageData Process

Uploading Data ​

Uploading Data