Thursday, September 27, 2012

Because NextReports is a reporting tool, it can be used to make analysis even on itself. We use NextReports to analyze the download process of its artifacts: engine, designer, server and update (designer download started from application update).

To make this analysis possible a simple pivot is used. This pivot can show things like:

location from where the download was started through fields like country, city, ip.

artifact that was downloaded through fields like product, file, version

time when the download was done through a date field

A simple selection that shows the number of downloads for every artifact is like this:

Report used by pivot also has parameters which allows to filter data. For example it is easy to select a period of time between to dates, country, product, version:

Results will show more than simple statistics. It is easy to spot attacks of Denial Of Service type if a large number of downloads is seen from the same ip:

Also it is possible to know how many downloads are done in a period of time, seeing totals for product or for artifact:

This is just an example when NextReports pivot can be really useful to make analysis and get a lot of answers from raw data.

Monday, September 24, 2012

NextReports Server allows users to add a pivot widget inside a dashboard. This pivot can be created from any report found on server. Pivot widget is based on a simple sql query without OLAP integration.

User selects what he wants to see on ROW, COLUMN and DATA. Also two check boxes will make the totals for rows and columns visible or not.

When user clicks compute, data is presented to user. Also, on compute action, user selection is saved and when user returns to the widget, this selection is made automatically.

Being a widget, user can also detach a pivot and make it as big as the screen with F11 key to have more space if needed.

Demos

Loading...

Alternative Search

Search This Blog

Loading...

Follow by Email

About Me

Mihai Dinca-Panaitescu

Working with Java since 1998 with focus on both server back-end and UI.

In the late 90's till 2003 when not so much frameworks were present I was involved in proprietary server implementation (with all the technology from that time like RMI, JDBC, transactions, Servlets, XML, XSL), user interface with SWING and a lot of algorithms for agriculture business.

In middle 2000's I was involved in many custom development projects adding more flavor to my knowledge : JBoss and OC4J servers, J2EE, Hibernate, EHCache, Ant, JUnit, TestNG

From 2008 I was part of NextReports, starting with designer development in SWING.
Then NextReports Server came to life and new technologies were adopted : Spring, JPA, JCR, Wicket, jQuery, Jersey, Maven, Ivy, Git, Android.

Since starting of 2014 I developed a HTML5 library called NextCharts which can be found on github.

I’m currently part of the NextReports developing team at Advantage Software Factory, a local leading provider of business software solutions. NextReports is a business reporting suite composed of reports designer, reporting engine and reporting server. Besides this product, ASF also developed a debt collection software and a CRM solution.