Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How can I query periods of time in Cube Designer

  1. #1

    Question How can I query periods of time in Cube Designer

    Hello,


    I have a report created in Cube Designer.. I want to know if it is possible that the users can enter any range of dates to query information in especific periods of time.. For example query the sales between 01/03/2008 and 20/03/2008..


    Can I do this??? How?? and Where??

    If someone can help me I´'ll be very gratefull..

    Carolina

  2. #2

    Default

    Indeed you can, but the first time you try it may take some getting used to.

    Taking the finshed xaction you have to create the MDX code you want for the outputted table, then in the xaction editor you will have to create an input prompt that lets users select a date range, for example I use 2 drop down boxes to select year and month, then pass these as variables to the MDX query in the OLAP process.

    Tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

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.