You can fetch data from a Mondrian cube through an MDX query. To access the data through a Mondrian cube, provide the JNDI or JDBC connection properties, the name of the Mondrian schema file (XML), and the MDX query which will return the data. There are four types of MDX data sources:
- denormalizedMdx over mondrianJdbc
- denormalizedMdx over mondrianJndi
- mdx over mondrianJdbc
- mdx over mondrianJndi
MDX queries can be normalized or denormalized. The specifics of each type of query are detailed in the CDA documentation.