US and Worldwide: +1 (866) 660-7555
Results 1 to 2 of 2

Thread: Handling Boolean Type in Calculated measures

  1. #1
    Join Date
    Apr 2013
    Posts
    2

    Default Handling Boolean Type in Calculated measures

    Hi,
    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:

    COALESCEEMPTY([Measures].[LogEvent],[LingoEvent].[IsLogCount].&[True])

  2. #2
    Join Date
    Jan 2013
    Posts
    521

    Default

    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.

    ([Measures].[LogEvent],[LingoEvent].[IsLogCount].&[True])

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •