Managing Web Reporting – Part 2

After being out in the wild for over 12 months, the Performance Dashboard has been one of the most popular posts on our blog. As it was originally written for in Jedox 5.0, we have updated it to reflect the latest functionality in 5.1 SR2. New Features

  • Hits chart now using a Stock type chart, that allows zooming in to specific days
  • Hits by Hour, to allow you to zoom in on the busiest time of the day
  • Doughnut chart now shows the report  for a specific hour, vs overall usage
  • Filters are clearer, and easy to reset.
  • Login stats, to see the numbers of users logging onto the server (including from Excel).
  • On the report tab, you can now open the specific report that you are analysing.
  • The ad-hoc tab now has a heatmap which helps with visualisation of the most popular reports. The drop list on this tab also now has the complete File Manager hierarchies to enable you to navigate easily.

NOTE: If you truncate your logs, please ensure you truncate the olap server log and the core log at the same time. As the Dashboard uses data from both logs so if they are out of sync, the numbers displays might not be correct. Installing the new Dashboard Download the .pb file here This is basically the same steps as the last Dashboard (which you can find here), but I will repeat the process for anyone doing it for the first time: 1. Log in to Jedox Web, and go to File Manager. Import the .pb file 2014-10-24 13_55_24-Jedox Web 2. Once imported, you should see the following: img1 3. Download the Jedox-Stats.xml. This is a Jedox ETL Project. Open ETL Manager and import the project. 2014-10-24 11_36_24-Jedox Web 4. Download the Jedox-Stats.zip. Unzip this file. This is a Jedox database that you need to add to your Jedox data folder (stop the Jedox MOLAP Service first). 5. Start the MOLAP Service. Note, you can now change the ETL parameters on the dashboard itself: 2014-10-24 14_00_05-Jedox Web 6. Click the Run Stats button on the Dashboard. This will populate your cube with the settings from your system. 7. Once you have ran the ETL, refresh the Performance Dashboard. It should look something like this: 2014-10-24 13_50_14-Jedox Web You’re done! The idea of this Dashboard is to make managing your Jedox web reporting portal easier. If you know what reports are being used and which ones are not, you can manage report development and prioritise the types of reports that users are using.

3 thoughts on “Managing Web Reporting – Part 2

  1. Stephan Wetzelsberger

    Hello,
    the dashboard is awesome. But since we updated to Jedox version 6.0 it doesn’t work anymore. Is there a general issue with the new version ?

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s