Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Handling Boolean Type in Calculated measures

  1. #1
    Join Date
    Apr 2013

    Default Handling Boolean Type in Calculated measures

    I created a Dimnsion called LogCount and Hierarchy as Logcount, I have a level inside the hierarchy as IsLogCount (boolean). I have a measure LogEvent which gives me the count of logs. Now I want to have a calculated measure which gives me the count of logs having IslogCount as True only. Below is the query could anyone help me:


  2. #2
    Join Date
    Jan 2013


    Unless I'm misunderstanding, a tuple should be all you need. For example, in Foodmart if you want to define a calculated member that is the count of customers who are female, you could simply define the tuple:

    ( [Gender].[F], [Measures].[Customer Count])

    Similarly you should be able to just define the intersection of Log.[True] and your measure-- no need for COALESCEEMPTY.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2017 Pentaho Corporation. All Rights Reserved.