Click&DECiDE® ReadMe

The Versatile BI Solution.

Click&DECiDE® BAI Version 19.1.0 - Thursday, June 27, 2019

Enhancement(s)

IDProductComponentDescription
1253Framework ServerWeb PortalWeb Portal: you can now display Power BI reports from the Web Portal, by clicking a report definition file (.PBIX) which is in a shared folder.
1252BAI ServerOtherWe have added an option in Web Menu for "Builder link" items, for restricting available datasources in Web Builder to those specified in the Web Menu item..
1237Framework ServerWeb PortalWeb Portal: you can now drag & drop a file in a shared folder. This feature is available only for configured authorized file types.
1250Framework ServerWeb PortalWeb Portal: improvements in the Security Administration page. You can now do a search on the name of users, user groups, properties or menus.
1249Framework ServerWeb PortalWeb Portal: improvements in the Tasks pages. Now you can see the comment of a task without opening it.

Major Hotfix(es)

IDProductComponentDescription
1256Framework ServerSecureAdministration Manager: it is not possible to rename a user group with a name that is longer than 50 characters. This problem has been fixed.
1254Framework ServerPivot TableBad interpretation of dates in Pivot Tables: there is a time difference due to the time zone. This problem has been fixed.
1239Framework ServerWeb PortalError when starting the Web Portal: "The trust relationship between the primary domain and the trusted domain failed". This problem has been fixed.
1238Framework ServerCnD Data Access DriverError when starting Administration Manager after restoring the database security: "The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element". This problem has been fixed.
1240Framework ServerCnD Data Access DriverThe Click and DECiDE Access Driver service fails when starting after a reboot of the CnD server. This problem has been fixed.
1243BAI ServerOtherWeb Builder: Running a query which does not return any row generates an exception (Invalid pointer). This problem has been fixed.
1244Framework ServerMenuWeb Menu: it is not possible to enable an Excel output format for a shared folder item. This problem has been fixed.
1245Framework DesktopBAI EngineExport to Excel XLSX: the result file may be corrupted. This problem has been fixed.
1246BAI ServerOtherWeb Builder : it is not possible to configure OData properties for a query (they are read-only). This problem has been fixed.
1235Framework DesktopBAI EngineConversion functions Milliseconds2DateTime() and Seconds2DateTime() do not work correctly. This problem has been fixed.
1247Framework ServerModelModel parameters are not fully supported: error when defining a model parameter having different values depending on the model (violation of UNIQUE constraint). This problem has been fixed.

Minor Hotfix(es)

IDProductComponentDescription
1236Framework ServerWeb PortalWeb Portal, Web Menu page: it is not possible to select the root folder when browsing for the path of a shared folder. This problem has been fixed.
1242BAI DesktopOtherMySQL / MyODBC V8: The table list does not appear in Builder. This problem has been fixed.
1251Framework ServerWeb PortalRenaming a menu alias does not update export tasks using this menu alias (for exported item or export destination). This problem has been fixed.
1255Framework DesktopBAI EngineReport Alerts of type "Run Click and DECiDE Item" do not work with default configuration (Click and DECiDE services are running under the Local System profile). This problem has been fixed.

Click&DECiDE® BAI Version 19.0.0 - February 20th, 2019

Enhancement(s)

IDProductComponentDescription
1077Framework ServerWeb PortalWeb Portal : you can now define in the section "Fail Management" a mail or an alert to be send if the task fails. You can also define if the task is critical: in this case, next tasks in the scheduled task are not executed.
1089Framework ServerWeb PortalGQL: another Java version greater than 1.7.0.15 can now be used by modifying the JvmVersion=1.7.0_15 flag in the [GENERAL] section in the C:\ProgramData\Click and DECiDE\BAI\CnD.DVWeb.Google.Visualization.DataSource.Query.ini file.
1101BAI DesktopBuilderSQL Server Data Source: the SQL Server 2016 Client is now supported.
1102Framework ServerWeb PortalScheduled Tasks in the Web Portal: it is now possible to "Run with highest privileges", useful when UAC is enabled in a Server.
1113Framework Desktop>BAI EngineBuilder: a new invariant numeric format is now available (no thousand separator, and dot is decimal separator). This format is not dependent on the regional settings of the server. In addition, a new output format "CSV (Invariant)" using this new format is now available.
1119Framework ServerWeb PortalThe Web Portal now supports Cross-Domain HTTP Queries. You can configure the allowed origins in the C:\ProgramData\Click and DECiDE\BAI\web_settings file, property QueryAshxEnabledForDomains (separator is "," and you can use wildcards "*" and "?").
1156Framework ServerPivot TableExpand rendering options for Pivot Tables.
1159Framework ServerPivot TableExport the result of a pivot table in an Excel spreadsheet is now possible.
1179Framework ServerMenuWeb Menu: it is now possible to configure a target for URL items (open in current frame, new or top window).
1184Framework ServerWeb PortalThe Web Portal now requires IE11 without any compatibility settings (IE9 is no more supported).
1185Framework DesktopBuilderIn a Builder query, the name of a table can now be parametrized with BAI parameters.
1187Framework DesktopBuilderIn Builder, you can now customize a column header with a formula and BAI parameters.
1200Framework ServerWeb PortalWeb Portal: URL files (.url) are now supported in shared folders.
1201Framework ServerWeb PortalWeb Portal: improvements in the pagination of grid views. The number of rows is now automatically adjusted to the size of the windows browser.
1202Framework ServerWeb PortalWeb Portal: improvements in the tasks and scheduled tasks pages. Now you can do a search on the name of tasks / scheduled tasks. In addition, you can see the owner and other detailed information on a task / scheduled task without opening it.
1204Framework ServerSecureThe list of the groups authorized to access a given datasource can now be consulted in Administration Manager.
1214BAI DesktopOtherddisql32: SQL Server V14 client (msodbcsql17.dll) is now supported.
1219Framework DesktopBAI EngineAudit BAI : audit tables can now be correctly joined (fields ws_connectid and ws_itemid).
1220Framework ServerWeb PortalImprovements in performances for queries execution in the Web Portal for Self Service Data.
1221Framework DesktopBuilderThe behavior of Builder has changed depending on the installed license: when opening a Web Builder file (.vvv), a temporary license license is downloaded from the CnD server, except if the client has already a non temporary license. In addition, it is not possible to start Builder if the installed license is temporary.
1223Framework ServerMenuWeb Menu: it is now possible to configure a URL menu item as a link to Self Service Dashboard. This allows an integrator to distribute the same dashboard to multiple customers.
1224Framework ServerWeb PortalAdministration Manager (only for users, groups, properties and menus configuration) and Web Menu are now available in the Web Portal. This feature is available for administrators users, and it can be disabled.
1225Framework ServerMenuWeb Menu, the option "Show IDs" in the menu View is now memorized for a user.
1226Framework ServerSecureSecurity administration audit: all changes in security administration (from the Web Portal or the server) are now logged in the database via the LEO service.
1228BAI DesktopOtherThe Google BigQuery data source now returns all tables when a dataset contains more than 50 tables.
1233Framework ServerWeb PortalA task can now be run directly in the Web Portal, without creating a scheduled task (for test purpose).

Major Hotfix(es)

IDProductComponentDescription
1085BAI DesktopOtherBuilder was not working with Sybase Adaptive Server Enterprise (ASE) ODBC driver (V15.7, V16). This problem has been fixed.
1107BAI ServerOtherSaving a project containing OData queries in a shared folder may fail if the data sources cannot be reached. This problem has been fixed.
1110Framework ServerWeb PortalWhen hiding the first column for a parameter, and if that parameter was mandatory, then that parameter was not anymore mandatory through the Web Portal. This problem has been fixed.
1111Framework DesktopBAI EngineLoading a project has become slow or impossible if the data source associated with a query does not exist anymore. This problem has been fixed.
1112Framework ServerBAI ServerWhen multiple queries are run "simultaneously", the export may fail. This problem has been fixed.
1114Framework DesktopBAI EngineThe smalldatetime data type was not handled correctly by the SQL Server data source. This problem has been fixed.
1135BAI DesktopOtherThe "Click and DECiDE Queries" datasource does not work in BAI Desktop edition. The problem has been fixed.
1140BAI ServerOtherA "secured" Click and DECiDE Queries Source may not work in CnD authentication (and in Windows auth also; through a Connect data source). The problem has been fixed.
1173Framework DesktopBAI EngineThe SQL function NumYYYYMMDDtoDate() is not compatible with SQL Server 2005. The problem has been fixed.
1186BAI DesktopOtherThe ADO and OLEDB data sources return incorrect numbers when the decimal point defined in the regional settings is not '.' (e.g.: ';'). The problem has been fixed.
1190BAI DesktopOtherWeb Services error when adding a "table": Unknown error 0x80131500;System.NotSupportedExceptionDataSet does not support System.Nullable<>. The problem has been fixed.
1192BAI ServerOtherError is returned when connecting to a secure data source: Error code : 0x80020009; Exception occurred.; Error code : 0x80020009; Exception occurred.; using WaitForSingleObject(); Can't lock mutex; ret = 258; GetLastError = 0; Delay = 45000 - - -. The problem has been fixed.
1194Framework ServerSecureRestore a backup of the Security Database version 13 : the flag NTAuthReq from the aliases.ini config file is lost, resulting in a connection error. The problem has been fixed.
1195Framework ServerSecureRestore a Backup Security Database does not work correctly when the SQL Server instance of the target server is different from the backuped configuration. The problem has been fixed.
1198Framework ServerWeb PortalWeb Portal Scheduled Tasks: a very long password is not always correctly unencrypted at execution. The problem has been fixed.
1209Framework ServerGChartSimple quote character are now supported in List Control.
1210BAI DesktopOtheriSeries: row_number() does not work correctly with the source 'AS/400 TCP/IP' (the BIGINT datatype is not correctly handled). The problem has been fixed.
1213BAI ServerOtherJoins are not handled properly on secured CnD Queries data sources: UN-authorized access or invalid object path(s). The problem has been fixed.
1217BAI ServerOtherSecured data sources - "select ... from (select .. from ...) a" returns an error: incomplete path [a]. The problem has been fixed.
1234Framework ServerWeb PortalWeb Portal Scheduled Tasks: destination of an export task is not correctly saved when the web menu contains several shared folders with the same name.

Minor Hotfix(es)

IDProductComponentDescription
1160BAI DesktopOtherThe MINUS SQL keyword is replaced by EXCEPT by 'd7SQLDLL' for DB2 native data sources ONLY. The problem has been fixed.
1169BAI DesktopOtherClick and DECiDE data source: projects which name has a space before the .WFV extension are not correctly handled. the problem has been fixed.
1171Framework ServerSecureIn Administration Manager, users and groups are no longer sorted in the left tree since the 64-bit version of BAI. The problem has been fixed. The problem has been fixed.
1180BAI DesktopOtherThe SQL Server data source returns inconsistent length for decimal fields. The problem has been fixed.
1181Framework ServerWeb PortalWhen creating/editing a scheduled task, an horizontal scrollbar is missing in the list of tasks (when a taskname is too long). The problem has been fixed.
1188Framework DesktopBAI EngineExport to Excel XLSX: the write mode REPLACE erases the existing style of the cells. The problem has been fixed.
1191BAI DesktopOtherWeb Services error when connecting: Compiler executable file C:\Windows\Microsoft.NET\Framework64\v3.5\csc.exe cannot be found. The problem has been fixed.
1203Framework DesktopBuilderBuilder: the automatic creation of a parameter when adding a criteria on a formula or a column does not work correctly when the column name contains accented or special characters. The problem has been fixed.
1205BAI ServerOtherOther Native SQL Queries are not logged in the netreport ws_run_query table. The problem has been fixed.
1206BAI ServerOtherThe CurrentWebUser() CnD function does not work in reports. The problem has been partially fixed for PDF export (not supported in subreports).
1208BAI DesktopOtherThe SQL Server data source does not handle the 'MONEY' data type properly. The problem has been fixed.
1215Framework ServerWeb PortalForm authentication does not not work on HTTPS. The problem has been fixed.
1222Framework ServerWeb PortalIn the Web Portal, when we browse a Group Shared Folder, all folders for each user group are displayed, even if the folder does not exist. The problem has been fixed (only existing folders are displayed).
1229Framework DesktopBAI EngineBigquery: an error is shown when no row is returned by a query: Object reference not set to an instance of an object. The problem has been fixed.
1231Framework DesktopBAI EngineThe SQL Server (ddisql32.dll) Data Source crashes when a field of type float contains too big values (around 1E127/128). The problem has been fixed.
1232Framework DesktopBAI EngineTime type is not correctly handled is the Google Data Table output format. The problem has been fixed.

Click&DECiDE® BAI Version 16.0.3 - March 30th, 2017

Enhancement(s)

IDProductComponentDescription
1147Framework ServerWeb PortalThe way to read the Menus list and their content has been improved to reduce the access time to that list and also the time to make a Save As for a Builder project to a Menu Shared Folder.
1148Framework DesktopBuilderNew conversion functionalities on a numeric field YYYYWW to datetime and on date field to day, month, year, etc.

Major Hotfix(es)

IDProductComponentDescription
1141BAI ServerOtherAn error is sometimes returned in the portal: using WaitForSingleObject, Can't lock mutex; ret = 258. This problem has been fixed modifying the Click&DECiDE simpldbX.dll.
1142InstallationBAI WebServerSome output formats such as Cube, HTML, Google Data Table etc. could generate a blank page in the Web Portal after a migration from V16.0.1 to V16.0.2 (Wrong web.config). This problem has been fixed.
1143Framework ServerNRFilter EngineAlerts did not work when creating file to any Builder output format other than PDF. This problem has been fixed.
1144Framework ServerModelModel displays an error message when trying to apply a parameter value to a user. This problem has been fixed.

Minor Hotfix(es)

IDProductComponentDescription
1146Framework ServerTasksA task creating sub-directories with the iterate option was creating several directories if the name of the value to be used was containing a single quote or other special character. This problem has been fixed.

Click&DECiDE® BAI Version 16.0.2 - Februrary 16th, 2017

Enhancement(s)

IDProductComponentDescription
1121Framework DesktopOtherAS400 iSeries concat operator is not always a double-pipe character ||, depending on the chosen conversion table, it may be !! instead of ||. This is the case for ebcdic 500 (and 297 and may be other). The Builder Engine will now make the change automatically.
1132Framework DesktopOtherNew AS400 iSeries function JulianToDateDDMMYYYY(§X): Convert a date field from JULIAN format CYYNNN to a Date format DDMMYYYY. (C = Century 0,1,2 etc., YY = year in 2 digits, NNN = number of the day in the year 1 to 366).
1133Framework DesktopOtherNew AS400 iSeries function NumYYYYWWtoDate(§X): Change a numeric field YYYYNN into a date field, giving the date of the first day of the concerned week number NN (1 to 53, ISO-8601 First day of the week is Monday).
1124Framework DesktopBuilderTwo new internal Click&DECiDE functions are now available: CumulN(§X) and CumulN(§X,§Y) taking car about the NULL values instead of sending zero when NULL. Nice when feeding a chart to avoid lines going down to the zero scale.
1125Framework DesktopBuilderNew native Click&DECiDE function Host('NULL') that allows now a conditional formula to return a NULL value or another value instead of always a NULL value. Can be used with any datasource, such as SQL Server.
1126Framework DesktopBuilderTwo new internal Click&DECiDE functions are now available: CountStr(§String,§Searched) and CountStr(§String,§Searched,§IgnoreCase) allowing to search a text inside a character field, with or without the case sensitive option.
1137Framework ServerOtherCancelling a Pivot Data Table or Google Data Table export was quite slow with a big volume of data. This has been improved.

Major Hotfix(es)

IDProductComponentDescription
1117Framework DesktopBuilderWhen making a join and at the same time changing the sort on the column list in the Builder Table Tab for a query, the join list could be wrong. This problem has been fixed.
1123Framework DesktopBuilderIn an objet report properties, it was not possible anymore to enter a decimal separator in the boxes for the size, height or width. This problem has been fixed.
1127InstallationBAI-WebServerInstallation won't launch when system language was different from English or French. These problems have been fixed.
1129Framework DesktopBuilderBuilder crashes when deleting a query in a project file, then trying to edit the OData properties. This problem has been fixed.

Minor Hotfix(es)

IDProductComponentDescription
1108Framework DesktopBuilderThe default destination from Builder to Excel XLSX was not anymore "My Documents" when undefined for this Output format. This problem has been fixed.
1109Framework ServerWeb PortalUnder the Edge browser in the Web Portal, the automatic refresh of the Scheduled Tasks page was not working. This problem has been fixed.
1118Framework DesktopBuilderWhen editing the join type then leaving this box with OK or Cancel, the focus was lost sometimes. This problem has been fixed.
1120BAI DesktopOtherThe Oracle JDEDate function (specified in the fctora*.fn files) was not working with ODBC but only with native Oracle data source. This problem has been fixed.
1122Framework DesktopBuilderNULL value in Google Data Table output format was giving value zero. Now will return NULL. This problem has been fixed.
1128Framework DesktopBuilderWhen copying a formula in the SQL Editor, then comming back to the Query Worksheet, the mouse cursor was still busy. This problem has been fixed.
1131Framework ServerWeb PortalWhen removing the "preview" output format for a query in the Web Portal, the old HTML output format was still displayed. This problem has been fixed.
1134Framework ServerWeb PortalIn some cases, when an error occurs, the Web Portal generates an HTML page instead of the appropriate output format (often encountered when using the Google Data Table output format in Google Dashboards). This problem has been fixed.
1138BAI ServerOtherThe XML Big Data output format could crash when exporting a report. This problem has been fixed.
1139BAI DesktopOtherBuilder was crashing when opening a project whose name was containing a single quote ('). This problem has been fixed.

Click&DECiDE® BAI Version 16.0.1 - October 19th, 2016

Enhancement(s)

IDProductComponentDescription
1087BAI DesktopOthersSAP Data Source: a cache has been added for the Query Group List (SQ01) to avoid long response when the program needs it.

Major Hotfix(es)

IDProductComponentDescription
1090InstallationBAI-WebServerWhen migrating from V15 to V16, two DLLs with a wrong fleg version were not installed correctly, giving sometimes and specially under Windows 2012 the error "Cannot retrieve parameter list (Invalid pointer)" in the Web Portal when retreiving the query parameters list. This problem has been fixed.
1091Framework DesktopBuilderWith the new "Click&DECiDE Queries" data source, an error occurred when making any new virtual field using the existing column. This problem has been fixed.
1093Framework ServerAdmin ManagerA backup or Restore made with Administration Manager V16.0.0 were not taking care about the new data sources INFOR M3 or Click and DECiDE Queries (multi data sources). This problem has been fixed.
1095Framework DesktopBuilderWhen making a Copy and Paste of an item in a Builder project file, no star appears near the project name and no message asks if the user want to save when closing the project file. This problem has been fixed.
1096Framework ServerWeb PortalWhen removing a connected user through the Web Portal in the Connected User branch, it was not working. This problem has been fixed.
1105Framework ServerWeb PortalAn error message is displayed when browsing a query or report located inside a project being in a Shared folder by Group or User Group. This problem has been fixed.

Minor Hotfix(es)

IDProductComponentDescription
1086BAI DesktopOtheriSeries Data Source: sometimes, after a migration, the EBCDIC to ANSI conversion table list was not displayed anymore (file.E2A), due to a wrong path in the DDIIP4.INI file. This problem has been fixed.
1092Framework ServerGoogle ChartsAn error occurred with a Pivot Table or a Google Chart if numeric values to be displayed where lower than 1, such as 0.125 for example. Other error occurred if the column names are between double quotes. These two problems have been fixed.
1099Framework ServerPivot TablesThe Pivot Table were not working if the client was not connected to the Internet. These problem have been fixed.

Critical Hotfix(es)

IDProductComponentDescription
1094BAI ServerOtherA certificate verification may hang. This problem has been fixed.
1106BAI ServerOtherCrash in d7vnrtEX.exe when exporting to the 'Tabular Data Cache Update' output format in a Scheduled Task. This problem has been fixed.

Click&DECiDE® BAI Version 16.0.0 - September 1st, 2016

Major Enhancement(s)

IDProductComponentDescription
1059Framework ServerBAI EngineNew Data Source "Click&DECiDE Queries" allowing to make joins between several queries from different data sources! For example you can join a query made against an iSeries with another query made against SQL Server and another one made against an Excel sheet! This new data source manages a Cache system and other parameters to update automatically your data warehouse.
1060Framework ServerBAI EngineNew INFOR M3 Data Source based on the M3 API. Click&DECiDE can access to all M3MI programs and transactions such as MDBREADMI. Reports, Dashboards and Pivot Tables can be integrated directly in the INFOR Smart Office.
1061Framework ServerBAI EngineNew OData protocol (Data Exchange via URL). Click&DECiDE provides now OData support for Excel, PowerBI, PowerView, QlikView, Qlik Sense etc.
1063InstallationSetupThe Setup program has been totally remade. Now, a unique User Interface installs all prerequisites. The installation process has been simplified. Additional install options, such as the location directory, can be set by clicking the (optional) Options button. It is no longer possible to modify the service profiles in the installation but that can be done using a new tool after installation. It is no longer possible to select which feature will be installed: that can be done running the msi file, all pre-requisites being already installed.

Enhancement(s)

IDProductComponentDescription
1070Framework ServerWeb PortalA new responsive output format named "Preview" now replaces the HTML format for queries and can be also use in a Shared Folder. The size of the result will be adapted to the browser windows width. You can select this new output format in Menu Builder for any branch or shared folder.
1027Framework DesktopBuilderIn the Query Table Tab you can now manage customized native joins without losing the query worksheet,(only the join can be in native SQL).
1062SetupConfigurationA new tool allows now to manage the Services profiles after the installation, modify the DCOM rights and IIS identity, useful when needing to access to remote locations through the Web Portal. This command, named CnD.Configuration.SvcProfileWizard, is available in the Startup menu under the Administration sub menu next to the configuration Wizard.
1064InstallationBAI WebServerThe .NET Framework 4.5.1 is required to run the installation. In previous installation it was not done automatically. Now, it can be done during the prerequisite phase of the installation if missing.
1065InstallationBAI WebServerThe "Setup Files" folder is used to extract the files required for the installation. Now, this folder will get a name depending on the installed version. That will avoid problem when installing a new release or version.
1067Framework ServerPivot TableThe Pivot Tables, if more than one dimension is defined, show the sub-totals of the first dimension, by column and/or by row. An option allows to hide the total (and sub-total) by columns or by rows. These sub-totals rows or column can be used with the comparison fields.
1068Framework DesktopBuilderA new predefined date format is now proposed inside Builder for a date field: "Date,ISO" giving the YYYY-MM-DDThh:mm:ss format.

Restriction(s)

IDProductComponentDescription
1084Framework ServerBAI EngineThe "Google Doc" Alert has been removed from Builder and Task Post-Treatment because Goggle has changed their authentication process.

Critical Hotfix(es)

IDProductComponentDescription
1080BAI ServerOtherA multi-threading problem has been fixed concerning a Click&DECiDE Service (sechlpsx).
1081BAI ServerOtherA memory problem has been fixed concerning a Click&DECiDE Export Service (d7vemservice).

Major Hotfix(es)

IDProductComponentDescription
1046Framework DesktopBuilderIt was not possible to modify manually the SQL Editor in a query having one or several UNION(s). This problem has been fixed.
1051Framework DesktopBAI EngineWhen exporting to ASCII XML, the datetime format specified for a column was not applied to the destination file. This problem has been fixed.
1058Framework DesktopBuilderAn error could occur when editing a virtual field in the UNION tab in a query having one or several UNION(s). This problem has been fixed.
1074Framework DesktopBuilderSometimes Builder can be closed without saving the a modified query. This problem has been fixed.
1076Framework DesktopBuilderSometimes it was not possible to retreive a Builder project file after a crash. This problem has been fixed.
1076Framework DesktopBuilderSometimes it was not possible to retreive a Builder project file after a crash. This problem has been fixed.
1082BAI DesktopOtherThe criteria dialog box management has been improved to avoid memory corrupted or GPF.
1083BAI DesktopOtherThe JoinX OCX management has been improved to avoid memory corrupted or GPF.

Minor Hotfix(es)

IDProductComponentDescription
1066Framework ServerPivot TableWhen using the button allowing to display the measures in rows or columns, then the list of the translated measures types such as Sum, Integer Sum, Count, Count Distinct etc. was changing to native values such as Sum, IntegerSum, Count, CountUnique etc. This problem has been fixed.
1073Framework ServerGoogle ChartWhen renaming a chart, it was not possible anymore to validate the chart properties using the Google interface. This problem has been fixed.

Click&DECiDE® BAI Version 15.2.1 - March 16th, 2016

Major Enhancement(s)

IDProductComponentDescription
1019Framework ServerWeb PortalThe Google Charts download now a specific version of the objects and charts giving thus a best stability, not depending anymore of any Google modification.
1032Framework ServerWeb PortalYou can now add several measures in a Web Portal Pivot Table. If using a Group function such as SUM, MIN, MAX etc. it will apply to all measures. You also can display these measures by row or by column.
1033Framework ServerWeb PortalYou can now add some comparison fields in a Web Pivot Table, and select among Difference (value), Integer Difference (value) or Percent. A comparison field can be created for each measure.
877Framework DesktopBuilderThe current maximum size for a SQL statement was 32000 bytes and has been increased to 320000 bytes. A quite long query (~40KB) submitted to the iSeries server was returning an error "Statement text is too long".

Enhancement(s)

IDProductComponentDescription
1018Framework ServerWeb PortalA Calendar Shared Folder manages now several different file names for a same date in the same directory.
1015Framework ServerWeb PortalA Calendar Shared Folder in the Web Portal manages now sub-directory levels.
1024Framework ServerWeb PortalThe GridPageSize = 20 in the C:\ProgramData\Click and DECiDE\BAI\web_settings.config file now also applies the number of rows in the Web Portal for Tasks and Scheduled Tasks List.
1035Framework ServerWeb PortalWhen running a task via a shortcut, a favorite or an URL inside a Menu, you can get a warning message using RunSchedule.aspx to confirm this action, or no message using RunSchedule.ashx.
1036Framework ServerMenu BuilderThe way to select output formats has been improved, displaying now visible checkboxes instead of blank list.
1038Framework ServerWeb PortalThe list-box width for a parameter through the Web Portal increases now automatically if the content is greater than the default width.
1039Framework DesktopBuilderWhen a new parameter name was containing a space, an accent or other forbidden characters, a message was displaying to not use such characters. Now, the program replaces these characters with their Unicode code. Example: a space is replaced with _x0020_.
1040Framework ServerAdmin ManagerThe speed to start Administration Manager has been improved.
1047Framework ServerWeb PortalThe ATOM output format is now available through the Web Portal. That allow to schedule a task to refresh the Power Pivot Data for Excel.
1053Framework DesktopBAI EngineThe ODBC Oracle data source retreives now the descriptions from tables, views and columns.

Major Hotfix(es)

IDProductComponentDescription
1009Framework ServerWeb PortalUnder Click&DECiDE Authentication, some process could be slow due to database connections and disconnections under specific conditions, giving a slower response time. This problem has been improved.
1010Framework DesktopBuilderExporting a native SQL query to a database was not working. This problem has been fixed.
1012Framework ServerWeb PortalExporting a native SQL query to a database through a scheduled task was not working. This problem has been fixed.
1014Framework DesktopBuilderAfter a Desktop installation only, Builder keeps on asking a login when browsing tables or running queries or report. This problem has been fixed.
984Framework ServerWeb PortalA Report based on a cube rawdata with Builder 32-bit version 13.1 was not working through the Web Portal version 15.1. This problem has been fixed.
1023Framework DesktopBuilderA Report containing a sub-report could sometimes never finish if the sub-report was requiring several pages (loop). This problem has been fixed.
1021Framework ServerWeb PortalA RSS Alert type in a scheduled task using an iteration on a parameter was giving a wrong =Hyperlink(). The #PARAM_ITERATE# was not replaced with the parameter value. This problem has been fixed.
1028Framework ServerWeb PortalEditing an Excel Model file inside Menu Builder for XLS or XLSX output format was displaying some strange characters and finally was displaying the message "Server busy". This problem has been fixed.
1029Framework ServerWeb PortalWhen exporting data through the Web Portal, if a parameter was displaying values containing a '+' character, this one was replaced by a space, giving no result. This problem has been fixed.
1007Framework DesktopCubeWrong translation between a parameter criteria and a Microsoft Cube filter under Builder 13.1 or Web Portal 15.1 when the searched value was containing for example a single quote. This problem has been fixed.
1041Framework ServerWeb PortalAn error occurred when importing a task exporting an item from a shared folder (Error : Object reference not set to an instance of an object). This problem has been fixed.
1044Framework ServerWeb PortalA 32-bit cube created by a task inside a Shared Folder was not accessible through the Web Portal. The file with ".cndc" extension was not visible. This problem has been fixed.
1048Framework DesktopBAI EngineThe ATOM output format was not always compliant with Excel Power Pivot 2013. The dots in the column name are not supported by Excel and are now replaced with a "_" in the ATOM file. This problem has been fixed.

Minor Hotfix(es)

IDProductComponentDescription
1011Framework ServerWeb PortalThe message when a User was connecting since 2 different IP addresses was confusing under Click&DECiDE Authentication. (It was correct under Windows Authentication). This problem has been fixed.
1020Framework ServerWeb PortalA RSS Alert type in a scheduled task was not retreiving the correct protocol in the field initialized to =Hyperlink() if the protocol was different than http (https). This problem has been fixed.
1000Framework DesktopBuilderAn error occurred when openning a Project.wfv file from a non-Italian Web Portal using an Italian Builder Client 32-bit Version 13.1. This problem has been fixed.
986Framework DesktopBuilderThe "Excel Big Data" output format fails if a string contains a control character (ascii / Unicode code lower than 32). This problem has been fixed.
987Framework DesktopBuilderThe "XML" output format fails if a string contains a control character (ascii / Unicode code lower than 32). This problem has been fixed.
1025Framework DesktopBuilderIn the Joins/Relations floating Dialog box, editing the join type was giving en error message. "Query Error: The join number is incorrect". This problem has been fixed.
1026Framework ServerWeb PortalThe "HTML" output format fails if a string contains a control character (ascii / Unicode code lower than 32). This problem has been fixed.
1030Framework ServerAdmin ManagerRestauring a Click&DECiDE Version 13 Backup was not erasing the existing configuration. This problem has been fixed.
1031Framework ServerAdmin ManagerThe "Update Security" process could sometimes take a long time to complete. This problem has been fixed.
1034Framework ServerWeb PortalIt was not possible to select the current day in a Web Portal Calendar without selecting first another date or having a default value in the corresponding Date Parameter. This problem has been fixed.
1043Framework DesktopBAI EngineSQL Server "output format" may crash with SQL Server 2014 client with the Bulk Copy option enabled. This problem has been fixed.

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

Major Enhancement(s)

IDProductComponentDescription
001Framework ServerWeb PortalThe 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.
995Framework ServerWeb PortalThrough 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".
996Framework ServerWeb PortalA 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)

IDProductComponentDescription
002Framework ServerDashboardsWhen 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.
003Framework ServerMenu BuilderWhen 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.
004Framework DesktopBuilderSome 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.
962Framework Server and DesktopServices and RuntimeSome Click&DECiDE Services and Runtime programs (such as the d7vnrt.exe) have been improved to get best performances and stability.
998Framework ServerWeb PortalThe Web Portal can now include a special page to display inernal Support information from the Company to the end-users.
1003Framework ServerBuilderThe limit size of 16 Kb for any Builder function file (*.fn) has been increased to accept bigest files.
1006Framework ServerData SourceThe ODBC data source does not return columns and tables comments (REMARKS) Now it is possible to modify the DDIODBC.INI file to add an SQL Query that will retreive the table list and column listand their comments. Each [ODBC Data Source] can have a specifif SQL Query in the DDIODBC.INI file.

Major Hotfix(es)

IDProductComponentDescription
981SetupWeb PortalWhen 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.
983SetupWeb PortalIn 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.
990Framework DesktopBuilderThe Excel XLSX output format had memory leaks when writing several times to the same Excel file using the REPLACE mode. This problem has been fixed.
984Framework ServerWeb PortalA 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.
1002Framework ServerBuilderA 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.
1004Framework DesktopBuilderA 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)

IDProductComponentDescription
997Framework DesktopBuilderPaste of XML native Query in Builder leads to protection fault. This problem has been fixed.

Critical Hotfix(es)

IDProductComponentDescription
908Framework DesktopBuilderA 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.
991Framework DesktopBuilderAll the output formats have been modidied to avoid memory corruption. This problem has been fixed.
1005Framework ServerWeb PortalA Menu name igual to a shared folder name in this menu was giving a wrong path in a task. This problem has been fixed.

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

Major Enhancement(s)

IDProductComponentDescription
001Framework ServerWeb PortalThe 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.
002Framework DesktopBuilderA 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.
003Framework DesktopBuilderA 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)

IDProductComponentDescription
944Framework ServerDatabaseiSeries Data Source: Query/400: the INNER JOIN statement is now managed.
967Framework ServerWeb PortalWhen sending an e-mail from a Task, the main text area allows now to enter several rows.
992Framework DesktopExcel DDEThe Excel DDE Output format was limited to the number of rows/columns of Excel 5 to Excel 2003 (.XLS). Now the limits are the one of Excel 2007 to Excel 2013 (*.XLSX).

Major Hotfix(es)

IDProductComponentDescription
941Framework ServerDatabaseThe 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.
966Framework ServerWeb PortalThe =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.
968Framework DesktopBuilderWhen 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.
974Framework ServerWeb PortalIn 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)

IDProductComponentDescription
969Framework DesktopBuilderWhen 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.
971Framework ServerWeb PortalExporting to Excel through a task with a destination cell equal to or greater than row 10 was not working. This problem has been fixed.
932Framework ServerWeb PortalA 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)

IDProductComponentDescription
001All ProductsVersion 64-bitThis is the first version full-64 bit of Click&DECiDE
002Framework ServerDashboardThe 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.
003Framework ServerData SourceNew 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.
004Framework ServerAdministration ManagerOn 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.
925Framework ServerBuilderClick&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)

IDProductComponentDescription
948Framework ServerDatabaseiSeries Data Source: new function to calculate a Date field from 3 distinct numeric fields Year (4 digits), Month (2 digits) and Day (2 digits).
936Framework ServerWeb PortalWhen exporting to HTML, the "Export to File" button is now greyed, as not available for multi-files output formats.
935Framework ServerWeb PortalThe "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.
934Framework ServerDatabaseiSeries 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).
929Framework ServerDatabaseDB2-UDB Data Source: now the GRAPHIC, VARGRAPHIC and LONG VARGRAPHIC field types with Unicode characters are supported in a query.
923Framework DesktopBAI EngineWhen 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.
922Framework DesktopBuilderThe copy and paste function from the Builder Data Grid to Excel takes care now to the numeric decimal separator and date formats.
827Framework DesktopBuilderBuilder 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)

IDProductComponentDescription
100Framework Desktop and ServerEBIS DashboardsEBIS 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.
101Framework Desktop and ServerMicrosoft CubesMicrosoft 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.
102Framework ServerTasks and VBScriptWhen 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

IDProductComponentDescription
963Framework DesktopBuilderA 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.
963Framework DesktopBuilderA 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.
961Framework ServerDatabaseiSeries 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).
948Framework ServerDatabaseiSeries 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).
934Framework ServerDatabaseiSeries 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).
929Framework ServerDatabaseDB2-UDB Data Source: now the GRAPHIC, VARGRAPHIC and LONG VARGRAPHIC field types with Unicode characters are supported in a query.
923Framework DesktopBAI EngineWhen 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.
922Framework DesktopBuilderThe copy and paste function from the Builder Data Grid to Excel takes care now to the numeric decimal separator and date formats.
952Framework DesktopBuilderWhen sending a cube to Excel Pivot Table, sub-totals are not displayed in Excel if not enabled in the cube.
437Framework DesktopBuilderYou 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).
249Framework ServeriSeriesThe 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.
899Framework ServerDashboardSeveral 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.
901Framework ServerDashboardA 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.
890Framework ServerWeb PortalThe 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.
885ConfigurationWizardThe 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.