It exports Click on it to export the current JQL into the Analytics Client console (Saiku Community Edition).  

Working with Measures and Dimensions: the Pivot Table

Select the Jira Core cube.:

This will load the Cube with its Measures and Dimensions:

...

The issue key for the eight done stories are listed!

MDX behind the scene

Easy no? But what is it happed behind the scene? You have been building a MDX query behind the scene! Click on the Show MDX button:

...

The good news are that you can build awesome complex MDX queries in a visual way (with darg and drop) without any knowled about the MDX language!

Save the scheme (catalog)

Actually the cube is volatile and it will be lost if the console is abnadoned. You can save it for later use. Click on the Save button and provide the Demo name for the Catalog (a set of cubes grouped in a Mondrian schema):

...

Clcik on the Save button to close the dialog. The catalog is now saved in the Jira database!.

Listing saved schemes

Click on the Manage cubes button to list the saved catalogs in Jira:

...

A new page listing all the saved schemas (catalogs) is displayed. Click on the MDX Console button:

The MDX console and the XML/A protocol

The MDX console is opened. Type the 

...

The eight closed stories in the JQL are listed! You got the same results than from the Analytics client (Saiku). You have seen the XMLA protocol in action. It is possinle to connect to Jira to list the saved catalos and perfom MDX queires on their cubes. The MDX consle above is an example of a XMLA client tool. But you can use any third party compatible tool. You might want to use the Arquery's XMLConnector for Excel and connect to Jira from Excel to perform analytics (read the details in this dedicated tutorial).

Close the MDX Console anc clik click on the Download link to see the Mondrian's XML schema file:

...

What if you want to modify all the schemes to support a new measure and dimension? Must you edit and modify them one by one? The answer is not. You can modify the template in Jira, so all the new catalogs will use your custom template with your modifications.

Open a Scheme (with no state)

But let us please continue with this example. Click on the Analytics link to load the scheme in the Analytics Client (Saiku) again:

...

Note that the Saiku's Cubes section lists all the Mondrian schemes (AKA MDX Catalogs) names (Demo) along with the Jira user name (admin in this example):

Open a Scheme (with a saved state)

But wait, a MDX querie showing eight done stories was already performed. Is that MDX query gone? Do you have to repeat all the steps every time to restore a previous MDX query? The answer is no. You can load a previously saved MDX queeri in Saiku again by clicking on the Load button:

...