Click & DECiDE Patch Notes

Click&DECiDE^® BAI Version 15.1.0 - Friday, July 31, 2015

Major Enhancement(s)

ID	Product	Component	Description
001	Framework Server	Web Portal	The way to create and manage your favorites in the Web Portal has been improved. You can add a picture, you can move them with the mouse to change the order, one of them can be run automatically when you open the Web Portal.
995	Framework Server	Web Portal	Through the Publish button, the Highlight and Information have been removed and now only the RSS Feeds remain available. The RSS Feeds have been improved, you can add a picture, they are now displayed in the Web Portal near the Favorite in a separate box named "News".
996	Framework Server	Web Portal	A new type of Shared Folder is now available: in the Menu you can specify a Calendar View and define the suffix format. By default any file ending with YY, YYMM or YYMMDD will be display in the concerned days, months and years in the Calendar View.

Enhancement(s)

ID	Product	Component	Description
002	Framework Server	Dashboards	When insterting a new Google Chart object such a Table, the "allowHtml = true" property is now added by default. This option is mostly required when the user wants to add some attributes such as background color or Bar depending on the numeric values.
003	Framework Server	Menu Builder	When defining a Menu Branch to give access to Web Builder, the Menu Administrator can now select several Data Sources in the list among the existing Data Sources with Security defined in Administration Manager.
004	Framework Desktop	Builder	Some new commands in Builder can create a Date or DateTime field from some numeric Packed fields. Make a right mouse click on such a field and select the required function such as YYYYMMDD to Date, YYYYMMDD to DateTime, Milliseconds to DateTime or Add seconds to a YYYYMMDD Date field to get a DateTime field.
962	Framework Server and Desktop	Services and Runtime	Some Click&DECiDE Services and Runtime programs (such as the d7vnrt.exe) have been improved to get best performances and stability.
998	Framework Server	Web Portal	The Web Portal can now include a special page to display inernal Support information from the Company to the end-users.
1003	Framework Server	Builder	The limit size of 16 Kb for any Builder function file (*.fn) has been increased to accept bigest files.

Major Hotfix(es)

ID	Product	Component	Description
981	Setup	Web Portal	When a User was only "Task Manager" without having the right to manage the "Scheduled Tasks", it was possible for him to delete a Task without getting a warning in case of this Task was referenced into a Scheduled Task. This problem has been fixed.
983	Setup	Web Portal	In the case when version 15.0.0 has been installed in another location than the default one (C:\Program Files\Click and DECiDE), the update to 15.0.1 will set wrong registry entries. The Configuration Wizard will then fail to start looking for some file in the default location that does not exist. This problem has been fixed.
984	Framework Server	Web Portal	A report based on a Cross-Table Rawdata was working fine inside Builder but was not working through the Web Portal. This problem has been fixed. In Builder the "Data Source" box for such a Report was not displaying the Cross-Table list. This problem has been fixed.
1002	Framework Server	Builder	A report based on a Cross-Table Rawdata was not working if at least a Column Dimension was collapsed. It was necessary to make it expanded to get it working. This problem has been fixed.
1004	Framework Desktop	Builder	A Report based on a Cross-table could give a wrong result if the Total columns were activated in a cross-table. They are not displayed because the user can create the Total in the report, but now the number of native columns from the cross-table is correct.

Minor Hotfix(es)

ID	Product	Component	Description
997	Framework Desktop	Builder	Paste of XML native Query in Builder leads to protection fault. This problem has been fixed.

Critical Hotfix(es)

ID	Product	Component	Description
908	Framework Desktop	Builder	A GPF occurred when calling the printing dialog box for a query and then clicking Cancel in the print dialog box. This problem has been fixed.

Click&DECiDE^® BAI Version 15.0.1 - February 27th, 2015

Major Enhancement(s)

ID	Product	Component	Description
001	Framework Server	Web Portal	The Microsoft Cubes made with a 32-bit Builder version can now be run through the Web Portal 64-bit if using a 32-bit Internet Explorer browser, or can be exported to an Excel Pivot Table 2007 or greater from this Web Portal.
002	Framework Desktop	Builder	A Builder 64-bit Report can still use a Microsoft Cubes made with a 32-bit Builder version as a data source. Warning: the only restriction is that a Report cannot include anymore a Data Cube or Chart Cube as an object.
003	Framework Desktop	Builder	A new version 13.1 of Builder 32-bit is now available to be compliant with the 64-bit version, allowing to save the project locally (computer) or through the Web Portal, so that the content can be shared with other users and can be used to create Microsoft Cubes.

Enhancement(s)

ID	Product	Component	Description
944	Framework Server	Database	iSeries Data Source: Query/400: the INNER JOIN statement is now managed.
967	Framework Server	Web Portal	When sending an e-mail from a Task, the main text area allows now to enter several rows.
958	Framework Desktop	ODBC Excel	An Excel (.XLS) file was locked when connected by an Excel ODBC Data Source to Builder. Now you can modify either an XLSX or XLS Excel file even if in use through an ODBC Excel Driver.

Major Hotfix(es)

ID	Product	Component	Description
941	Framework Server	Database	The ODBC Data Source may return columns that do not belong to a table, when a table contains the "_" special character. This problem has been fixed.
966	Framework Server	Web Portal	The =hyperlink() function in an e-Mail text sent by a Task was not returning the correct URL (if the output format was HTML). This problem has been fixed.
968	Framework Desktop	Builder	When formatting numeric data using a Highlight condition using for example #,###.00, Builder was not taking care about the Regional Settings for the thousand and decimal separators. This problem has been fixed.
974	Framework Server	Web Portal	In a Dashboard Category Filter, the number of the column to be used for this filter was not saved. This problem has been fixed.

Minor Hotfix(es)

ID	Product	Component	Description
969	Framework Desktop	Builder	When using the "Repeat Section" option in a Report with break levels, the last section was repeated in the last page of the report (Report Footer). This problem has been fixed.
971	Framework Server	Web Portal	Exporting to Excel through a task with a destination cell equal to or greater than row 10 was not working. This problem has been fixed.
932	Framework Server	Web Portal	A parameter in Builder using the "First Column Hidden" option was not working as expected through the Web Portal. This problem has been fixed.

Click&DECiDE^® BAI Version 15.0.0 - December 31th, 2014

Major Enhancement(s)

ID	Product	Component	Description
001	All Products	Version 64-bit	This is the first version full-64 bit of Click&DECiDE
002	Framework Server	Dashboard	The create command proposes now a new module: Create Pivot Table. Define your own Pivot Table, using Table or Chart presentation, then save the result in any Shared Folder in a Menu, as a MyPivot.xpt file. The end-user will access this Pivot Table using this file.
003	Framework Server	Data Source	New Data Sources are now available to create queries using the Google BigQuery Database or SQL Server Azure. You also can send data from any database to these databases.
004	Framework Server	Administration Manager	On the User Group and User level, it is now possible to manage many different rights, such as create a Pivot Table, create a Dashboard, create or delete a folder or User Folder or Group folder, write inside a folder or User Folder or Group folder, Manage Users, Manage Flow, Execute or Manage Scheduled Tasks, Manage Tasks etc.
925	Framework Server	Builder	Click&DECiDE Builder allows now to save a project locally (computer) or through the Web Portal, so that the content can be shared with other users. Because of that new feature, the projects are not saved anymore automatically and the "Tools" > "Compact Project" command has been removed, but the project is compacted each time you save it.

Enhancement(s)

ID	Product	Component	Description
948	Framework Server	Database	iSeries Data Source: new function to calculate a Date field from 3 distinct numeric fields Year (4 digits), Month (2 digits) and Day (2 digits).
936	Framework Server	Web Portal	When exporting to HTML, the "Export to File" button is now greyed, as not available for multi-files output formats.
935	Framework Server	Web Portal	The "Schedule" Menu branch and the "Save Task" button are not visible when the license does not allow scheduling tasks, even if the User Group is defined as Task Administrator in Click&DECiDE Administration Manager.
934	Framework Server	Database	iSeries Data Source: new function to Changes a numeric JULIAN Date from YYYNNN to a date field DD-MM-YYYY. YYY being the year since 1900 and NNN being the day in the year (001 to 366).
929	Framework Server	Database	DB2-UDB Data Source: now the GRAPHIC, VARGRAPHIC and LONG VARGRAPHIC field types with Unicode characters are supported in a query.
923	Framework Desktop	BAI Engine	When exporting to Excel XLSX, the program now is using the Default Temp directory associated to the current Windows User or C:\Windows\Temp if no profile is defined for the Services or the Scheduled Tasks. This method will avoid right permission sometimes on the "%D7VISION_PATH%\Temp" directory.
922	Framework Desktop	Builder	The copy and paste function from the Builder Data Grid to Excel takes care now to the numeric decimal separator and date formats.
827	Framework Desktop	Builder	Builder displays now the number of records retrieved by a native SQL query in the status bar.

Removed Features since version 13.0.4 (32-bit)

ID	Product	Component	Description
100	Framework Desktop and Server	EBIS Dashboards	EBIS Dashboards are no longer available in this 64-bit version and can be replaced using Google Chart Dashboards, with more powerful features and without the need to install any client module.
101	Framework Desktop and Server	Microsoft Cubes	Microsoft Cubes using the Microsoft Web Components 2003 are no longer supported. They can be partially replaced using the new Pivot Table module through the Web Portal or the Google Charts also including this module.
102	Framework Server	Tasks and VBScript	When creating a Task through the Web Portal, the "Generate a VBScript" button is no longer available. If you really need to generate some VBScripts, you can ask your provider to send you the "CnDSampleAutomation.exe" program, to be copied into the C:\Program Files\Click and DECiDE\BAI\samples\Automation directory.

Click&DECiDE^® BAI Version 13.0.6 - November 5th, 2014

Last Enhancements from Last 32-bit Version 13.0.6

ID	Product	Component	Description
963	Framework Desktop	Builder	A new search box appears now to help the Builder User to search a table in the Table List (Table Tab) when creating or editing a query. Enter a character or a string will display only the Table(s) beginning with this argument in the Table List. Enter a star followed by a character or a string will display only the Table(s) containing this argument in the Table List.
963	Framework Desktop	Builder	A new search box appears now to help the Builder User to search a Column in the Query Column List (Query Tab) when creating or editing a query. Enter a character or a string will put the focus only the first Column beginning with this argument in the Query Column List. Enter a star followed by a character or a string will put the focus on the first column containing this argument in the Query Column List. Two black arrows allow the User to search the next or previous column containing this argument.
961	Framework Server	Database	iSeries Data Source: new function to calculate a Date field from one unique numeric field CYYMMDD containing Century (1 digit), Year (2 digits), Month (2 digits) and Day (2 digits).
948	Framework Server	Database	iSeries Data Source: new function to calculate a Date field from 3 distinct numeric fields Year YYYY (4 digits), Month MM (2 digits) and Day DD (2 digits).
934	Framework Server	Database	iSeries Data Source: new function to Changes a numeric JULIAN Date from YYYNNN to a date field DD-MM-YYYY. YYY being the year since 1900 and NNN being the day in the year (001 to 366).
929	Framework Server	Database	DB2-UDB Data Source: now the GRAPHIC, VARGRAPHIC and LONG VARGRAPHIC field types with Unicode characters are supported in a query.
923	Framework Desktop	BAI Engine	When exporting to Excel XLSX, the program now is using the Default Temp directory associated to the current Windows User or C:\Windows\Temp if no profile is defined for the Services or the Scheduled Tasks. This method will avoid right permission sometimes on the "%D7VISION_PATH%\Temp" directory.
922	Framework Desktop	Builder	The copy and paste function from the Builder Data Grid to Excel takes care now to the numeric decimal separator and date formats.
952	Framework Desktop	Builder	When sending a cube to Excel Pivot Table, sub-totals are not displayed in Excel if not enabled in the cube.
437	Framework Desktop	Builder	You can now sort the Table information (Column Name, Column Type etc.) displayed in the Builder Table Tab with 3 modes: Ascending Sort, Descending Sort or Original Sort (the one defined in the table).
249	Framework Server	iSeries	The iSeries D7SRV sub-system provides now an option to avoid end-users to run another command than "SELECT...". Refer to the KBA249 on the Click&DECiDE Web Site.
899	Framework Server	Dashboard	Several new Google Charts are now proposed in this release: Annotation Chart, Calendar Chart, Donut Chart, Histogram Chart, Sankey Chart, Timeline Chart, Dashboard with String Filter, Dashboard with Chart Range Filter, Dashboard with Number Range Filter and Dashboard with Category Filter, making easy and faster the way to create Dashboards.
901	Framework Server	Dashboard	A new object is now available in the "Other Objects" list: the Pivot object allowing to create cubes working under Internet Explorer, Chrome and Firefox and without the need of the Microsoft Web Component 2003.
890	Framework Server	Web Portal	The HTML Navbar allows now to use some keyboard keys to navigate easily. Left or Up Arrows = Next Page, Right or Down Arrows = Previous Page, Home key = First Page, End Key = Last Page, Page Up and Page Down = Next or Previous block of X pages depending on the total number of pages.
885	Configuration	Wizard	The silent installation of Builder must be followed by the execution of the Configuration Wizard. This program can now be run in silent mode and install the Demo database in SQL Server and create the Local SQL Server data source using the command d7vWZConfig.exe /samples.