Query MS Analysis Services 2005 from Java

Posted on 2007-10-01
Last Modified: 2013-11-16
How can i query Microsoft Analysis Services using MDX from inside a Java application?  Where can i find a library that will allow me to connect and query (preferrably for free)?
Question by:dave4dl
    LVL 17

    Expert Comment

    by:Dejan Pažin

    Mondrian implements MDX, maybe you could use that:
    LVL 15

    Author Comment

    Mondrian is an OLAP database (analogous to Analysis Services itself).  I need to connect to an existing Analysis Services database (in a Java program).
    LVL 17

    Accepted Solution


    MDX is a proposed standard language and Mondiran has implemented it by specifications (plus added some of its own functions). Read more here:

    In other words: Mondrian contains  the library you need. You dont need the whole Mondrian, you only need the MDX implementation.

    I couldnt find any other free mdx implementation in java.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.
    This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now