Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: MDX Tool

  1. #1

    Default MDX Tool

    Is there any tool available that can help me write MDX queries? - I am pretty much struggling with the simplest of mdx queries even though i understand sql pretty well. Since i have to nail down some immediate reports for my boss it will be great to be able to use some kind of tool even if its not close to perfect.

    I figured out this tool Rex (waRehouse EXplorer) but not sure if its the correct one. I was unable to configure it as i don't know the datasource paths for pentaho.

  2. #2

    Default

    If you use any available GUI you can get the queries by constructing them. Currently in Pentaho CE you can use Pivot4j or Saiku (use Marketplace to install needed plugin). Both will help you build the query visually and provide resulting MDX. Those provided queries are a good start. Then you just read the documentation of MDX and experiment.

  3. #3
    Join Date
    Jan 2013
    Posts
    796

    Default

    Saiku and Pivot4j are good options. Rex is a pretty good tool as well-- if you're using Pentaho you'll need to enable Xmla to the Analysis connections. ( EnableXmla=true )

    The XMLA URL will be something like
    http://localhost:8080/pentaho/Xmla?u...sword=password

    One thing to be aware of- the pentaho install by default sets MDX case sensitivity to true, which is annoying for someone entering manual MDX. Find the mondrian.properties file under system/mondrian and turn that off.

  4. #4

    Default

    Thank you guys - I am giving Saiku a spin right now! will see how it goes.

    @Case sensitive - THAT's it -- i was annoyed with case sensitivity already. I will just disable it.

  5. #5

    Default

    And to be quite clear -- knowing SQL will not help you in mastering MDX. In some cases good SQL skill (not knowledge, but skill) will make your head blown with MDX constructs. So try to start fresh as if you know nothing about querying -- thats my IMHO on the subject.

    Please, keep going on MDX -- that is the really amazing thing when mastered well

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.