AnsweredAssumed Answered

Schema Workbench - Calculated member

Question asked by Veronika Florova on Jun 5, 2018
Latest reply on Jun 5, 2018 by Johan Hammink

     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.