Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Worng/mixed parameter values on PRD 6.0

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    May 2017
    Posts
    4

    Default Wrong/mixed parameter values on PRD 6.0

    I have a report that is using 10 parameters (2 main ones, and 8 are calculated) and I'm having a problem since the parameters are "mixing" the values.

    The parameters are (by this order):
    • DATEFROM
    • dateFromFormated (depends on DATEFROM)
    • dateToFormated (depends on DATEFROM)
    • Schema
    • Schema_db1 (depends on Schema)
    • Schema_db2 (depends on Schema)
    • Schema_db3 (depends on Schema)
    • hourDiff (depends on Shema_db1)
    • convertedFrom (depends on dateFromFormated and hourDiff)
    • convertedTo (depends on dateFromFormated and hourDiff)


    To check the values, I have commented code on the query:
    /*
    ${DATEFROM} as DATEFROM
    ${dateFromFormated} as dateFromFormated
    ${dateToFormated} as dateToFormated
    ${Schema} as Schema
    ${Schema_db1} as Schema_db1
    ${Schema_db2} as Schema_db2
    ${Schema_db3} as Schema_db3
    ${hourDiff} as hourDiff
    ${convertedFrom} as convertedFrom
    ${convertedTo} as convertedTo
    */

    When I run the report, with the following values:
    DATEFROM = 2018-01-15
    Schema = test
    hourDiff = 3600000

    The report returns the values on the parameters
    /*
    1514764800000 as DATEFROM
    1514851200000 as dateFromFormated
    'test' as dateToFormated
    'test.db1' as Schema
    'test.db2' as Schema_db1
    'test.db3' as Schema_db2
    3600000 as Schema_db3
    0 as hourDiff
    0 as convertedFrom
    'test.db3' as convertedTo
    */

    Any clue on what I am doing wrong?
    Last edited by Costa; 01-15-2018 at 11:10 AM.

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.