Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: MDX with parameters

  1. #1

    Exclamation MDX with parameters

    Hi,
    I want to use a parameter within the MDX query for a report that is been created with Pentaho Report Designer. I cannot get it working.

    select {[Time.Financial Calendar].[All Financial Years].['${fin_year}'].[1].[JULY ]} ON COLUMNS,
    NON EMPTY {[Measures].[Total Revenue]} ON ROWS
    from [Cube]

    fin_year is the name of the parameter.Is this the right way of using the parameters within the MDX query

  2. #2
    Join Date
    Dec 2005
    Posts
    531

    Default

    Have a look at: http://diethardsteiner.blogspot.com/...ho-report.html

    From what I can tell you need to use a function like parameter("parametername", dimension, member default value) instead of pasting ${fin_year} into the statement.

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.