topic Alfresco Business Reporting in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/alfresco-business-reporting/m-p/2229#M323 <HTML><HEAD></HEAD><BODY><P>Business Reporting should be handled by the Business. Therefore reporting should use an existing tool and plain and simple SQL. Currently, reporting in Alfresco is not that easy, and many alternatives are tech-driven. This project allows the business to use their reporting suite of choice against 'plain tables' containing your Alfresco business objects. As a 'proof', Pentaho Reporting and JasperSoft (iReport) reports are supported to generate reports, on a regular automated manner (if you like). But feel free to use any BusinessObjects, Cognos, Clickview.</P><P></P><P>This project is build on 2 parts.</P><P></P><P>1. Generate a reporting database based on business entities like Document, Case, Folder, Site etc. Each of these entities should contain all possible attribute values (even with Alfresco's Aspect feature providing flexible, runtime extensions) This reporting database can be filled from scratch, or incrementally since last update. Any Lucene query can define the content of the tables. (Think Aspects, Types, property values.)</P><P>2. Given a reporting database, report execution can be scheduled (thing hourly, daily, weekly, monthly). The result can be a pdf or xls files that will be stored in the Alfresco repository. Reports can have the scope of a Site only (or a user, or another container-like concept), executed against that site, and stored within that site. Currently Pentaho reporting is the supported reporting engine.</P><P></P><TABLE class="j-table jiveBorder" style="border: 1px solid #c6c6c6;" width="100%"><THEAD><TR style="background-color: #efefef;"><TH style="width: 19.5066%;"></TH><TH style="width: 78.7972%;"></TH></TR></THEAD><TBODY><TR><TD style="width: 19.5066%;">Owner</TD><TD style="width: 78.7972%;"><B>tpeelen _</B>‌</TD></TR><TR><TD style="width: 19.5066%;">Versions</TD><TD style="width: 78.7972%;"><P>Community 3.3.x</P><P>Community 3.4.x</P><P>Community 4.0.x</P><P>Community 4.2.x</P><P>Enterprise 3.3.x</P><P>Enterprise 3.4.x</P><P>Enterprise 4.0.x</P><P>Enterprise 4.1.x</P></TD></TR><TR><TD style="width: 19.5066%;">License Type</TD><TD style="width: 78.7972%;">GNU General Public License (GPL)</TD></TR><TR><TD style="width: 19.5066%;">Project Page</TD><TD style="width: 78.7972%;"><A class="link-titled" href="https://github.com/Alfresco-Business-Reporting/alfresco-business-reporting" title="https://github.com/Alfresco-Business-Reporting/alfresco-business-reporting" rel="nofollow noopener noreferrer">GitHub - Alfresco-Business-Reporting/alfresco-business-reporting: Business Reporting should be handled by the Business. …</A>&nbsp;</TD></TR><TR><TD style="width: 19.5066%;">Download Page</TD><TD style="width: 78.7972%;"><A class="link-titled" href="https://github.com/Alfresco-Business-Reporting/alfresco-business-reporting/releases" title="https://github.com/Alfresco-Business-Reporting/alfresco-business-reporting/releases" rel="nofollow noopener noreferrer">Releases · Alfresco-Business-Reporting/alfresco-business-reporting · GitHub</A>&nbsp;</TD></TR><TR><TD style="width: 19.5066%;">Tags</TD><TD style="width: 78.7972%;">Reporting, ABR, Pentaho, Business, Repository, Statistics, Jasper, Business Intelligence, Report, Audit</TD></TR><TR><TD style="width: 19.5066%;">Component Type</TD><TD style="width: 78.7972%;">Action, Content Model, Document Library, External Utility, Integration</TD></TR><TR><TD style="width: 19.5066%;">Extension Points</TD><TD style="width: 78.7972%;">Behavior, Content Model, Javascript Root Scope Object, Scheduled Job, Share Form, Explorer UI (Obsolete)</TD></TR><TR><TD style="width: 19.5066%;">Installation</TD><TD style="width: 78.7972%;">AMP, JAR</TD></TR><TR><TD style="width: 19.5066%;">Products</TD><TD style="width: 78.7972%;">Repository, Share Web Client, Explorer Web Client (Obsolete)</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 13 Jun 2018 01:19:46 GMT alfresco 2018-06-13T01:19:46Z Alfresco Business Reporting https://connect.hyland.com/t5/alfresco-forum/alfresco-business-reporting/m-p/2229#M323 Business Reporting should be handled by the Business. Therefore reporting should use an existing tool and plain and simple SQL. Currently, reporting in Alfresco is not that easy, and many alternatives are tech-driven. This project allows the business to use their reporting suite of choice against 'p Wed, 13 Jun 2018 01:19:46 GMT https://connect.hyland.com/t5/alfresco-forum/alfresco-business-reporting/m-p/2229#M323 alfresco 2018-06-13T01:19:46Z Re: Alfresco Business Reporting https://connect.hyland.com/t5/alfresco-forum/alfresco-business-reporting/m-p/2230#M324 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>From the add-on description above I got that the highest supported Alfresco Community version is 4.2.x.</P><P>I'd like to run the add-on with&nbsp;<SPAN>Alfresco Community 5.2 so</SPAN> I wonder if this add-on works correctly with Alfresco Community 5.2 or if I have to use some other alternative add-on for this Alfresco version<SPAN>.</SPAN></P><P></P><P><SPAN>Best regards,</SPAN></P><P><SPAN>Sergey Kolosov</SPAN></P></BODY></HTML> Thu, 01 Nov 2018 10:02:16 GMT https://connect.hyland.com/t5/alfresco-forum/alfresco-business-reporting/m-p/2230#M324 s_kolosov 2018-11-01T10:02:16Z