Calculated Measure in Pentaho User Interface

Posted on by By Mounika, in Pentaho | 0

My previous blog explained creating calculated measure using Schema Workbench. This blog will let you know how to add a calculated measure that fetches % of measure relative to a particular dimension in Pentaho User Interface.

Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

Grab The 30 Days Free Trail

Pentaho BI Platform.

Consider the below cube which is already published in Pentaho BI Server. One of the working scenarios of the cube is used for demonstration i.e. amount which is spent relative to time and store country.

store country

To create calculated measures which calculates relative percentage in a user interface, follow the below steps:

  1. Click on ‘Add’ button beside Measures.
  2. Add’ button

  3. Click on Predefined Calculations
  4. Predefined Calculations

  5. Enter the details according to the requirement as shown.
  6. Enter the details

    It gives the relative percentage change of amount according to Store Country.

  7. Click on OK, execute the cube and drag created calculated measure.
  8. execute the cube


Best Open Source Business Intelligence Software Helical Insight is Here


A Business Intelligence Framework

In case if you have any query please get us at

Thank you
BI Developer
Helical IT Solutions Pvt Ltd

0 0 votes
Article Rating
Notify of
Inline Feedbacks
View all comments