Use Analysis Cubes in Report Designer

Pentaho Report Designer is typically used with raw data sources, or with databases that have a metadata layer through a tool like Pentaho Metadata Editor. However, you can also use an MDX query to retrieve a data set from a multidimensional database. The sections below explain how to set up a Pentaho Analysis data source and add an MDX query in Pentaho Report Designer.

Note: For more information on Report Designer, consult the section Design Print-Quality Reports in the Pentaho InfoCenter, or through the Documentation link in the Help menu in Report Designer.