Home > Working with Planning Projects > Building an Application > Building Application Models > Building A Cube Model > Measure Settings > Defining the Measures List
Defining the Measures List
Last Updated 5/28/2012 4:13 PM
Measures must be specified for any cube model. In a spreadsheet environment, we would need to specify the calculations in each cell of the spreadsheet. This approach provides a lot of flexibility, but is sometimes tedious and can be error prone. Within MaxiPlan, we define calculations based on the rows in our model. Whilst we can directly reference a specific column, this approach provides a much more flexible and easily mainatained environment, regardless of any changes made to other dimensions (such as periods).
Let us assume we wish to define the following measures and associated calculations
SALARY AND BENEFITS
TRAVEL COSTS
MARKETING
TRAINING
OFFICE COSTS = ADMINISTRATIVE + OFFICE LEASE + UTILITIES + OTHER OFFICE EXPENSES
ADMINISTRATIVE
OFFICE LEASE
UTILITIES
OTHER OFFICE EXPENSES
OTHER EXPENSES
TOTAL EXPENSES = SALARY AND BENEFITS + TRAVEL COSTS + MARKETING + TRAINING + OFFICE COSTS + OTHER EXPENSES
To set these measures up in model builder, we first select the Measures tab. This will display the Measures editing screen.
To enter new measures, right click on the empty list of measures to the left of the frame, and a popup will appear in the list window providing a menu list of options.
We will select the option to Add Multiple Items.
A popup window will appear, and we can simply type in the list of measures we wish to have in our model.
When we have finished, we can simply select  to save the measures in our list.
TIP: You can 'cut and paste' the list of variables from another application such as a spreadsheet or word processing document if you wish.
See also
Setting Measure Attributes
Measure Formatting
Defining Calculations for Measures
Other Functions for Measures Editor
Cross Referencing Measures
Measure Logic Functions
Building a Cube Model
| 
Page URL: