Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: specifying aggregation for calculated member in using schema workbench

  1. #1
    Join Date
    Aug 2011
    Posts
    2

    Default specifying aggregation for calculated member in using schema workbench

    Hi,

    I am fairly new to mondrian so this may very basic. I have defined a calculated member in the schema workbench tool which counts the number of phone calls received from a CDR table. Each record in the cdr table represents a phone record with a timestamps

    <CalculatedMember name="incoming calls" formula="iif([Measures].[call duration] > 0 0, 1, null)" dimension="Measures" visible="true">
    </CalculatedMember>

    [call duration] is a column in the cdr table

    Problem is aggregating on the time dimension always produces the value '1' instead of the sum of the [incoming calls] measure.

    Would really appreciate any help to get me past this.

    Thx much

  2. #2
    Join Date
    Aug 2011
    Posts
    2

    Default

    Sorry the correct XML is below:

    <CalculatedMember name="incoming calls" formula="iif([Measures].[call duration] > 0, 1, null)" dimension="Measures" visible="true">
    </CalculatedMember>

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 - 2019 Hitachi Vantara Corporation. All Rights Reserved.