Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: mdx and parameters

  1. #1

    Default mdx and parameters

    Just wondering can you pass parameters into a mdx query
    like you would in a sql query if so how would you do that?

  2. #2

    Default Re:mdx and parameters

    Hi,

    Yes, it is possible. You'll just have to include the {ParamName} on your MDX.
    Code:
    [CDATA[select NON EMPTY {[Measures].[Un]} ON COLUMNS,
      NON EMPTY {TopCount([Clients].[All Clients].Children, 10.0, [Measures].[Value])} ON ROWS
    from [Sales]
    where [Time].[All Periods].[{Year}]]]

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.