Sapiens.BI PRO - Analytic Reporting

Hello Tiago,

We are now sending you the release notes over here, we will soon think of a better way of sharing and explaining those to everyone ;). In case you have not yet upgraded the latest version, you might like to wait a bit as we are planning to publish one more latest release tomorrow. We will contact you as soon as released ;).

1.5.63  Added first value aggregate  Fix - sugar native custom tables joined incorrectly  Fix - PDF did not outputted group headers 1.5.62  Added DE, AU, GB, BR, FR cities to map charts. Also made distinction between cities identified by country and state and only country based on addressing conventions in each country and available data  Fix - charts showed incorrect data for users without report editing access rights 1.5.61  Fix - combined report, assigned to field caused exception when selected in aggregate because it did not use same module name pattern 1.5.60  Added Funnel chart sort-able value (pick-list order) translation.  Fix - Added missing preset for combined reports to reportBuilder (caused error on MSSQL servers) 1.5.59  Added downloadable font checksum validator and re-downloader. 1.5.58  Added sorting by picklist values for crosstabs as well  Added multiple domain and sub domain licence validation  Fixed assigned_user_id problem for Funnel and Bar charts (drill down did not worked if grouped by assigned_user_id)  Added alternative method to fetch relations between modules (to support newest sugar versions) 1.5.56  Hide/unhide/show hidden reports only available for admin users  Fix, report owner was not update-able  Fix PDF grouping errors  Updated MSSQL convert with data type check. Changed varchar to nvarchar (Unicode). Refactored order by, so it will reuse arrays to unique filter equal date sorting (for example, Month with year and day for the same field would produce equal order by fields which MSSQL will not support)  Fix - non admin users are redirected to dashboard  Added CA cities to Map/Geographic Chart 1.5.55  Updated map chart to support sidecar 1.5.54  MSSQL support for module installation 1.5.53  Added US cities to Map/Geographic Chart  Fix, custom table options where not passed in report builder  Custom SQL for calculated fields  PDF fix for phones formatting  Sugar CE 6.2 version support. UploadFile does not have function get_file_contents in 6.2.  Snapshot tables are added automatically to reports (config file editing required previously)4  Shapshot GUI improvments  Added horizontal bar chart 1.5.52  Fixed - bug with calculated field sequence (removing non last calculated fields caused bugs) 1.5.50  Added public filter that allows to change filter field as well its attribute for users without editing access (changes do not persist)  Fix for widgets for SuiteCRM  Allow manage_licensed_users flag to be used in validation  Fix - Charts for users that do not have edit access did not worked  Fix for Sugar 7.7.1.1 support 1.5.49 (2016-09-15 2e52dfd83c33)  Fix - gauge chart number format and svg 1.5.48 (2016-09-07 2aa0010fe29c)  Fix - incorrect value for enable audit setting  Fixed widget entrypoints 1.5.47 (2016-09-06 141ef22df666)  Added separator between delete word in gui

Best Regards, IT Sapiens Team

Hello Tiago,

We have published the latest version of Analytic Reporting Tool today. I will send you the link to visualized instruction of the new features tomorrow. Today we are sending you the release notes:

1.5.75  Fix - modules can now be added to existing combined reports (previously only to standard) 1.5.74  Added option to ignore timezone adjustments for scheduler (AR Settings->Processes->Do not adjust time zone for scheduler ) 1.5.72  Added test scheduler GUI (AR Settings -> Test Scheduler) 1.5.71  Fix - MSSQL date interval arithmetic fix, current date function analogue implementation  Fix - MSSQL report builder fix 1.5.70  Fix - MSSQL users with read only access to report, cannot access it  Updated Japanese translation strings 1.5.67  Fix - MSSQL report list not loading for non admin users 1.5.65  Added Show top-n results for any grouping level 1.5.64  Fix - calculated field, if not empty case caused error  Fix - widget enlarge do not work

Best Regards, IT Sapiens Team