Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Retrieving Dates

  1. #1

    Default Retrieving Dates

    I've created a report that retrieves data based on a date range. I would rather not use a date range, but instead a command or function that reports the current month. I was thinking of using something like a DATEADD function, but I'm new to this so I wasn't sure. What would be the best way to solve this issue?

  2. #2


    I'm not quite sure what your getting at southernbook, but I have written a few reports in MDX that are designed for business users and report on a time scale, so for example, create a report with
    Then you can call any of the above for the appropriate data.

    Also when designing the xaction its easy enough to add javascript or secure prompt filters to manually select a date or time or from a system clock.

    Hope thats of a little help if you can elaborate a little more I may be of a little more help


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.