Click&DECiDE® ReadMe

The Versatile BI Solution.

Click&DECiDE® BAI Version 13.0.4 - Monday, March 24, 2014

Enhancement(s)

IDProductComponentDescription
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. The filters are using the data already in memory instaed of running a separate query, improving the performances.
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.

Major Hotfix(es)

IDProductComponentDescription
874Framework ServerWeb PortalIt was not possible anymore to schedule a task running a cube asking only for the ".cub" file. This problem has been fixed.
882Framework ServerWeb PortalIf a cube or query has a parameter whose default value is updated by the value of another parameter, then the parameters were not displayed through the Web Portal. A Report Book containing such reports was displaying wrong values for the parameters. This problem has been fixed.
883Framework ServerWeb PortalThe Task Migration, if using Click&DECiDE Authentication, was not correct. It was necessary to resave again each task as a workaround. This problem has been fixed.
887Framework ServerWeb PortalAn error could occur when exporting a cube to "Pivot Excel 2007" from the Web Portal, depending on the cube default title, even if not displayed in the cube. The temporary directory in web/publication/temp was removed. The workaround consists of changing this Title.
889Framework DesktopAutomationThe program CnDSampleAutomation.exe was not up to date about the Excel output format syntax and the parameters management. This problem has been fixed.
893Framework ServerWeb PortalThe shortcut to run a Scheduled Task that you can paste in a Menu was not working if it was too long. Now it can include up to 30 parameters. This problem has been fixed but such URL with parameters cannot work under Windows Server XP or Windows Server 2003.
895Framework DesktopBuilderThe Export Data icon was not available from a Cube Analysis Services from Builder. This problem has been fixed.
896Framework ServerWeb PortalA Cube Analysis Services was not recognized through the Web Portal as being a Cube (No cube icon, No Excel 2007 Pivot Table output format and HTML output not working). This problem has been fixed.
905Framework ServerWeb PortalAn error occurred when opening a task running a Native SQL Query. It was possible to create and run this task but not to edit it. This problem has been fixed.

Minor Hotfix(es)

IDProductComponentDescription
910Framework DesktopBuilderUnder Oracle data source, a criteria on a TimeStamp was giving an error ORA-01830. This problem has been fixed.
909Framework ServerWeb PortalA VBScript generated in the Task Screen Designer was not including all required information: opening the project and selecgting the item to be exported. This problem has been fixed.
906Framework ServerWeb PortalAn hyperlink above a picture in a report was displaying a cross above this picture in the result in HTML, even if the Hyperlink was working fine. This problem has been fixed.
902Framework ServerWeb PortalA cube whose name contains a dot gives an error through the Web Portal. The error is "All pages exported!". This problem will not be fixed, the solution consists of removing the dot in the cube name or menu branch name for this cube.
888Framework ServerWeb PortalThe HTML Cube under IE was giving an error if any character with accent was used in the Cube Name in the Web Menu. This problem has been fixed.
886Framework DesktopBuilderA display problem occurred in the Builder Data Grid with more than 64000 rows. This problem has been fixed.

Critial Hotfix(es)

IDProductComponentDescription
898Framework DesktopBuilderA GPF occurred when printing directly to PDF a Cube Analysis Services from Builder without first opening the cube. This problem has been fixed.

Click&DECiDE® BAI Version 13.0.2 - November 25th, 2013

Minor Hotfix(es)

IDProductComponentDescription
873Framework ServerSetupThe installation of the WebVision.exe program (Web Builder 13.0.1) was not replacing the previous WebVision.exe file in case of upgrade above a previous version 13.0.0. This problem has been fixed.
872Framework ServerWeb PortalWhen generating a file with the "Export to File" button, the file name did not translate correctly some special characters such as "ä", "ö", "ü", "ß", "å" etc. under Internet Explorer, even if it was correct under Chrome and Firefox. This problem has been fixed.

Click&DECiDE® BAI Version 13.0.1 - November 14th, 2013

Warning

IDProductComponentDescription
000Click&DECiDEWeb BuilderSince first version 13, when you want to authorize a user to run Web Builder through the Web Portal, it cannot be installed automatically because this feature was possible only under IE but not under Chrome nor Firefox. The Administrator or the User has to install it before using it on the Web Portal. The WebVision.exe file is now located into the c:\inetpub\wwwroot\dvweb\tools directory as well as the WebVisionCube.exe, and are available through the Web Portal in the BAI Tools menu, if installed.
000Framework ServerHTML and IE8Due to the major rework of the Web Portal, the HTML output format cannot be used anymore for the Reports, Queries or Cross-tables if the browser is I.E.8. It can be used for the Cubes but the Compatibility View Mode must be disabled.
000Framework ServerExcel 2013A new feature, named "PowerView", available only in Excel 2013 can be used with this version of Click&DECiDE: see in the BAI Demonstration Menu, the "PowerPivot SaaS 2013.xlsx" item located in the Excel Integration\Power Pivot branch.

Enhancement(s)

IDProductComponentDescription
855Framework ServerMenu BuilderIt is now possible to read, through the Web Portal, static reports, queries or cubes exported to HTML in another directory than BAI\Web\Publication. Note that HTML reports and queries are exported to a file with extension .cndr, cubes to a file with extension .cndc and cross-tables to a file with extension .cndp that you can access in a Menu Branch or through a Shared Folder. Menu Builder accepts now another path than BAI\Web\Publication.
727Framework ServerScheduled TasksWhen a task creates several files with iteration on a Parameter, and when a Run condition is false, the process continues now for the next value instead of stopping the loop because of the missing data.

Critical Hotfix(es)

IDProductComponentDescription
868Framework DesktopBuilderWhen making a right mouse click on a column query to call the popup for other commands, a GPF could occurred after several actions. This problem has been fixed.
846Framework DesktopBuilderWhen making a Report preview from Builder, a GPF could occurred if Builder was closed without closing first the preview. This problem has been fixed.
856Framework ServerWeb PortalIt was not possible to include an HTML Static Report, Query, Cube or Cross-table in a Menu branch calling a file with the extension .cndr, .cndc or .cndp. It was only possible calling a file with extension .xml. This problem has been fixed.

Major Hotfix(es)

IDProductComponentDescription
864Framework ServerPowerPivot ExcelWhen a column header was containing a space, a problem occurred in Excel when using a PowerPivot URL link. Now any space will be replaced with an underscore. This problem has been fixed.
860Framework ServerWeb PortalIf a parameter had no default value in the Web Portal, an error occurred. This problem has been fixed.
851Framework DesktopBuilderThe "&" character is now forbidden in any Builder project item name or visible name for the Web Portal to avoid problems given by this character such as error 410.
852Framework DesktopOutput formatWhen saving the Output format configurator under an Administrator profile, clicking the Cancel button of the UAC dialog box could generate an error. This problem has been fixed.
853Framework DesktopData Source ConfiguratorThe Builder Data Source Configurator cannot be open if the user does not have the Administrator rights. (Builder installed in standalone). This problem has been fixed.
854Framework ServerBuilderExporting to HTML from Builder using the "Publish to Web Portal" command was not generating the required files with the same structure as the one done through a Scheduled Task. This problem has been fixed.
857Framework ServerMenu BuilderAs for the Hotfix #851, the "&" character is now forbidden in any Menu branch name to avoid problems later in URLs.
843Framework ServerWeb PortalA mandatory parameter was accepting an empty value through the Web Portal, although Builder was not accepting it. This problem has been fixed.
835Framework DesktopBuilderA formula in a report testing if a string value was NULL could get a wrong answer with a NULL numeric response. This problem has been fixed.

Minor Hotfix(es)

IDProductComponentDescription
871Framework ServerWeb PortalA task was not managing correctly a cell for Excel if lowercase character was use to define the cell, such "a1" for example, giving a corrupted Excel file. Now the letter used will be converted to uppercase character, as "A1".
862Framework DesktopBuilderWhen exporting a Cube View to Excel 2007 Roambi format, a cube file with .cub extension was also exported but no necessary. This problem has been fixed.
858Framework ServerWeb PortalWhen editing a task sending data to Excel, the existing destination Sheet Name and Cell were changed to their default values. This problem has been fixed.
859Framework ServerWeb PortalWhen editing a task sending data to Excel XLSX Big Data, the default XLSX extension was not added automatically at the run time if this extension was missing. This problem has been fixed.
836Framework DesktopBuilderWhen exporting from Builder to Excel XLSX, after a migration to version 13, the customized write mode ERASEDATA, corresponding now to ERASESHEET, was replaced with ERASEFILE, more dangerous. Now, the ERASESHEET write mode will replace the ERASEDATA write mode.
837Framework ServerScheduled TaskWhen exporting to an Excel XLS output format having ERASEDATA as write mode, a new Task was proposing REPLACE instead of ERASESHEET, as well as for any existing tasks without specified write mode. This problem has been fixed.
845Framework DesktopBuilderThe "preview" toolbar in Builder was not working as expected in Spanish, German and Italian. The navigation bar displayed buttons shifted or even not visible. This problem has been fixed.
847Framework ServerBuilderWhen installing only Builder from an Enterprise Edition, the default project open by Builder was the "Click and Decide Web Demonstration.wfv" on the Secured SQL Server, not installed. The project should be the "Click and Decide Demonstration.wfv" on the Local SQL Server data source. This problem has been fixed.
842Framework ServerGoogle ChartsThe "same size" command used with 2 selected Charts was not modifying the background color size for one of the 2 charts. This problem has been fixed.

Click&DECiDE® BAI Version 13.0.0 - September 9th, 2013

Warning

IDProductComponentDescription
000Click&DECiDEAllClick&DECiDE 2013 requires a new license certificate.
000Framework ServerWeb PortalDue to the major rework of the Web Portal, the HTML Cubes, HTML Reports or HTML Queries are not supported under Windows 2003. Please note that Windows 2008 also provides better overall perfomances for the Web Portal.
000Framework ServerGoogle Charts v12Before using Google Charts version 12 you need to convert them into version 2013. Use the command "File" > "Convert xgc v12" and save the file.xgc. Note that any function such as GetParameterValue("ParamName") or tableBarFormat (6,{width:120}) will be replaced with env.getParameterValue("ParamName") or env.tableBarFormat (6,{width:120}). Function names are case sensitive: env.getParameterValue should contain a small "g".

Major Enhancement(s)

IDProductComponentDescription
000Framework ServerWeb PortalNew Web Portal: the look and design of the Web Portal have been completely reworked.
000Framework ServerWeb PortalThe Google Charts module has been improved, with new functions and new design.
824Framework DesktopExcel Data SourceThe ODBC Excel XLSX Datasource has been improved to be able to modify the Excel.xlsx file and at the same time use it from Builder or the Web Portal without locking this file.

Enhancement(s)

IDProductComponentDescription
821Framework DesktopBuilderNew "Excel XLSX Big Data" output format (*.XLSX) providing now a new option "Excel XLSX Big Data (Raw Data Mode)" allowing a fast export for big data volume. This option only accepts ERASESHEET or ERASEFILE write modes and sends data without layout neither format that you can change later under Excel.
830Framework DesktopBuilderThe "Excel" output format has been renamed "Excel XLS" and the "Excel 2007" output format has been renamed "Excel XLSX". Existing Excel or Excel 2007 will continue to work but we recommend you to switch them if possible with the new Output format names.
820Framework DesktopBuilderThe Event Manager options are now saved and restored when upgrading to a new Click&DECiDE version or release.
756Framework DesktopBuilderImprovement of output formats for a Cube. The data of a cube view can now be exported to any output format (Excel, ASCII, etc.) and not only top a file.cub.
764Framework ServerDashboardIt is now possible to define in a Dashboard project (*.wfd) an output format to Excel with a destination path and destination file name and use also a template, both being on the Server (network path). If no destination file is specified, the output file is open in the browser if running through the Web Portal.
785Framework DesktopDashboardIt is now possible to store in a parameter the Windows User in a Dashboard and Web Dashboard application. The parameter name is WINUSERNAME, automatically updated by Windows.
000Framework DesktopPivot Cross-tableA new 'Cross-Tables' Tab is now available in Builder to create some Pivots (Cross-table) as it was possible with the product DataSet Vision.

Critical Hotfix(es)

IDProductComponentDescription
813Framework ServerWeb PortalRetrieving tables and columns list was very slow when a user belongs to many groups. Now it is slow only the first time and faster next times.

Major Hotfix(es)

IDProductComponentDescription
671Framework ServerWeb PortalThe default value for a Parameter cannot be a the value of a Property through the Web Portal. This problem has been fixed.
686Framework DesktopBuilderWhen exporting a cube to Excel 2007/2010, the format of the "Column Total Percent" was not defined correctly. This problem has been fixed.
729Framework ServerGoogle ChartsWhen initializing a Google Chart, only the parameters without predefined values have to be initialized. This problem has been fixed.
755Framework DesktopBuilderA Pivot (Cross-table existing in DataSet Vision) cannot be opened with Builder. This problem has been fixed.
767Framework DesktopBuilderWriting to a non-empty table with an Access ODBC driver sometimes generates an error ODBC Error 100. This problem has been fixed.
769Framework ServerTasksA task with iteration was not working if the parameter was defined with 2 values separated by a pipe, such as a list of Date Keywords. This problem has been fixed.
772Framework DesktopDashboard and CubesIn a Dashboard, with a cube containing several Cube Views and the option "Hide details" activated, a GPF could occur when running the cube. This problem has been fixed.
784Framework DesktopBuilderIn a query having a join defined between a native virtual field and another field, the use of the feature 'Edit' then 'Replace Alias Source' was losing this join. This problem has been fixed.
671Framework ServerWeb PortalThe default value for a parameter cannot be updated by a Property defined in Administration Manager, although it is working fine under Builder. This problem has been fixed.
719Framework DesktopBuilderWhen you export a cube to Excel (Roambi format), then Click&DECiDE Builder creates missing quarters and months (see New featute 690), but it was necessary to have the Month names in the same language as the Regional Settings. Now, if this condition is false, a warning message informs the user instead of blocking the process.
634Framework ServerWeb PortalThe internal function CurrentWebUser('M') was not retreiving the current connected user when used through a parameter. This problem has been fixed.
510Framework ServerWeb PortalThe Scheduled tasks did not take care about the path defined in a Shared Folder if that one was modified. This problem has been fixed.
786Framework DesktopBuilderThe % character used in a query name could give a problem when opening several queries in Builder. This character is now forbidden.
791Framework DesktopBAI EngineThe option "Show item without data" could sometimes give an error in a Cross Table. This problem has been fixed.
814Framework DesktopBuilderThe criteria "In List" was not able to search a semi-colon in the values. This problem has been fixed.
817Framework DesktopOutput formatsThe "Remove spaces" option in the ASCII or CSV Output formats was not working. This problem has been fixed.

Minor Hotfix(es)

IDProductComponentDescription
685Framework ServerWeb PortalWhen exporting to HTML, some numeric fields could be a little bit too big compared to text field or static objects. This problem has been fixed.
759Framework ServerWeb PortalWhen editing a task whose topic is not defined, (Sheet, Cell, Write Mode for Excel or Write Mode for other output formats), the topic defined in the Output formats is now used. Through the Web Portal, the write mode topic can be now selected for concerned formats.
762Framework DesktopBuilderWhen using parameters with multi-columns values and the IGNORE default value, the edit field and check box should be uncheck. This problem has been fixed.
766Framework DesktopBuilderThe Browse button used to search for a Template.xls on a network drive was not working. This problem has been fixed.
790Framework DesktopBuilderWhen a mandatory parameter was disabled, Builder was requiring a value instead of ignoring this parameter. This problem has been fixed.
801Framework ServerWeb PortalWhen adding a new customized output format in Builder, and using this new output format through the Web Portal was giving an error (unknown output alias) if the Click and DECiDE Export Manager service was not restarted. This problem has been fixed.
825Framework ServerWeb PortalAn error could occurred when a Menu Item was pointing to a missing output format. Now, this missing output format is ignored without giving an error.

Click&DECiDE® BAI Version 12.0.3 - May 24th, 2013

Enhancement(s)

IDProductComponentDescription
803Framework DesktopOutput FormatsWhen opening the Output Format Configurator from Builder, it was necessary to be Administrator. Now, a User not being Administrator can open this module.
773Framework DesktopOutput FormatsWhen exporting a cube to Excel 2007 or greater, the file.cub is now included in the file.xlsm. The benefit is to have only one file to be sent, by a scheduled task for example.

Major Hotfix(es)

IDProductComponentDescription
772Framework DesktopDashboardWhen a cube object in a Dashboard was containing several Cube views, a GPF could occur when running the cube if the user was using the option Show Detail or Hide Detail. This problem has been fixed.
784Framework DesktopBuilderThe command "Replace Source Alias" was giving an error if the query was containing a join betwen a virtual field and a normal field, then the join was lost. This problem has been fixed.
792Framework DesktopDashboardWhen using the command "Print the current view" from a Cube object in a Dashboard, the result was always the original view and not the modified view. This problem has been fixed.
796Framework DesktopBuilderA GPF occurred when selecting the result column in the grid of a native SQL Query. This problem has been fixed.
798Framework ServerWeb PortalWhen running a task sending data to Excel 2003 (*.xls) using the option ERASESHEET, that is now replacing ERASEDATA, was not supported by this format. This problem has been fixed.

Click&DECiDE® BAI Version 12.0.2 - January 18th, 2013

Enhancement(s)

IDProductComponentDescription
751Framework DesktopBuilderImprovement of the Query/400 import tool: you can now import at the same time several Query/400, and if some of them cannot be converted to standard Builder Query, they are imported in a native SQL Query. Warning: it is necessary to upload to the iSeries the new Host Program version.
750Framework ServerWeb PortalA new splash screen is now displayed in the Web Portal and cannot be removed if using the Personal Edition.
747Framework DesktopOutput FormatWhen installing a new version or release above a previous version, the customized standard output formats are now restored after the installation instead of being overwritten.

Major Hotfix(es)

IDProductComponentDescription
746Framework ServerWeb PortalWhen running a shortcut using a parameter on a date field, with predefined date keywords, or a list of constant values, the list box to display these values was giving an error. This problem has been fixed.
748Framework ServerWeb PortalWhen running a shortcut or when using the full screen mode, the Run button was not changed into "Please wait". This problem has been fixed.
749Framework DesktopDashboardThe object sending data from a report into a grid in a Dashboard application was giving wrong numeric format results. This problem has been fixed.
753Framework ServerGoogle ChartWhen using the output Format "Google Data Table" in a Menu, the data containing double-quotes or a backslash need to get an escape character before the double-quote or the backslash. This problem has been fixed by adding a backslash as escape character.
758Framework DesktopBuilderThe ASCII Output Lenght was hidding some numeric iSeries column when exporting to ASCII with the option 'Complete values with spaces' if the width was too small. This problem has been fixed.

Minor Hotfix(es)

IDProductComponentDescription
759Framework ServerWeb PortalA task exporting to Excel 2007 should use the Output Format Topics (Cell and Write Mode) if they are not defined in the Scheduled Task. This problem has been fixed.
742Framework DesktopBuilderIn the TABLE Tab in a Builder Query, the command 'right mouse click' then 'Properties' on a Table was not opening or hiding the standard Properties Dialog Box. This problem has been fixed.

Click&DECiDE® BAI Version 12.0.1 - December 10th, 2012

Major Enhancement(s)

IDProductComponentDescription
736Framework ServerWeb PortalBy default this new feature is not activated because it is a new beta feature. The Google Charts performances can be increased doing the following steps: Open the ALIASES.INI file and add in the [GENERAL] section the flag D7VEM_UsePool=1, then save this file and restart the Click and DECIDE Services using the batch files stopIISandBAI.bat and startIISandBAI.bat located in the BAI directory. Note that this flag cannot be used if using EBIS Dashboards with output formats.

Enhancement(s)

IDProductComponentDescription
740SetupConfiguration wizardThe BAI Configuration wizard restarts now if necessary the Click and Decide Filter Engine and the Click and Decide XML Remote Configuration Services.

Critical Hotfix(es)

IDProductComponentDescription
731Framework ServerCubesWhen exporting a cube to HTML, the command "Save Data and Presentation" was not working anymore. This problem has been fixed.
732Framework ServerCubesA cube exported into HTML for the Web Portal from Builder or using a scheduled task was not building the correct format. The cube was readable locally but not through the Web Portal. This problem has been fixed.

Major Hotfix(es)

IDProductComponentDescription
730>Framework ServerGoogle ChartsUnder I.E. a single list selection in a Google Chart was displaying only one character in the combo box list. This problem has been fixed.
734Framework ServerWeb PortalScheduled Tasks: the migration from version 10 or 11 to 12 was not updating correctly a task whose output format was Excel. The task now adds the sheet name, the target cell and the write mode. This problem has been fixed.
739Framework DesktopBuilderPage Setup: with some printers, the Page Setup switches to Custom Size with width and height reversed. This problem has been fixed.
743Framework DesktopBuilderIf a report contains a background picture and if the "Report Background" property was defined to "First-Background", then the HTML generated was incorrect. This problem has been fixed.

Minor Hotfix(es)

IDProductComponentDescription
738Framework ServerGoogle ChartsThe timer function in a Google Chart was not working, giving a red message error. This problem has been fixed.
737Framework ServerGoogle ChartsA grid in a Google Chart was not always displaying the number of predefined rows. This problem has been fixed.

Click&DECiDE® BAI Version 12.0.0 - November 14th, 2012

Major Enhancement(s)

IDProductComponentDescription
000Framework ServerWeb PortalThe main new feature is the support of Google Charts through the Web Portal. Create easy and quick dashboards using the Google Charts. Nothing to install on any client workstation. Note that with I.E. 9 the Compatibility View Mode must not be used neither for the Google Charts neither for the Cubes, and that this mode must not be used under I.E.8 for the Cubes. The Google Charts require I.E. 9 or greater, or Chrome or Firefox.
000Framework ServerWeb PortalThe Web Portal can now be used on an iPad, iPhone and Android.
000Framework ServerData SourceThe Teradata database is now supported by Click&DECiDE with export in native mode.
000Framework ServerWeb PortalThe Web Portal design has been improved to support Firefox, Chrome and the touch user interfaces. Note that for Internet Explorer 8 and 9, the Compatibility View Mode must not be used anymore.
000Framework ServerWeb PortalA scheduled task can be run through a Menu item using an URL that you can copy from the Web Portal.
000Framework ServerWeb QueryThe Web Query supports now Unicode characters. You just need to save your Excel file with the UTF-8 Encoding Web Option (Tools button).
721Framework ServerWeb PortalA scheduled task can now be run asking a distinct result document for each value of the specified parameter, example for each Firewall, each Vendor, each Area etc.
722Framework DesktopBuilderA new alert type is now available: create a Google Doc document in a Google Drive folder for a Google account. This alert can send a PDF, Excel etc. document to this drive according to the alert condition.
643Framework ServerBuilderA query or a Builder Project proposes now more options about the choice of the Report Template to be used. In the Report Template List you can now also specify to use the "Default Template" or "No Template" if you do not wish to use any report template for a query or all queries of a project file.
642Framework ServerBAI EngineA new alert is now available: "Run and send by e-mail a Click and Decide Item" at the same time.
626Framework ServerBAI EngineBuilder can now manage an alert in a report and send the result with another output format than PDF even if the output format does not contain the block where the alert has been defined, such as Excel or ASCII output formats.
618Framework DesktopBuilderBuilder can now force a user to access to the iSeries only using a Click&DECiDE Connect Data Source and avoid a direct access to iSerie. The authorization is saved on the iSeries with IP Addresses excluded or included. See the version.txt file in the ..Click and DECiDE\BAI\d7srv400 directory for more information and see other enhancements.
577Framework DesktopCubesA cube can be now exported to Excel under a Roambi format. Use the command from Builder File - Export to Excel 2007 - Roambi Format.
568Framework ServerAdministration ManagerThe Scheduled Task file (d7tasks.xml) and any other xml file located in the Click&DECiDE\BAI directory are now saved when you make a backup from Administration Manager.
554Framework DesktopBuilderThe Click&DECiDE PDF Converter is now version 4.5.2.1.
540Framework ServerBuilderIf the machine language is unknown, then Builder now accepts by default keywords in English for Date, Time and DateTime criteria.
501Framework ServerBuilderClick&DECiDE now allows to create a Model (*.mox) from the current query.
500Framework DesktopBuilderClick&DECiDE Builder now accepts to use a native formula in the Join condition.
654Framework DesktopBAI EngineClick&DECiDE Builder can now send alerts from a query or a cube and not only from a report. (Use the command View > Alerts).
665Framework DesktopBAI EngineClick&DECiDE Builder now provides a Cumul function in a report that can use a native field from the query and calculate cumulated values, with reset to zero by Group Field (Break) or never. This function cannot apply to virtual fields formulas.
650Framework DesktopBuilderClick&DECiDE Builder now accepts an alert without defined condition and applies 'True' to such an alert.
690Framework DesktopBuilderWhen you export a cube to Excel (Roambi format), then Click&DECiDE Builder creates missing quarters and months.

Enhancement(s)

IDProductComponentDescription
644Framework DesktopBuilderClick&DECiDE Builder proposes now again the output format for Excel DDE (Dynamic Data Exchange) allowing to send data in an opened Excel worksheet, but without Unicode support.
711Framework DesktopBuilderClick&DECiDE Builder proposes now a new option in a Report Page Setup: Custom Size for the Page Size.
623Framework DesktopBuilderClick&DECiDE Builder proposes now a new option to avoid to make automatic joins when more than one table are selected in a query. This option is available in the command Tools> Options> Query Tab.
599Framework DesktopBuilderWhen Click&DECiDE Builder creates the Column Header in the Data Grid using the Column Descrition from the Data source, the length will ne now limited to 20 characters and any character not being alphanumerical will be replace by a space.
573Framework ServerBAI EngineAlerts: the Attachment option will be ignored in an alert with e-mail when the Alert Event Manager (LEO Service) is on a remote Server.
569Framework ServerAdministration ManagerThe Click&DECiDE Builder output formats are now saved under the name "outputsave.reg" in the BAI directory when making a backup from Administration Manager.
563Framework DesktopBuilderWhen a parameter is declared as Mandatory, you cannot leave the input empty but you can accept NULL value by entering NULL.
551Framework ServerWeb PortalIn the Web Portal, all the commands used to copy some URL such as WebQuery, PowerPivot, QlickView, Google Chart etc have been grouped in a popup menu and are grayed when not available.
548SetupBAIWebServerNow at the end of the installation a batch file can be run. This file is located in BAI\runonce directory and named runonce.bat. It will also be run when making a repair, a modification or an upgrade. If other files are required by this file, they must also be copied in this directory.
546Framework ServerWeb PortalA new icon allows now to copy a query under an XML format so that you can run it under Builder and also modify it.
522InstallationMMCNow the Management Console is always installed in the Enterprise Edition, and the backup feature is now also installed.
458Framework ServerWeb PortalA loading.gif animated picture has been added under the Run Scheduled Task button in the Web Portal until the task status is loaded. When running a scheduled task you cannot click again on this command when already running.
299Framework DesktopBuilderWhen you define a parameter updated by a formula and specify the Date or Timestamp Type, Builder keeps now your choice after editing the formula, instead of setting automatically this field type.
533Framework ServerTasksWhen you want to delete a Task in the Web Portal, the message saying that this task cannot be deleted because used in a scheduled task, will now display the list of the scheduled tasks inside of which this task is referenced.
418Framework DesktopBAI EngineWhen you cannot access to SQL Server because the program is unable to get user groups for the current user, the program was making an exception. Now, the program will display an error message.
627Framework DesktopBAI EngineThe SQL Server Data Source now displays the Table and Column Descriptions by default, if exist. As an example, for a MOVEX Database, add in the DDISQL.INI file, in this [data source] section the row MS_Description=MVXDTA. To disable this feature, just leave MS_Description= (leave blank after the equal sign).
628Framework ServerWeb PortalIt is now possible to forbide the use of a personal User Login for a Secured DataSource through the Web Portal. A new checkbox in Administration Manager is available to enable this feature for each datasource: "Prevent Web User Defining ID".
678Framework ServerWeb PortalWhen you export one or several reports in HTML, the report names are now displayed on the right of each report level.
680Framework ServerWeb PortalWhen exporting a task to Excel, the user interface has been improved to select the target Sheetname, the destination cell and the write mode.
695Framework ServerWeb PortalA new icon in the Scheduled Tasks list allows now to create a shortcut that can be use to run a scheduled task and force the parameters values.
705Framework DesktopBAI EngineIn an Oracle connexion, the "SQL*Net Easy configuration Alias" box allows to enter the TNS Name or a connection string. The size of 128 characters has been increased up to 512 characters to support bigger connection strings.
709Framework ServerBAI EngineSome new native functions for Percentage calculation have been added for iSeries, UDB, Oracle, SQL Server and ODBC datasources in the Misc Function Group. The functions are: PercentDiff(), PercentRatio(), PercentAdd(), PercentSub(), PercentValue().
710Framework DesktopBuilderSome new native functions for Percentage calculation have been added for Click&DECiDE Builder internal formulas in the Misc Function Group. The functions are: PercentDiff(), PercentRatio(), PercentAdd(), PercentSub(), PercentValue().

Critical Hotfix(es)

IDProductComponentDescription
586Framework ServerOtherFor a Webservice or SAP, When a "parameters" table contains a field of type boolean, the parameters table was not available in Builder. This problem has been fixed.
656Framework ServerBAI EngineGPF or error message when you want to define a Child-Field in a sub-report based on a cube data. This problem has been fixed.
660Framework ServerWeb PortalThe task migration from Click&DECiDE 10.2 to version 11.1 was using new Menu IDs instead of Menu Names. This problem has been fixed.
672Framework DesktopBuilderSometimes with the SUM function used in a Report with a big amount of values, the result value could be a float number with many decimals, such as for example -5698476,659999984. The problem was the rounded value giving -5698476,65 instead of -5698476,66. This problem has been fixed.

Major Hotfix(es)

IDProductComponentDescription
597Framework DesktopBuilderWith some Excel files, the sheets could not be displayed, specially when containing filters. This problem has been fixed.
582Framework DesktopBuilderAutomation: when running a report several time with a loop and parameters changing,and if this report was containing a run condition, this Run condition was not updated between each loop. This problem has been fixed.
560Framework ServerWeb PortalA parameter with first value hidden was giving an error if the second argument was containing a semi-colon. This problem has been fixed.
553Framework DesktopBuilderIn a report having a block containing a background color and a background color 2, a highlight background color could be hidden by the background color 2. This problem has been fixed.
535Framework ServerScheduled TasksThe NNNN suffix for a scheduled task was not working fine for an HTML output format. This problem has been fixed.
534Framework DesktopBuilderWhen retrieving a Query/400, the CROSS JOIN syntax is not understood by the parser. "CROSS JOIN" is now replaced by "," automatically.
527Framework ServerDashboardIn a Shared Folder, click on a Dashboard project was not asking to install WebBuilder . This problem has been fixed.
516SetupWizardInstalling BAI in a directory with Unicode characters was giving an error when running the Configuration Wizard. This problem has been fixed.
357Framework ServerWeb PortalEditing a task with multiple parameters and first column hidden was displaying only the first column values. This problem has been fixed.
633Framework DesktopBAI EngineEditing a task with multiple parameters and first column hidden was displaying only the first column values. This problem has been fixed.
646Framework DesktopBAI EngineEditing a task with multiple parameters and first column hidden was displaying only the first column values. This problem has been fixed.
658Framework DesktopBAI EngineEditing a task with multiple parameters and first column hidden was displaying only the first column values. This problem has been fixed.
666Framework DesktopBAI EngineEditing a task with multiple parameters and first column hidden was displaying only the first column values. This problem has been fixed.
370Framework ServerNRFilterEngineInserting data with Text Type Field in the SQL Server database was not working, and the NText Field type was not accepted. Both problems have been fixed.
648Framework ServerAdmin ManagerCreating an Excel data source with a too long name for the Excel file was not working. This problem has been fixed by troncating file name to 32 characters and replacing forbidden characters with underscores.
686Framework DesktopBuilderWhen exporting a cube to Excel 2007 or 2010 (*.xlsx) the Column Total Percentage was not exported to Excel correctly. This problem has been fixed.
693Framework ServerWeb PortalA query with several nested parameters was working fine under Click&DECiDE Builder but not through the Web Portal (empty list of value if list activated). This problem has been fixed.
702Framework ServerBAI EngineThe Click and Decide Server Helpers Service was consumming more and more memory depending on the way to run some items in the browser (Web Portal, Shortcut, Sharepoint etc.). This problem has been fixed.

Minor Hotfix(es)

IDProductComponentDescription
579Framework DesktopBuilderWhen using the command "Freeze pane" in the query Data Grid, a display problem occurred in the header row. This problem has been fixed.
552Framework ServerBuilderWhen using the command "Freeze pane" in the query Data Grid, a display problem occurred in the row numbers. This problem has been fixed.
363Framework ServerWeb PortalReport background image incorrect rendering in Html format on firefox 4.01. This problem has been fixed.
356Framework ServerBuilderWhen using a parameter with first column hidden with a default value as IGNORE|All, Builder was displaying IGNORE instead of All. This problem has been fixed.
632Framework DesktopDashboardWhen using a parameter with first column hidden with a default value as IGNORE|All, Builder was displaying IGNORE instead of All. This problem has been fixed.
652Framework DesktopDashboardWhen using a parameter with first column hidden with a default value as IGNORE|All, Builder was displaying IGNORE instead of All. This problem has been fixed.
585Framework DesktopBuilderWhen running a query or report from Builder, the OK and Cancel button where grayed but not disabled when a list box was displaying values. Now, these button are disabled until you validate the list or close the list.
659Framework DesktopBuilderWhen using a parameter name with accents, Builder accepts these characters but later does not accept them anymore when running the query. Now Builder will refuse such character when editing or creating a parameter.

Click&DECiDE® BAI Version 11.1.3 - March 30th, 2012

Major Enhancement(s)

IDProductComponentDescription
589Framework ServerWeb PortalItems are now sorted in shared folders by display name ascending except if all items are ending with a number. In that case they are sorted by display name descending. Items are still sorted by display name ascending in Builder projects (*.wfv).
609Framework DesktopBuilderYou can now hide the windows groups the user belongs, displayed in the About command of Builder, by changing a key in REGEDITY. Add a DWord 32-bit key into the key is HKEY_LOCAL_MACHINE\SOFTWARE\DataSet\DataSelect Vision\General\DoNotShowWindowsGroups and set the value to 1.
610Framework ServerWeb PortalYou can now hide the windows groups the user belongs, displayed in the Web Portal (Web Server Configuration) by modifying the web.config file located into the C:\inetpub\wwwroot\dvweb directoty.

Enhancement(s)

IDProductComponentDescription
595Framework ServerWeb PortalWhen the Web Portal arrives in display.aspx using a shortcut ending with __e=0 (no execution), the possibility to export to file locally has been added.

Ctitical Hotfix(es)

IDProductComponentDescription
588Framework DesktopBuilderUnable to send data on MS-Access if the query was containing a Date field. The error was like "Unspecified error - Bad data type - No corresponding data type found for column [`Date`]; seached ODBC Data Type = [11]. This problem has been fixed.
591Framework DesktopBuilderThe IBM DB2 ODBC Driver can send some \0 inside a Char or VarChar field type, called Low-Value. The problem was that Builder was sending the result to the wrong column (next column). This problem has been fixed.

Major Hotfix(es)

IDProductComponentDescription
592ConfigurationWizardWhen migrating from a 10.x version to an 11.x version, the NSI Engine migration was not done, giving errors in database connection when using alerts (nrfilter.xml). This problem has been fixed.
601Framework ServerNR Filter EngineAbnormal memory usage when database connection was lost. This problem has been fixed.
583Framework ServerNR Filter EngineInsertion Action fails with a database connection error on non-Latin-1 OS. This problem has been fixed.
605Framework DesktopBuilderThe "In List" criteria was not translated correctly in SQL when using several Date values. This problem has been fixed.
590Framework DesktopBuilderThe browse button in the criteria dialog box was not keeping a single quote that appears in a text value. This problem has been fixed.
587Framework DesktopBuilderWhen several columns have been defined in the Data Series for a Graph, and if you was editing again the column list in the Graph Properties, the order of the column was changed to alphabetical order. This problem has been fixed.
602Framework ServerInstallationThe installation will now add the INTERACTIVE Group for the Click&DECiDE Services with the appropriate rights so that this Group can instantaite the DCOM objects.
598Framework ServerInstallationUpdate BAI from 11.0 to 11.1: the Setup.exe was not recognizing the license certificate. This problem has been fixed.
600Framework DesktopBuilderWhen a Report from Cube was containing another sub-report from Cube, the preview could make an error when closing the report. This problem has been fixed.
596Framework DesktopCubesA cube using special characters in the view names (cube view or chart view) could generate a wrong XML file. This problem has been fixed.
606Framework ServerDatabaseThe ODBC Driver MS-Access could retreive some float values with a wrong presentation such as 0.09999999 instead of 0.01, the datasource using E-2 instead of 1E-2. This problem has been fixed.
534Framework ServerQuery/400When retrieving a Query/400, the CROSS JOIN syntax is not understood by the parser. Now the CROSS JOIN is replaced automatically with a coma to get a succesfull result.
611Framework ServerWeb PortalThe WebParts and the Home Pages will be now displayed in several distinct Tabs. One Tab for the Web Parts and up to 9 Tabs for the Home Pages. The problem was that some Home Pages was displayed inj the same Tab as the one used by the WebParts, under the WebParts.
612Framework DesktopBuilderWhen a query contains more than one sort condition, changing the Ascending to Descending on one field in the Query Worksheet was also changing the position of this field in the sort order in the SQL. This problem has been fixed.
614Framework DesktopBuilderA parameter updated by value(s) was not accepting more than one value in native SQL. This problem has been fixed.
615Framework DesktopBuilderThe highlight condition could give wrong result when having 2 conditions in a report. This problem has been fixed.
616Framework DesktopWeb DashboardThe WebDashboard cannot display an item list from a Builder project in a grid, list or combobox. This problem has been fixed.
617Framework DesktopBuilderThe highlight condition on a detail block for the background color was giving a black color. This problem has been fixed.
619Framework ServerBuilderThe query templates defined in a Builder project were not used if the project was in a shared folder. This problem has been fixed.
625Framework DesktopBuilderWhen exporting a cube to Excel, the filters were not managed correctly. This problem has been fixed.
626Framework DesktopBuilderIn the Report Alert, the export to an Excel or ASCII format was working but the Excel or ASCII file was not sent by e-mail, and a PDF file was sent. This problem has been fixed.

Minor Hotfix(es)

IDProductComponentDescription
38Framework ServerBAI EngineThe filter on a Date dimension in a cube was not working correctly. This problem has been fixed.
594Framework ServerWeb PortalWhen the Web Portal arrives in display.aspx using a shortcut ending with __e=0 (no execution), it was not possible to change the output format to "Other". This problem has been fixed.

Click&DECiDE® BAI Version 11.1.1 - January 27th, 2012

Major Enhancement(s)

IDProductComponentDescription
541Framework ServerBuilder EngineIn Builder or the Web Portal, the keywords for Date, Time or Timestamp fields can be now used in Russian.
574Framework ServerWeb PortalEven if using the Click&DECiDE Authentication, it is now possible to use WebQuery, PowerPivot and QlikView shortcuts. To do that, the Web.Config file located in the c:\inetpub\wwwroot\dvweb must be modified as follow: the MiscShortcutsAllowedInCnDAuthent parameter must be changed from False to True.

Enhancement(s)

IDProductComponentDescription
570Framework ServerWeb PortalIn the Web Portal, since version 11.0, the user can define a login for a Data Source with Security different than the one used to connect to the Web Portal. To to do, click the Web Server Configuration, then click Manage Data Source Logins and click the plus sign: select in the list the required Data Source and feed the User ID and Password boxes, then validate.

Ctitical Hotfix(es)

IDProductComponentDescription
558Framework DesktopBuilderThe program CnDSampleAutomation.exe was giving an error because of a wrong format of the file CnDSampleAutomation.exe.config. This problem has been fixed.

Major Hotfix(es)

IDProductComponentDescription
578Framework DesktopBuilderBuilder was using 2 connections: one when clicking on the data source when creating a new query but another one if the user was also clicking the "+" sign. This problem has been fixed.
580Framework ServerWebQueryAn error could occur when using Packed Numeric fields with SAP or iSeries in a WebQuery loaded by Excel.This problem has been fixed.
531Framework ServerWeb PortalWhen using Click&DECiDE Authentication, and after a timeout in the Web Portal, the login was prompt twice. This problem has been fixed.
572Framework ServerBuilderA problem has been fixed in the Report Alerts when all fields to define the Alert were using formulas.
571Framework DesktopBuilderA problem has been fixed in the data exportation to Excel XLSX: the existing formulas were not recalculated.

Click&DECiDE® BAI Version 11.1.0 - January 04th, 2012

Major Enhancement(s)

IDProductComponentDescription
494Framework DesktopBuilderIt is now possible to change the Click&DECiDE User Interface language without the need to modify the Regional Settings. To do so, click first the Project Tab (not available from an opened query, report or cube), then use the command "View" "Language", then select the required language. A message will ask you to restart Builder. This choice will also apply to Click&DECiDE Administration Manager (only for English or French), to Click&DECiDE Model (only for English or French) and Click&DECiDE Dashboard (only for English or French or German).
446Framework DesktopBuilderThe mouse wheel can be used now in the Query Tab in the tables et columns section.
483Framework ServerWeb PortalWhen exporting data using a Web Query into Excel, you can now specify a country code to get the required Date and number formats. To do so, click the Web Server Configuration bar in the Web Portal and specify the country to be used in the Date, Time, Numbers list box.
465Framework DesktopBuilderA new WebMenu Data Source is now available: from Builder you can now retreive all the queries already defined in a Web Menu, with their criteria, joins, sort conditions and parameters. Note that each parameter must be updated by a Click&DECiDE SQL, not by a query name (See new feature #488 below).
488Framework DesktopBuilderWhen you browse a query feeding a parameter in the Parameter Dialog Box, Builder will now retreive the SQL instead of the query name. This way is necessary for the above new feature #465. You can nevertheless select a query name if needed for any query not used with the new WebMenu Data Source.
454Framework ServerModel and BuilderIf a Model column name begins with an underscore character, then Builder does not authorize to select neither make a sort on this column. This feature has been done for SAP Model for the parameter columns.
457Framework DesktopBuilderThe Date fields are now left justified in a Click&DECiDE query.
482Framework DesktopBuilderWhen selecting a numeric field or a numeric virtual field, Click&DECiDE Builder will take care about the length and specified scale (decimal places).
335Framework ServerWeb PortalWhen using a shortcut ending with __e=0 (to be able to select some parameters or output formats), you can now go back to the parameter list by clicking on the ? (Question Mark) in the Browser.

Enhancement(s)

IDProductComponentDescription
521Framework ServerWeb PortalNow the Web Portal can accept up to 10 Tab: one is reserved for the Web Parts and 9 for the 9 first Home Pages sorted by alphabetical order. You can define more than 9 Home Pages and change their Title names to display the 9 required Home Pages.
399Framework ServerWeb PortalWhen editing a task, you can see now the items used when creating this task (Menu Alias, Item Alias or, for a shared folder, Builder project, path and item (query, report or cube names).
439Framework ServerCubesIt is now possible to export a cube to Excel 2007, using the output format "Excel 2007 Pivot Table" in the Web Portal, from other browsers than Internet Explorer such as Firefox, Google Chrome etc.
493Framework ServerWeb PortalAudit Web Server Statistics: now Web Builder and Web Dashboard are linked to the session ID to be able to save statistics by user about the item run in these applications.
416Framework DesktopBuilderThe XML Data Output format has been improved to allow to replace the XML Tag "Value" with an XML Tag "Column Name". Enable the option "Use the column name as Tag" in this output format.
509Framework DesktopBuilderFor the ASCII type output formats (ASCII, CSV, Text, WebQuery etc) an encoding option proposes now 3 modes: ANSI, Unicode UTF-8 and Unicode UTF-16.
443Framework DesktopBuilderClick&DECiDE can displays now a query (in HTML or PDF) with a best presentation using a Report Template. This option can be defined at the project level or at the query level. The default template proposed in the "Landscape A4 Full Extended Arial Blue One Page" giving one page if HTML output format is selected.
478Framework DesktopBuilderThe Q1 to Q4 Quarter Keywords can now be used between years 1990 to 2030. Whitout specifying the year, current year is used.
467Framework ServerWeb PortalThe output formats are not proposed in the Web Portal when not available for a specific item, even if defined in the menu file. "Excel 2007 Pivot Table" will be hidden for a query or a report (reserved for cubes), or other formats such as ASCII, Excel etc will be hidden for a cube, or HTML will be hidden for a cube if the browser is not I.E. (Excel 2007 Pivot Table only available).
463Click&DECiDESetupThe custom directory can now be used to copy customized files. The files into Custom\BAI will be copied into the Click&DECiDE BAI installation directory, default being C:\Program Files\Click and DECiDE\BAI or sub-directory if specified in Custom\BAI. The files into Custom\NSI will be copied into the Click&DECiDE NSI installation directory or sub-directory if specified in Custom\NSI, default being C:\Program Files\Click and DECiDE\NSI. The files into Custom\dvweb will be copied into the C:\inetpub\wwwroot\dvweb directory or sub-directory if specified in Custom\dvweb.

Ctitical Hotfix(es)

IDProductComponentDescription
474Framework DesktopBuilderThe output format database for a ODBC *.mdb file (MS-Access) was not working. This problem has been fixed.
524Framework DesktopBuilderThe output format Excel.xls could sometimes give an "error on output format: error unknown" with specific Excel files. This problem has been fixed.

Major Hotfix(es)

IDProductComponentDescription
520Framework ServerWeb PortalWhen a scheduled task failed, now the status will display "Failed" instead of "Successful" under the Run Scheduled Task button.
491Framework ServerNRFilterEngineThe action in workflow "Generate Generic Dashboard" type could send error 424 in the event viewer, although the report was generated and sent by e-mail succesfully.
371Framework ServerDashboardA grid upadted with a report in Dashboard remains empty with Unicode characters in the Web Portal.
450Framework ServerWeb PortalA scheduled task run from the Web Portal was not working under a Windows Server 2003.
503Framework ServerWeb PortalError code : 0x80020009, Exception occurred; "UserID or password is invalid" and direct access is unauthorized for Data Source XXX; after the session timeout. It was a cookie expiration issue.
242Framework DesktopBuilderThe Refresh Table command was giving an error if one of the table was missing in the current query.
417Framework DesktopBuilderBuilder did not display the real error message if an error occurred when adding a table that was not accessible.
431Framework DesktopBuilderBuilder was using 2 connections on the port 7726 when retreiving a Query/400.
455Framework ServerAdmin ManagerUsing a data source with security but without default login was running fine through the Web Portal, but not from Builder, saying that this data source was not assigned to the User Group.
456Framework ServerConfiguration WizardClick&DECiDE Administration Manager was not installed correctly if IIS was missing.
460Framework DesktopBuilderClick&DECiDE Builder got some problems to open project files from oldest version than version 11 when some items were named with special Uppercase characters with accents.
461Framework DesktopBuilderClick&DECiDE Builder got some problems to run formulas or functions in the Alerts if the directory containing the project file was named with a & character.
466Framework ServeriSeriesRunning queries on OS/400 V7R1 from CnD Builder leads to SQL0901 or SQL -901 errors, sometimes SQL0501 or -501, especially when running a query which does not return any row. The problem appears to be a bug on the OS/400, because the involved host program is a C program. A workaround has been done for this version.
470Framework ServerWeb PortalWhen a Web Menu was not accessible (wrong name or missing menu) the next menus were not displayed. Now, the wrong menu will be displayed with a red cross to alert the Administrator and the User, with error information in the right pane.
471Framework ServerWeb PortalWhen a Web Menu contains some output formats not available anymore in the current version (example: lost customized formats or HTML ASCII type) the menu was not loaded. Now, the wrong menu will be displayed with a red cross to alert the Administrator and the User, with error information in the right pane.

Minor Hotfix(es)

IDProductComponentDescription
433Framework DesktopBuilderClick&DECiDE Builder was asking twice a login when you cancel on the first login (depending on the database type).
449Framework DesktopBuilderThe command "edit" > "Insert SQL" in Click&DECiDE Builder was not displaying correctly the existing queries list.

Click&DECiDE® BAI Version 11.0.0 - October 4th, 2011

Major Enhancement(s)

IDProductComponentDescription
000Click&DECiDE BAIAll componentsThis new version 11 now supports UNICODE characters in all modules.
000Click&DECiDE BAIAll componentsThis new version 11 now supports SAP Data Access.
178Framework DesktopBAI EngineFor several output formats, the Unicode option has been added (ASCII, Text, CSV, RTF, XML, WebQueries, XML Data, Databases).
206BAI ServerWeb PortalStopping an execution in progress in the Web Portal was a new feature of version 10.2.2. but cancelling the execution could not be done until the return of FIRSTDATA. Now, cancelling during FIRSTDATA is possible with the followin Data Sources: SQL Server 2005 and greater, iSeries AS/400 TCPIP, Click&DECiDE Connect and ODBC Data Sources such as SQL Server 2005 (MS/32-bit and 64-bit), Oracle 11.2.0 (Oracle/64-bit), DB2 9.7 (IBM/32-bit and 64-bit), Informix client 3.50 TC7 (IBM/32-bit), MySQL ODBC 5.1 (V5.01.08.00 32-bit with MySQL server 5.5).
184Framework ServerWeb PortalMenu Builder provides now a database output format allowing to create a task through the Web Portal that can export data to a database, with 2 parameters: table destination and write mode using a file format with more information such as column name, size, decimal (*.fmt).
404Framework ServerWeb PortalA new button in the Web Portal allows now to run a scheduled task without the need to go to the Server to do it.
329Framework ServerWeb PortalWhen editing or creating a Scheduled Task, the box size displaying the available tasks list has been increased, according to a parameter ("NbTasksToDisplay") in the Web.Config file defined by default to 10 rows.
288Framework ServerMigrationClick&DECiDE version 11 can now import the scheduled tasks of a previous BAI or DataSet or NetReport version. Use the new icon displayed in the Web Portal on the right of the Scheduled Task branch (Import XML Tasks Configuration).
213Framework ServerBAI EngineA new property has been added for a sub-report or a graph object in a report: Retrieve Mode that could be Optimized (default value) or Forced. The Forced option allows the sub-report or the graph to be actualized for each time it is necessary as if the Parent and Child Link were defined. This feature can thus use a parameter value defined in a report using the "Assign to parameter" function on a field.
271Framework ServerBAI Web BuilderIf a local and valid license certificate exists, then Click&DECiDE Web Builder does not use the Web Server License. This allows to use Builder or Web Builder on the same workstation.
429Framework DesktopBuilderSome new internal functions are now available such as: ParamDateFrom('X'), ParamDateTo('X'), StringToDate (X,'dd/mm/yyyy hh:mm:ss') (see function file for more details).

Enhancement(s)

IDProductComponentDescription
138Framework DesktopBAI CubeA cube dimension can now receive several properties, for example the Customer Name dimension can have Address, City and Country as field properties.
139Framework DesktopBAI CubeA cube dimension can now be sorted by another field defined as properties. A filter can be applied to a property that has been set as a key.
140Framework DesktopBAI ReportA Report from Raw Cube Data does not use anymore the Header and Column names such as COL#000, COL#001 etc. Now, when creating a New Report from Raw Cube Data, the report will use the Cube Dimension Names as Header and Column Names.
142Framework DesktopBAI ReportA Report can now be used as a data grid when moving or resizing fields. Press ALT before clicking a field to be moved or resized: other fields will automatically be moved to a new location if the Inser Key is On (OVR disabled) or will get their sizes modified if the Inser Key is Off (OVR enabled).
143Framework DesktopBAI ReportWhen creating a new report, if the block size is too small to receive all columns from the query, the program will decrease the width for all columns to create only one row in the report. This applies only if the chosen report model is defined with fixed block size.
144Framework DesktopBAI ReportWhen creating a new Report from Raw Cube Data, the program now uses the cube column width for the report field size.
181ConfigurationBAI WizardWhen running the BAI Wizard Configuration, a new message is displayed if you cancel this program before the end, because the modifications done could be lost.
193Framework DesktopBAI CubeCube Dimension content can sometimes be so big that you cannot reduce the size once displayed. New field properties are now available according to the selected field: Caption, Width, Height and Text Alignment. A value with zero for Width and Height means an automatic size. The value is defined in pixels.
194Framework DesktopBAI BuilderUsing the Click&DECiDE About command, you can now see what is your Authentication Mode, your User Name and the Windows Groups you belong to.
179Framework ServerAdmin ManagerWhen opening Click&DECiDE Administraion Manager, you can now see what is your Authentication Mode in the Main Title Bar: [Mode: Windows] or [Mode: Click and DECiDE].
200Framework DesktopBAI ReportNew functions are provided in a Click&DECiDE Builder Report to display the path and file name of the Builder project and the report Name (see an example at the end of the Demo_Multicriteria Report in the Click and DECiDE Web Demonstration.wfv project.
201Framework DesktopBAI QueryWhen creating a new parameter in a Query, you can now add this parameter in the Project Parameter with a button.
220ConfigurationBAI WizardWhen defining the SMTP Server name in the BAI Configuration wizard, it is now possible to define a UserID and password if the SMTP Server requires an authentication. Also, when testing the SMTP Server name, you can send a test mail to check the SMTP Server configuration.
245Framework DesktopBAI CubeA cube now proposes a new dimension including Month and Week at the same time, as well as the Day the Week.
248ConfigurationLicenseA temporary license certificate in now valid until the end of the limit date at 23:59:59 instead of 00:00:00.
265Framework ServerBAI Web BuilderWeb Builder only can use a "Connect" data source against the Web Server when using the Web Server license.
296Framework ServerAdmin ManagerThe Administrator can now hide a data source to the connected users using a "Connect" data source. To do so, the data source name must end with a $ character.
346Framework ServerWeb PortalWhen a task exports the result to Excel or Excel 2007 output format, the .xls or .xlsx extension will be added automatically if not specified.
350Framework ServerWeb Menu BuilderFor a Shared Folder, a new option allows now to hide empty directories.
351Framework ServerWeb Menu BuilderIt is now possible to customize the icon displayed in a Menu for each item (Query, Report, Cube, Shared Folder etc.).

Critical Hotfix(es)

IDProductComponentDescription
297BAI DesktopBuilderWhen exporting a Date field from iSeries to Excel 2007, the file was unreadable with an error message such as: There was an error when browsing for a date:An hour must have at least one digit to be evaluated.
310BAI DesktopBuilderWhen exporting a cube having no dimension in column to Excel, the file was unreadable.

Major Hotfix(es)

IDProductComponentDescription
317BAI ServerAdmin.ManagerAdministration manager doesn't deal with local administrators group. When a BAI Server belongs to a domain, Administration Manager cannot start with a User Domain which belongs to the Local Administrators group. Only Domain Administrators can start Administration Manager. OS with UAC was not detected.
298BAI ServerWeb DashboardA display problem occurred when a text field was containing numeric values beginning with one or several zeros. The zeros were not displayed.
331Framework ServerWeb PortalWhen renaming a task, the modification is now reported into the scheduled tasks using this task.
339Framework ServerAdministration ManagerA backup of Administration Manager is now working fine under Windows 7 Professional SP1 64 bits.
357Framework ServerWeb PortalA problem editing a task using a criteria including parameter with hidden first column has been fixed.
384Framework ServerWeb PortalA shortcut ending with __e=1 and running an output format included in the "Other" list was runing the first item in this list instead of format specified in the shortcut.
398Framework ServerWeb PortalScheduled Task to Excel/Excel 2007 with the NNNN suffix was making a zero bytes file.

Click&DECiDE® BAI Version 10.2.4 - June 30th, 2011

Major Enhancement(s)

IDProductComponentDescription
355Framework ServerBAI ServerClick&DECiDE supports now the new OS400 V7 R1 TR2 from IBM when using iSeries databases.

Critical Hotfix(es)

IDProductComponentDescription
301BAI DesktopDashboardThe connection parameters in a Dashboard project where lost when closing the project.

Major Hotfix(es)

IDProductComponentDescription
317BAI ServerAdmin.ManagerAdministration manager doesn't deal with local administrators group. When a BAI Server belongs to a domain, Administration Manager cannot start with a User Domain which belongs to the Local Administrators group. Only Domain Administrators can start Administration Manager. OS with UAC was not detected.
298BAI ServerWeb DashboardA display problem occurred when a text field was containing numeric values beginning with one or several zeros. The zeros were not displayed.

Minor Hotfix(es)

IDProductComponentDescription
274BAI ServerCubesAn error could occur when opening a cube (.hta) "The query could not be processed - The data provider didn't supply any further error information". The problem was because the MSOLAP driver on the Server where the cube has been generated was a most recent version (MSOLAP.4) than the one located on the client PC opening this cube (MSOLAP).

Click&DECiDE® BAI Version 10.2.3 - February 10th, 2011

Major Enhancement(s)

IDProductComponentDescription
260BAI ServerWeb PortalWhen using a Database login to connect to the Web Portal, it is now possible to propagate the login for the data transfert to the Database. The Click&DECiDE Authentication must be used, the option "Data Source Checking Password" must be activated in Administration Manager and the ALIASES.INI must contain the flag "DataSourceForWebLogin=SourceAlias" in the [Web] section, SourceAlias being the Data Source Name declared as a secured Data Source in Administration Manager.

Major Hotfix(es)

IDProductComponentDescription
256ConfigurationWizardUnder Windows 2003, if the IIS6 default Web Site has been removed then created again, or has been renamed, the site ID was not set to 1 anymore. The program now will search the new ID of the dvweb site.

Click&DECiDE® BAI Version 10.2.2 - January 21st, 2011

Major Enhancement(s)

IDProductComponentDescription
206BAI ServerWeb PortalIt is now possible to stop an execution in progress. The consequence is that you cannot click elsewhere on the Web Portal before the current run is completed or stopped. (Improvement of the Click&DECiDE Export Manager Service). It should be noted that two steps are required when executing a query: the FIRSTDATA that returns the first set of data and then the FETCH that returns a result of successive data packet. Cancelling the execution cannot be done until the return of FIRSTDATA, ie either during the recovery following blocks, either during the formatting of data (query, report and cube). Cancelling during FIRSTDATA is planned for version 11 of Click&DECiDE.

Major Hotfix(es)

IDProductComponentDescription
175Framework DesktopBAI BuilderUnable to remove an alert in a Click&DECiDE Builder Report if you used the delete button without having saved and closed the report after creating this alert.
176Framework DesktopBAI BuilderThe Report Properties button was not working as it should: it show or hide the properties in general and not that of the report as expected.
180Framework DesktopBAI BuilderIf a parameter was defined without specifying the update method, it was not proposed at the query execution.
183Framework DesktopBAI EngineIf a parameter had as default value the result of a query that itself uses another parameter updated by a "group" or "user group" property, through the Web portal or a shared folder, this query was not working under the group and user profile connected to the Web Portal.
185Framework DesktopBAI BuilderUnable to close a Click&DECiDE Builder project file if you are opening a report in a Print Preview mode.
187Framework DesktopBAI CubeOn a cube, a filter on a character field does not support a value containing an apostrophe, like "Software's" for example.
189Framework DesktopBAI BuilderWhen exporting a query to Excel and if the font color has been modified, this color was not exported to Excel.
190Framework DesktopBAI DasboardSome objects like the chart had a display problem when using a command line that includes the program RunEbis.exe.
195Framework DesktopBAI DasboardA problem transmitting a parameter value to update a data grid has been solved in Dasboard. Example: ...where param1 like col1 AND col1 in (query1), (query1 being a sub-query containing critria on the same parameter param1).
197Framework DesktopBAI DashboardAn Image object would not accept a parameter in the path to an image file, such as "c:\my documents\" + Parameter + ".jpg".
199Framework DesktopBAI EngineA query with a parameter supplied by another native SQL queries did not work via the Web portal and caused an error in the Click&DECiDE Export Manager Service.
204BAI ServerWeb PortalIf we added a table in an existing query, and that table had no rights to be used by the user of this request, no further action on this query was possible. The query memorized this new table and continued to cause the same error about missing rights.
207BAI DesktopBuilderUnable to right click then "Edit" on a Excel chart object included in a Click&DECiDE report.
208BAI DesktopBuilderA criterion defined as "Included in the list" was not accepting empty value.
210BAI DesktopBuilderWith Click&DECiDE Authentication, you lost the login information when opening a new session, which could give an error when opening a Web Dashboard.
214BAI DesktopSetupSetup Wizard BAI: sometimes the check box to install the sample was selected but grayed out, making it impossible to uncheck.

Click&DECiDE® BAI Version 10.2.1 - September 3rd, 2010

Critical Hotfix(es)

IDProductComponentDescription
157BAI ServerOtherWeb Query was not taking care about a parameter fed with an Administration Manager User or User Group Property.

Major Hotfix(es)

IDProductComponentDescription
23BAI DesktopOtherA Report Book sometimes was displaying the parameter input in several screens instead of a unique screen.
102Framework ServerSecureIn Administration Manager and Model, going to the "About..." command was making the Close, Full Screen or Reduce buttons not active anymore. The Alt+F4 command was nevertheless still working to close the application.
156InstallationBAI DesktopThe Local Database Output format was not installed. In HEKY_LOCAL_MACHINE\SOFTWARE\DataSet\output\Base Config\Database, add the entry Dll=outdb to solve the problem.
160Framework DesktopBuilderReport Templates: the Edit mode could make a GPF if the working window was too small.
165Framework DesktopBuilderAlerts: If parameters other than Input type exist, they were displayed with a duplicate name using the last visible one.
167BAI ServerOtherWeb Dashboard: a parameter fed by a User or User Group Property was sometimes not recognized, if the option "Ignore parameters when there is no value" was activated.
166Framework ServerWeb PortalBuilding a VBS exporting a Report Book from a Task was making an incorrect syntax in Set VisionProjectItem = VisionProject.(""Report_Name"") instead of Set VisionProjectItem = VisionProject.Reports(""Report_Name"").
168Framework DesktopBAI EngineExport of a cube to Excel 2007 in the Web Portal: saving the ".xlsm" file was not enough to use the Excel file later (the .cub file was not anymore available).

Click&DECiDE® BAI Version 10.2.0 - August 6th, 2010

Major Enhancement(s)

IDProductComponentDescription
65Framework DesktopBAI EngineParameter - New update method using a User or User Group Property defined in Administration Manager.
74Framework DesktopBuilderSupport of Excel 2010 with Click&DECiDE.
79Framework DesktopBuilderProjects: the Builder Projects can now be opened using an "Execute Only" mode according to the license certificate.
91Framework DesktopBuilderThe value 1000 for the TOP 1000 used when searching online values in the criteria dialog box is now customizable in Tools> Options> Query.
94BAI DesktopOtherClick&DECiDE Builder can now start without license the data source is a Click&DECiDE Connect type. The Server license will give the correct information to the user.
118Framework DesktopBAI EngineThe "Click and DECiDE PDF Exp Printer" uses now the new Amyuni Converter PDF v4.00.
129Framework DesktopBAI EngineReport: in a Highlight, you can now modify the static text of a 'Text' object using a condition.
132Framework DesktopBAI EngineReport: the customized colors can now be copied using the Edit> Copy Custom Colors in a report and paste in another report or another Builder Project report.

Enhancement(s)

IDProductComponentDescription
36Framework DesktopBAI EngineReport: a new property allows now to define a second background color. If this color is defined in the Detailed Block, that will give an alternate color to the rows in the report edition.

Critical Hotfix(es)

IDProductComponentDescription
97Framework ServerWeb PortalClick&DECiDE Web Builder sometimes cannot open the d7web.vvv file.
130Framework ServerBAI EngineGPF sometimes when opening reports having some graphs.
135Framework ServerBAI EngineA new SQL Server data source got wrong execution mode. The data source was set to "multithread execution mode", but then, when validating, the execution mode was changed to "separate process".

Major Hotfix(es)

IDProductComponentDescription
100Framework DesktopBAI EngineQuery: virtual field using Now() or CurrentTimeStamp() and Parameter fed by a formula using also Now() or CurrentTimeStamp(): the result between the virtual field and the parameter could be different after a while.
104Framework DesktopBAI EngineExport to Excel 2007: error when exporting data to cells in REPLACE mode. (Style error if the destination cell got already a predefined style).
105Framework DesktopBAI EngineExport a cube from the Web Portal to Excel 2007 was not working if you previously exported a query to Excel 2007. The error was "The server threw an exception" and it was necessary to restart the Click&DECiDE services.
124Framework DesktopBAI EngineWeb Builder (.vvv file): creating a new project was not taking care about the Server license.
127Framework DesktopBAI EngineParameter: a false circular reference error has been fixed.
131Framework DesktopBuilderValue for a parameter starting with a blank (space): the blank value was lost when running the query.
133Framework DesktopBAI EngineA Project Parameter changed from Disable to Enable was not changed in a query, staying still in Disable mode.
134Framework DesktopBAI EngineThe "Hide First column" option was modifiable from a query even if the Parameter was a Project Parameter.

Minor Hotfix(es)

IDProductComponentDescription
64Framework ServerNREngineEventProblem when generating several files with NNNN suffixes. From BAI Builder, if an alert was generating several files having the same name, with an NNNN suffix, sometimes an error could occur when generating 2 reports in the same file (synchronization issue).
92Framework ServerWeb PortalThe WebVisionCube.exe program installs now the Cube component by default in C:\Program Files\Common Files\Click and DECiDE instead of C:\Program Files\Common Files\DataSet.