Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: SQL to MDX query

  1. #1

    Exclamation SQL to MDX query

    Hi All,


    How can i write a parameter in MDX query,
    my query looks like below,

    select stat,percent from table0
    where sname = ${Sname}

    If i want to pass parameter: Sname to MDX query, how and where can i pass it?

    Any help,

    Thanks & Regards,

    - Nirav Maisuriya
    Open Source BI Developer

  2. #2
    Join Date
    Aug 2012
    Posts
    15

    Default

    You can pass parameters in the same manner as in sql,

    select [Measures].[Abc] on 0, [Dimension1].Members on 1 from [CubeName] where ([FillterDimension].[LevelName].[${Sname}])

  3. #3

    Default

    hi,

    thanks kanak for the help.

    Regards,

    - Nirav Maisuriya
    Open Source BI Developer

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.