To navigate

To select

esc To close

Skip to content

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

Build a Departmental Workview

Create a new Workview to report on the Travel Expenditure per Department by Month.

Departmental View Creation

Pivot the Workview to display Department under On Rows and Month under On Columns. It is easy to create a quick and simple Departmental Report.

Departmental Workview

Last updated:

Previous pageReview the Model

Build a Departmental Workview ​

Build a Departmental Workview