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

    Default

    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
    [Time].[Years].[Quarters].[Months].[Days]
    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

    Tom

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.