Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Why: negative measures displayed as 0

  1. #1

    Default Why: negative measures displayed as 0

    Hi!
    I'm using Mondrian/JPivot in a JSP-application.

    I have a cube with this measure:
    Code:
    <measure name ="acc" column="acc" aggregator="max" datatype="Numeric" formatString="#,##.00" caption="%{measure.acc}"/>
    When the value for the measure is less than 0, "0.0" is returned!

    What's that? Is it a consequence of a misconfigurated datatype or format sring?

    Thanks for help!

  2. #2

    Default Bug!

    The causer of this error seems to be the max-aggregator!
    I added this senseless measure to my cube:
    Code:
    <Measure name="max_acc" aggregator="max" formatString="#,###.00">
         <MeasureExpression>
               <SQL dialect="generic">
                       -1
               </SQL>
         </MeasureExpression>
    </Measure>
    The value of this measure is 0 everywhere! With a sum-aggregator, correct values are returned.

    How can I get a correct negative maximum value???

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.