Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The app starts a XML/A server on Jira listening to this URL:


Info
titleXML/A Server URL

<Jira Base URL>/jira/plugins/servlet/kintosoftmarketexpert/mondrian/xmla/



We will use Excel as BI client example to connect to Jira via the XML/A protocol. 

You can watch a video showing this tutorial at 3 min 51 secs.

Widget Connector
urlhttp://youtube.com/watch?v=gHJdEkTtH_o


First of all, you have to create a Mondrian schema on Jira. Please follow the steps described in this section: Getting started (Tutorial).

Then download the free XMLA connector for Excel and install it. The connector installs a complete tutorial in Excel that you might want to watch (optional):

...

<Jira Base URL>/jira/plugins/servlet/kintosoftmarketexpert/mondrian/xmla/

and your Jira user's credentials (User name & Password). Then select a Catalog:

...

Click on Fnish and close the rest tof the dialogs. The Analyze tab is selected in Excel showing a Piot Table on the left and the cube Measures and Dimensions on the rigt:



Click on the Issue count option in the Values (Measures) box, This counts all the issues in the cube (JQL):

Image Added

Now select the Priority, Staus and Type dimensions. This will group the data according the selected dimensions:


Image Added

Select the data fro the table and add achart in the regular way:


Image Added