ID | Product | Component | Description |
---|
899 | Framework Server | Dashboard | Several new Google Charts are now proposed in this release: Annotation Chart, Calendar Chart, Donut Chart, Histogram Chart, Sankey Chart, Timeline Chart, Dashboard with String Filter, Dashboard with Chart Range Filter, Dashboard with Number Range Filter and Dashboard with Category Filter, making easy and faster the way to create Dashboards. The filters are using the data already in memory instaed of running a separate query, improving the performances. |
901 | Framework Server | Dashboard | A new object is now available in the "Other Objects" list: the Pivot object allowing to create cubes working under Internet Explorer, Chrome and Firefox and without the need of the Microsoft Web Component 2003. |
890 | Framework Server | Web Portal | The HTML Navbar allows now to use some keyboard keys to navigate easily. Left or Up Arrows = Next Page, Right or Down Arrows = Previous Page, Home key = First Page, End Key = Last Page, Page Up and Page Down = Next or Previous block of X pages depending on the total number of pages. |
885 | Configuration | Wizard | The silent installation of Builder must be followed by the execution of the Configuration Wizard. This program can now be run in silent mode and install the Demo database in SQL Server and create the Local SQL Server data source using the command d7vWZConfig.exe /samples. |
ID | Product | Component | Description |
---|
874 | Framework Server | Web Portal | It was not possible anymore to schedule a task running a cube asking only for the ".cub" file. This problem has been fixed. |
882 | Framework Server | Web Portal | If 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. |
883 | Framework Server | Web Portal | The 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. |
887 | Framework Server | Web Portal | An 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. |
889 | Framework Desktop | Automation | The program CnDSampleAutomation.exe was not up to date about the Excel output format syntax and the parameters management. This problem has been fixed. |
893 | Framework Server | Web Portal | The 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. |
895 | Framework Desktop | Builder | The Export Data icon was not available from a Cube Analysis Services from Builder. This problem has been fixed. |
896 | Framework Server | Web Portal | A 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. |
905 | Framework Server | Web Portal | An 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. |
ID | Product | Component | Description |
---|
864 | Framework Server | PowerPivot Excel | When 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. |
860 | Framework Server | Web Portal | If a parameter had no default value in the Web Portal, an error occurred. This problem has been fixed. |
851 | Framework Desktop | Builder | The "&" 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. |
852 | Framework Desktop | Output format | When 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. |
853 | Framework Desktop | Data Source Configurator | The 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. |
854 | Framework Server | Builder | Exporting 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. |
857 | Framework Server | Menu Builder | As for the Hotfix #851, the "&" character is now forbidden in any Menu branch name to avoid problems later in URLs. |
843 | Framework Server | Web Portal | A mandatory parameter was accepting an empty value through the Web Portal, although Builder was not accepting it. This problem has been fixed. |
835 | Framework Desktop | Builder | A 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. |
ID | Product | Component | Description |
---|
871 | Framework Server | Web Portal | A 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". |
862 | Framework Desktop | Builder | When 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. |
858 | Framework Server | Web Portal | When 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. |
859 | Framework Server | Web Portal | When 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. |
836 | Framework Desktop | Builder | When 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. |
837 | Framework Server | Scheduled Task | When 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. |
845 | Framework Desktop | Builder | The "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. |
847 | Framework Server | Builder | When 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. |
842 | Framework Server | Google Charts | The "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. |
ID | Product | Component | Description |
---|
821 | Framework Desktop | Builder | New "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. |
830 | Framework Desktop | Builder | The "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. |
820 | Framework Desktop | Builder | The Event Manager options are now saved and restored when upgrading to a new Click&DECiDE version or release. |
756 | Framework Desktop | Builder | Improvement 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. |
764 | Framework Server | Dashboard | It 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. |
785 | Framework Desktop | Dashboard | It 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. |
000 | Framework Desktop | Pivot Cross-table | A new 'Cross-Tables' Tab is now available in Builder to create some Pivots (Cross-table) as it was possible with the product DataSet Vision. |
ID | Product | Component | Description |
---|
671 | Framework Server | Web Portal | The default value for a Parameter cannot be a the value of a Property through the Web Portal. This problem has been fixed. |
686 | Framework Desktop | Builder | When exporting a cube to Excel 2007/2010, the format of the "Column Total Percent" was not defined correctly. This problem has been fixed. |
729 | Framework Server | Google Charts | When initializing a Google Chart, only the parameters without predefined values have to be initialized. This problem has been fixed. |
755 | Framework Desktop | Builder | A Pivot (Cross-table existing in DataSet Vision) cannot be opened with Builder. This problem has been fixed. |
767 | Framework Desktop | Builder | Writing to a non-empty table with an Access ODBC driver sometimes generates an error ODBC Error 100. This problem has been fixed. |
769 | Framework Server | Tasks | A 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. |
772 | Framework Desktop | Dashboard and Cubes | In 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. |
784 | Framework Desktop | Builder | In 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. |
671 | Framework Server | Web Portal | The 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. |
719 | Framework Desktop | Builder | When 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. |
634 | Framework Server | Web Portal | The internal function CurrentWebUser('M') was not retreiving the current connected user when used through a parameter. This problem has been fixed. |
510 | Framework Server | Web Portal | The Scheduled tasks did not take care about the path defined in a Shared Folder if that one was modified. This problem has been fixed. |
786 | Framework Desktop | Builder | The % character used in a query name could give a problem when opening several queries in Builder. This character is now forbidden. |
791 | Framework Desktop | BAI Engine | The option "Show item without data" could sometimes give an error in a Cross Table. This problem has been fixed. |
814 | Framework Desktop | Builder | The criteria "In List" was not able to search a semi-colon in the values. This problem has been fixed. |
817 | Framework Desktop | Output formats | The "Remove spaces" option in the ASCII or CSV Output formats was not working. This problem has been fixed. |
ID | Product | Component | Description |
---|
685 | Framework Server | Web Portal | When 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. |
759 | Framework Server | Web Portal | When 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. |
762 | Framework Desktop | Builder | When 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. |
766 | Framework Desktop | Builder | The Browse button used to search for a Template.xls on a network drive was not working. This problem has been fixed. |
790 | Framework Desktop | Builder | When a mandatory parameter was disabled, Builder was requiring a value instead of ignoring this parameter. This problem has been fixed. |
801 | Framework Server | Web Portal | When 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. |
825 | Framework Server | Web Portal | An 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. |
ID | Product | Component | Description |
---|
000 | Framework Server | Web Portal | The 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. |
000 | Framework Server | Web Portal | The Web Portal can now be used on an iPad, iPhone and Android. |
000 | Framework Server | Data Source | The Teradata database is now supported by Click&DECiDE with export in native mode. |
000 | Framework Server | Web Portal | The 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. |
000 | Framework Server | Web Portal | A scheduled task can be run through a Menu item using an URL that you can copy from the Web Portal. |
000 | Framework Server | Web Query | The Web Query supports now Unicode characters. You just need to save your Excel file with the UTF-8 Encoding Web Option (Tools button). |
721 | Framework Server | Web Portal | A 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. |
722 | Framework Desktop | Builder | A 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. |
643 | Framework Server | Builder | A 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. |
642 | Framework Server | BAI Engine | A new alert is now available: "Run and send by e-mail a Click and Decide Item" at the same time. |
626 | Framework Server | BAI Engine | Builder 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. |
618 | Framework Desktop | Builder | Builder 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. |
577 | Framework Desktop | Cubes | A cube can be now exported to Excel under a Roambi format. Use the command from Builder File - Export to Excel 2007 - Roambi Format. |
568 | Framework Server | Administration Manager | The 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. |
554 | Framework Desktop | Builder | The Click&DECiDE PDF Converter is now version 4.5.2.1. |
540 | Framework Server | Builder | If the machine language is unknown, then Builder now accepts by default keywords in English for Date, Time and DateTime criteria. |
501 | Framework Server | Builder | Click&DECiDE now allows to create a Model (*.mox) from the current query. |
500 | Framework Desktop | Builder | Click&DECiDE Builder now accepts to use a native formula in the Join condition. |
654 | Framework Desktop | BAI Engine | Click&DECiDE Builder can now send alerts from a query or a cube and not only from a report. (Use the command View > Alerts). |
665 | Framework Desktop | BAI Engine | Click&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. |
650 | Framework Desktop | Builder | Click&DECiDE Builder now accepts an alert without defined condition and applies 'True' to such an alert. |
690 | Framework Desktop | Builder | When you export a cube to Excel (Roambi format), then Click&DECiDE Builder creates missing quarters and months. |
ID | Product | Component | Description |
---|
644 | Framework Desktop | Builder | Click&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. |
711 | Framework Desktop | Builder | Click&DECiDE Builder proposes now a new option in a Report Page Setup: Custom Size for the Page Size. |
623 | Framework Desktop | Builder | Click&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. |
599 | Framework Desktop | Builder | When 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. |
573 | Framework Server | BAI Engine | Alerts: the Attachment option will be ignored in an alert with e-mail when the Alert Event Manager (LEO Service) is on a remote Server. |
569 | Framework Server | Administration Manager | The Click&DECiDE Builder output formats are now saved under the name "outputsave.reg" in the BAI directory when making a backup from Administration Manager. |
563 | Framework Desktop | Builder | When a parameter is declared as Mandatory, you cannot leave the input empty but you can accept NULL value by entering NULL. |
551 | Framework Server | Web Portal | In 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. |
548 | Setup | BAIWebServer | Now 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. |
546 | Framework Server | Web Portal | A new icon allows now to copy a query under an XML format so that you can run it under Builder and also modify it. |
522 | Installation | MMC | Now the Management Console is always installed in the Enterprise Edition, and the backup feature is now also installed. |
458 | Framework Server | Web Portal | A 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. |
299 | Framework Desktop | Builder | When 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. |
533 | Framework Server | Tasks | When 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. |
418 | Framework Desktop | BAI Engine | When 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. |
627 | Framework Desktop | BAI Engine | The 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). |
628 | Framework Server | Web Portal | It 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". |
678 | Framework Server | Web Portal | When you export one or several reports in HTML, the report names are now displayed on the right of each report level. |
680 | Framework Server | Web Portal | When exporting a task to Excel, the user interface has been improved to select the target Sheetname, the destination cell and the write mode. |
695 | Framework Server | Web Portal | A 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. |
705 | Framework Desktop | BAI Engine | In 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. |
709 | Framework Server | BAI Engine | Some 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(). |
710 | Framework Desktop | Builder | Some 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(). |
ID | Product | Component | Description |
---|
597 | Framework Desktop | Builder | With some Excel files, the sheets could not be displayed, specially when containing filters. This problem has been fixed. |
582 | Framework Desktop | Builder | Automation: 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. |
560 | Framework Server | Web Portal | A parameter with first value hidden was giving an error if the second argument was containing a semi-colon. This problem has been fixed. |
553 | Framework Desktop | Builder | In 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. |
535 | Framework Server | Scheduled Tasks | The NNNN suffix for a scheduled task was not working fine for an HTML output format. This problem has been fixed. |
534 | Framework Desktop | Builder | When retrieving a Query/400, the CROSS JOIN syntax is not understood by the parser. "CROSS JOIN" is now replaced by "," automatically. |
527 | Framework Server | Dashboard | In a Shared Folder, click on a Dashboard project was not asking to install WebBuilder . This problem has been fixed. |
516 | Setup | Wizard | Installing BAI in a directory with Unicode characters was giving an error when running the Configuration Wizard. This problem has been fixed. |
357 | Framework Server | Web Portal | Editing a task with multiple parameters and first column hidden was displaying only the first column values. This problem has been fixed. |
633 | Framework Desktop | BAI Engine | Editing a task with multiple parameters and first column hidden was displaying only the first column values. This problem has been fixed. |
646 | Framework Desktop | BAI Engine | Editing a task with multiple parameters and first column hidden was displaying only the first column values. This problem has been fixed. |
658 | Framework Desktop | BAI Engine | Editing a task with multiple parameters and first column hidden was displaying only the first column values. This problem has been fixed. |
666 | Framework Desktop | BAI Engine | Editing a task with multiple parameters and first column hidden was displaying only the first column values. This problem has been fixed. |
370 | Framework Server | NRFilterEngine | Inserting 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. |
648 | Framework Server | Admin Manager | Creating 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. |
686 | Framework Desktop | Builder | When exporting a cube to Excel 2007 or 2010 (*.xlsx) the Column Total Percentage was not exported to Excel correctly. This problem has been fixed. |
693 | Framework Server | Web Portal | A 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. |
702 | Framework Server | BAI Engine | The 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. |
ID | Product | Component | Description |
---|
579 | Framework Desktop | Builder | When using the command "Freeze pane" in the query Data Grid, a display problem occurred in the header row. This problem has been fixed. |
552 | Framework Server | Builder | When using the command "Freeze pane" in the query Data Grid, a display problem occurred in the row numbers. This problem has been fixed. |
363 | Framework Server | Web Portal | Report background image incorrect rendering in Html format on firefox 4.01. This problem has been fixed. |
356 | Framework Server | Builder | When 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. |
632 | Framework Desktop | Dashboard | When 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. |
652 | Framework Desktop | Dashboard | When 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. |
585 | Framework Desktop | Builder | When 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. |
659 | Framework Desktop | Builder | When 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. |
ID | Product | Component | Description |
---|
592 | Configuration | Wizard | When 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. |
601 | Framework Server | NR Filter Engine | Abnormal memory usage when database connection was lost. This problem has been fixed. |
583 | Framework Server | NR Filter Engine | Insertion Action fails with a database connection error on non-Latin-1 OS. This problem has been fixed. |
605 | Framework Desktop | Builder | The "In List" criteria was not translated correctly in SQL when using several Date values. This problem has been fixed. |
590 | Framework Desktop | Builder | The browse button in the criteria dialog box was not keeping a single quote that appears in a text value. This problem has been fixed. |
587 | Framework Desktop | Builder | When 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. |
602 | Framework Server | Installation | The 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. |
598 | Framework Server | Installation | Update BAI from 11.0 to 11.1: the Setup.exe was not recognizing the license certificate. This problem has been fixed. |
600 | Framework Desktop | Builder | When 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. |
596 | Framework Desktop | Cubes | A cube using special characters in the view names (cube view or chart view) could generate a wrong XML file. This problem has been fixed. |
606 | Framework Server | Database | The 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. |
534 | Framework Server | Query/400 | When 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. |
611 | Framework Server | Web Portal | The 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. |
612 | Framework Desktop | Builder | When 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. |
614 | Framework Desktop | Builder | A parameter updated by value(s) was not accepting more than one value in native SQL. This problem has been fixed. |
615 | Framework Desktop | Builder | The highlight condition could give wrong result when having 2 conditions in a report. This problem has been fixed. |
616 | Framework Desktop | Web Dashboard | The WebDashboard cannot display an item list from a Builder project in a grid, list or combobox. This problem has been fixed. |
617 | Framework Desktop | Builder | The highlight condition on a detail block for the background color was giving a black color. This problem has been fixed. |
619 | Framework Server | Builder | The query templates defined in a Builder project were not used if the project was in a shared folder. This problem has been fixed. |
625 | Framework Desktop | Builder | When exporting a cube to Excel, the filters were not managed correctly. This problem has been fixed. |
626 | Framework Desktop | Builder | In 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. |
ID | Product | Component | Description |
---|
494 | Framework Desktop | Builder | It 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). |
446 | Framework Desktop | Builder | The mouse wheel can be used now in the Query Tab in the tables et columns section. |
483 | Framework Server | Web Portal | When 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. |
465 | Framework Desktop | Builder | A 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). |
488 | Framework Desktop | Builder | When 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. |
454 | Framework Server | Model and Builder | If 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. |
457 | Framework Desktop | Builder | The Date fields are now left justified in a Click&DECiDE query. |
482 | Framework Desktop | Builder | When selecting a numeric field or a numeric virtual field, Click&DECiDE Builder will take care about the length and specified scale (decimal places). |
335 | Framework Server | Web Portal | When 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. |
ID | Product | Component | Description |
---|
521 | Framework Server | Web Portal | Now 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. |
399 | Framework Server | Web Portal | When 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). |
439 | Framework Server | Cubes | It 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. |
493 | Framework Server | Web Portal | Audit 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. |
416 | Framework Desktop | Builder | The 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. |
509 | Framework Desktop | Builder | For 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. |
443 | Framework Desktop | Builder | Click&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. |
478 | Framework Desktop | Builder | The Q1 to Q4 Quarter Keywords can now be used between years 1990 to 2030. Whitout specifying the year, current year is used. |
467 | Framework Server | Web Portal | The 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). |
463 | Click&DECiDE | Setup | The 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. |
ID | Product | Component | Description |
---|
520 | Framework Server | Web Portal | When a scheduled task failed, now the status will display "Failed" instead of "Successful" under the Run Scheduled Task button. |
491 | Framework Server | NRFilterEngine | The 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. |
371 | Framework Server | Dashboard | A grid upadted with a report in Dashboard remains empty with Unicode characters in the Web Portal. |
450 | Framework Server | Web Portal | A scheduled task run from the Web Portal was not working under a Windows Server 2003. |
503 | Framework Server | Web Portal | Error 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. |
242 | Framework Desktop | Builder | The Refresh Table command was giving an error if one of the table was missing in the current query. |
417 | Framework Desktop | Builder | Builder did not display the real error message if an error occurred when adding a table that was not accessible. |
431 | Framework Desktop | Builder | Builder was using 2 connections on the port 7726 when retreiving a Query/400. |
455 | Framework Server | Admin Manager | Using 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. |
456 | Framework Server | Configuration Wizard | Click&DECiDE Administration Manager was not installed correctly if IIS was missing. |
460 | Framework Desktop | Builder | Click&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. |
461 | Framework Desktop | Builder | Click&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. |
466 | Framework Server | iSeries | Running 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. |
470 | Framework Server | Web Portal | When 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. |
471 | Framework Server | Web Portal | When 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. |
ID | Product | Component | Description |
---|
000 | Click&DECiDE BAI | All components | This new version 11 now supports UNICODE characters in all modules. |
000 | Click&DECiDE BAI | All components | This new version 11 now supports SAP Data Access. |
178 | Framework Desktop | BAI Engine | For several output formats, the Unicode option has been added (ASCII, Text, CSV, RTF, XML, WebQueries, XML Data, Databases). |
206 | BAI Server | Web Portal | Stopping 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). |
184 | Framework Server | Web Portal | Menu 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). |
404 | Framework Server | Web Portal | A new button in the Web Portal allows now to run a scheduled task without the need to go to the Server to do it. |
329 | Framework Server | Web Portal | When 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. |
288 | Framework Server | Migration | Click&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). |
213 | Framework Server | BAI Engine | A 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. |
271 | Framework Server | BAI Web Builder | If 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. |
429 | Framework Desktop | Builder | Some 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). |
ID | Product | Component | Description |
---|
138 | Framework Desktop | BAI Cube | A cube dimension can now receive several properties, for example the Customer Name dimension can have Address, City and Country as field properties. |
139 | Framework Desktop | BAI Cube | A 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. |
140 | Framework Desktop | BAI Report | A 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. |
142 | Framework Desktop | BAI Report | A 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). |
143 | Framework Desktop | BAI Report | When 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. |
144 | Framework Desktop | BAI Report | When creating a new Report from Raw Cube Data, the program now uses the cube column width for the report field size. |
181 | Configuration | BAI Wizard | When 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. |
193 | Framework Desktop | BAI Cube | Cube 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. |
194 | Framework Desktop | BAI Builder | Using the Click&DECiDE About command, you can now see what is your Authentication Mode, your User Name and the Windows Groups you belong to. |
179 | Framework Server | Admin Manager | When 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]. |
200 | Framework Desktop | BAI Report | New 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. |
201 | Framework Desktop | BAI Query | When creating a new parameter in a Query, you can now add this parameter in the Project Parameter with a button. |
220 | Configuration | BAI Wizard | When 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. |
245 | Framework Desktop | BAI Cube | A cube now proposes a new dimension including Month and Week at the same time, as well as the Day the Week. |
248 | Configuration | License | A temporary license certificate in now valid until the end of the limit date at 23:59:59 instead of 00:00:00. |
265 | Framework Server | BAI Web Builder | Web Builder only can use a "Connect" data source against the Web Server when using the Web Server license. |
296 | Framework Server | Admin Manager | The 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. |
346 | Framework Server | Web Portal | When a task exports the result to Excel or Excel 2007 output format, the .xls or .xlsx extension will be added automatically if not specified. |
350 | Framework Server | Web Menu Builder | For a Shared Folder, a new option allows now to hide empty directories. |
351 | Framework Server | Web Menu Builder | It is now possible to customize the icon displayed in a Menu for each item (Query, Report, Cube, Shared Folder etc.). |
ID | Product | Component | Description |
---|
317 | BAI Server | Admin.Manager | Administration 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. |
298 | BAI Server | Web Dashboard | A display problem occurred when a text field was containing numeric values beginning with one or several zeros. The zeros were not displayed. |
331 | Framework Server | Web Portal | When renaming a task, the modification is now reported into the scheduled tasks using this task. |
339 | Framework Server | Administration Manager | A backup of Administration Manager is now working fine under Windows 7 Professional SP1 64 bits. |
357 | Framework Server | Web Portal | A problem editing a task using a criteria including parameter with hidden first column has been fixed. |
384 | Framework Server | Web Portal | A 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. |
398 | Framework Server | Web Portal | Scheduled Task to Excel/Excel 2007 with the NNNN suffix was making a zero bytes file. |
ID | Product | Component | Description |
---|
175 | Framework Desktop | BAI Builder | Unable 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. |
176 | Framework Desktop | BAI Builder | The 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. |
180 | Framework Desktop | BAI Builder | If a parameter was defined without specifying the update method, it was not proposed at the query execution. |
183 | Framework Desktop | BAI Engine | If 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. |
185 | Framework Desktop | BAI Builder | Unable to close a Click&DECiDE Builder project file if you are opening a report in a Print Preview mode. |
187 | Framework Desktop | BAI Cube | On a cube, a filter on a character field does not support a value containing an apostrophe, like "Software's" for example. |
189 | Framework Desktop | BAI Builder | When exporting a query to Excel and if the font color has been modified, this color was not exported to Excel. |
190 | Framework Desktop | BAI Dasboard | Some objects like the chart had a display problem when using a command line that includes the program RunEbis.exe. |
195 | Framework Desktop | BAI Dasboard | A 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). |
197 | Framework Desktop | BAI Dashboard | An Image object would not accept a parameter in the path to an image file, such as "c:\my documents\" + Parameter + ".jpg". |
199 | Framework Desktop | BAI Engine | A 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. |
204 | BAI Server | Web Portal | If 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. |
207 | BAI Desktop | Builder | Unable to right click then "Edit" on a Excel chart object included in a Click&DECiDE report. |
208 | BAI Desktop | Builder | A criterion defined as "Included in the list" was not accepting empty value. |
210 | BAI Desktop | Builder | With Click&DECiDE Authentication, you lost the login information when opening a new session, which could give an error when opening a Web Dashboard. |
214 | BAI Desktop | Setup | Setup Wizard BAI: sometimes the check box to install the sample was selected but grayed out, making it impossible to uncheck. |
ID | Product | Component | Description |
---|
23 | BAI Desktop | Other | A Report Book sometimes was displaying the parameter input in several screens instead of a unique screen. |
102 | Framework Server | Secure | In 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. |
156 | Installation | BAI Desktop | The 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. |
160 | Framework Desktop | Builder | Report Templates: the Edit mode could make a GPF if the working window was too small. |
165 | Framework Desktop | Builder | Alerts: If parameters other than Input type exist, they were displayed with a duplicate name using the last visible one. |
167 | BAI Server | Other | Web 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. |
166 | Framework Server | Web Portal | Building 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""). |
168 | Framework Desktop | BAI Engine | Export 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). |
ID | Product | Component | Description |
---|
65 | Framework Desktop | BAI Engine | Parameter - New update method using a User or User Group Property defined in Administration Manager. |
74 | Framework Desktop | Builder | Support of Excel 2010 with Click&DECiDE. |
79 | Framework Desktop | Builder | Projects: the Builder Projects can now be opened using an "Execute Only" mode according to the license certificate. |
91 | Framework Desktop | Builder | The value 1000 for the TOP 1000 used when searching online values in the criteria dialog box is now customizable in Tools> Options> Query. |
94 | BAI Desktop | Other | Click&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. |
118 | Framework Desktop | BAI Engine | The "Click and DECiDE PDF Exp Printer" uses now the new Amyuni Converter PDF v4.00. |
129 | Framework Desktop | BAI Engine | Report: in a Highlight, you can now modify the static text of a 'Text' object using a condition. |
132 | Framework Desktop | BAI Engine | Report: 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. |
ID | Product | Component | Description |
---|
100 | Framework Desktop | BAI Engine | Query: 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. |
104 | Framework Desktop | BAI Engine | Export to Excel 2007: error when exporting data to cells in REPLACE mode. (Style error if the destination cell got already a predefined style). |
105 | Framework Desktop | BAI Engine | Export 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. |
124 | Framework Desktop | BAI Engine | Web Builder (.vvv file): creating a new project was not taking care about the Server license. |
127 | Framework Desktop | BAI Engine | Parameter: a false circular reference error has been fixed. |
131 | Framework Desktop | Builder | Value for a parameter starting with a blank (space): the blank value was lost when running the query. |
133 | Framework Desktop | BAI Engine | A Project Parameter changed from Disable to Enable was not changed in a query, staying still in Disable mode. |
134 | Framework Desktop | BAI Engine | The "Hide First column" option was modifiable from a query even if the Parameter was a Project Parameter. |