Flushing the cache

Added some data in Jira and changes are not immediately displayed on an analytics client tool (Excel,..)?

The Analytics Server (Mondrian) uses a cache for objects like schemes (a set of cubes) among others. The H2 data source used to fetch data from Jira uses a cache to by supporting materialized views, one of the techniques recommended by Mondrian to improve performance. Therefore changes might not be reflected on the client tool until the cache is flushed.

Unfortunately, the XMLA protocol does not support any method to flush caches. Currently, this has to be performed by the Jira user. 

A Jira url is provided to flush the Analytics Server cache:

Click on the Manage Cubes icon from the Analytics Client console:

This will open the page listing all the saved schemes/catalogs. The link to flush the cache is available on the top left of the page.

You can save that link somewhere on your laptop and clean the cache with a single click. The URL to flush the cache is:

${JIRA_BASE_URL}/secure/MarketExpertMondrianSchema!flushUser.jspa

Remember that you have to logged in Jira previously.

Perhaps your anlytics client tool has also a cache. Then you have to flush it too. For example, in Excel:

• clik on the Pivot chart,
• click on the Analyze tab
• click on the Refresh button 

The report should be refreshed and the changes taken from Jira.