Pentaho

 View Only

 Schema Workbench - Calculated member

  • Pentaho
  • Pentaho
Veronika Florova's profile image
Veronika Florova posted 06-05-2018 13:11

     Hi, everyone! Not sure if this is the right place to ask I am a total newbie in Pentaho so I will appreciate any help. I have troubles in making a calculated member in a virtual cube in Schema Workbench. I have a dimension which tells whether a town is electrified or not, so I have to use it in calculations - for every town which has electricity, I have to sum the people (in all towns) and then divide the whole year electricity consumption to that sum, so I can see what is the year consumption for every person. I have already created the measure which shows the year consumption and the other which shows the number of people in every town.


#Pentaho
Johan Hammink's profile image
Johan Hammink posted 06-06-2018 05:37

Create a Calculated Member and in the formula set : [Measures].[YearConsumption]/[Measures].[NumberPeople]

In the Samples directory you can find the Foodmart.xml with a Virtual Cube with Calculated Member in it as an example

Related Content