Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: [XACTION] - Sql Query to define MDX query

  1. #1
    Join Date
    Sep 2008
    Posts
    13

    Default [XACTION] - Sql Query to define MDX query

    Hi everybody,

    I need to display a pivot table with a limited visibility on available week dimension.
    So, I am able to create some sql query to get the differents values of the weeks to display.
    Now, I have no idea how I can get this result to include them in my MDX query !

    Someone can help me ?
    Thank you very much.

    Christophe

  2. #2
    Join Date
    Jan 2007
    Posts
    485

    Default

    You have to create a "parameterized" MDX Query. I remember that among the report samples that ship with PCI-CEServer", their is one report that uses parameters and an MDX query. I suggest using that.

    Best of luck.

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.