XML/A

How to access XMLA data sources?

Use the xmlaQuery tag instead of mondrianQuery. You will have to enter the XMLA URI and a catalog name.

Example

    <jp:xmlaQuery
       id="query01"
       uri="http://MYSERVER/XML4A/msxisapi.dll"
       catalog="Foodmart 2000">
        select {[Measures].[Unit Sales]} on columns,
        [Product].[All Products].children on rows
        from Sales where ([Time].[1997])
    </jp:xmlaQuery>