Futrix 6.0 Modification History of Bug Fixes, Changes and Minor Enhancements

Summary

VersionRelease DateWeb Server
Update Required
6 M03517 March 2011No
6 M03403 February 2011No
6 M03314 December 2010No
6 M0321 December 2010No
6 M03122 October 2010Yes
6 M03006 October 2010Yes
6 M02930 September 2010No
6 M02822 September 2010Yes
6 M02725 August 2010Yes
6 M02610 August 2010No
6 M0256 August 2010Yes
6 M02422 July 2010No
6 M02329 June 2010No
6 M02212 June 2010Yes
6 M02128 May 2010Yes
6 M0204 May 2010Yes
6 M01925 March 2010Yes
6 M0182 March 2010Yes
6 M01710 December 2009Yes
6 M01621 October 2009Yes
6 M01514 September 2009Yes
6 M01429 July 2009Yes
6 M01312 June 2009Yes
6 M01229 May 2009Yes
6 M01122 April 2009Yes
6 M01017 April 2009Yes
6 M00918 March 2009Yes
6 M00812 February 2009Yes
6 M00727 January 2009Yes
6 M00613 December 2008Yes
6 M00526 November 2008Yes
6 M00418 November 2008Yes
6 M0036 November 2008No
6 M00228 October 2008Yes
6 M00120 October 2008Yes

Details

Futrix 6 M035
Released: 17 March 2011

Web server update required: No

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix2View Detail Data: Derived Non-Display Measures Derived Non-Display measures were appearing in the "View Detail Data" output.
Bug Fix2Administration: Metadata Access Analysis Metadata Access Analysis screen in Admin client could incorrectly show that a User or a Security Group has access to a dimension in some circumstances.
Bug Fix2View Detail Data: Relative Filters An error could occur when trying to View Detail Data on the summary column of a viewpoint if the viewpoint had a relative filter and the actual filter value of the dimension did not exist in the data. This issue has been fixed with this release.
Enhancement2Exporting: Column Width in PDF report Column sizing in PDF exports have been significantly improved to minimize wrapping of measure values within a report cell. In the default CSS files used for export, property "white-space: nowrap" has been removed from classes associated with column header cells; it remains only on classes associated with measure value cells. This is the recommended configuration to take full advantage of the improved label-resizing functionality. If "nowrap" functionality is still desired for other cell types, this CSS property must be set using an override on the relevant CSS classes. In addition, changes have been implemented to avoid the wrapping of words within label cells, and to more effectively honor manually-inserted line breaks present in label cells.
Enhancement1Public Method: Get Meta-item Metadata Public method "get_metaitem_metadata" has been enhanced to take into consideration any variables that are not present in the physical data file before generating a list of available dimensions and measures.
Futrix 6 M034
Released: 03 February 2011

Web server update required: No

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix1Web Client: View Detail Data The View Detail Data screen could sometimes indicate a Java Script error and display no data if a user has no columns selected for display. This has been fixed by displaying all available columns if none are selected.
Bug Fix1Web Client: Between Operator in Filters An issue has been resolved with filters using a Between operator and based on a character dimension that contains values with leading spaces. The issue would occur only if the dimension had Formatted Grouping attribute turned off.
Bug Fix1Web Client: View Detail Data and Non-Display Measures An issue with Non-Display derived measures appearing in the View Detail Data screen has been fixed.
Enhancement1Futrix Display Window: UNIX Environment In several places within Futrix Administration a Display window appears displaying some information, which can be printed or copied into Windows clipboard. In a UNIX environment, printing or copy to Windows clipboard are not available from these windows, so it is now possible to instead print the contents of the Display window to the SAS log by setting an advanced macro variable futrix_copy_to_log_vs_clipboard.
Futrix 6 M033
Released: 14 December 2010

Web server update required: No

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix2Customization: Crash when using custom handles It was possible that Futrix could crash when using custom handles. This was an issue that only existed with Futrix 6.0 maintenance m032.
Futrix 6 M032
Released: 1 December 2010

Web server update required: No

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Enhancement2Executive Briefcase: Ability to set manual sort order of global menu items A new sorting type has been added for the Executive Briefcase Category Menu. Previously these could be sorted Alphabetically, and by Date (ascending and descending), but now it is also possible to control the sort order of specific menu items (by dragging and dropping them within the administrator Menu Items Management).
Enhancement2Executive Briefcase: Ability to impose sort order type on users Within the administration of the Executive Briefcase setup, it is now possible to control the default Sort Order Type, and it is also possible to impose the selected Sort Order Type on all users, so that they do not have the ability to change the sort order themselves.
Enhancement1Customization: New URL parameters to set Menu Group and to not honor Default Dashboard Two new custom URL Parameters have been added which can be used when invoking a Futrix Web session. "_set_menu_group=[menu-group-id]" can be used to load a specific menu group. "_dont_chg_mg_for_deflt_dashboard=1" can be used to ignore the user's default dashboard setting if their default dashboard is not in the current/specified menu group.
Futrix 6 M031
Released: 22 October 2010

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix2Static Publishing: PDF Table of Contents appears at back of document Fixed a bug in the logic around the Table of Contents generation which caused the TOC to be added at the end of the document under certain circumstances.
Bug Fix1Web Client: Menu Items Properties window not working If a web client end user requested the Menu Item Properties window, but the request took longer to complete than the time threshold for the Wait Page to appear, then the contents of this window "got stuck" on the Wait Page view and the user never saw the menu item properties that they requested.
Enhancement3Executive Briefcase: Improved Performance The end user performance of the Executive Briefcase has been improved significantly if the site user database has a large number of user groups.
Enhancement1Executive Briefcase: Ability to control the number of columns within the Category Menu A new attribute has been added to the Executive Briefcase setup that allows the Category Menu to be rendered in multiple columns.
Futrix 6 M030
Released: 06 October 2010

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Enhancement1Executive Briefcase: Ability to control "Always show in filters area" It is now possible to control whether the "Always show in filters area" dimension attribute is on or not specifically when a user is in Executive Briefcase mode. Therefore it is possible to have the filter selector always present in Executive Briefcase mode but not when in Standard Reporting mode.
Futrix 6 M029
Released: 30 September 2010

Web server update required: No

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Change2User Database Dataset Extracts: Change to Volume/Privacy Drill Control Variable In the "FutrixUsers" dataset that is created in the user database extract process, the "volumeControlLevel" variable has changed in a number of ways. It previously contained the wording of the level (e.g. "Low (Close to Detail Data)"), rather than the actual ID value of the level (e.g. "_LOW_") which it should have done. Due to this change, the variable's length has been reduced from $40 to $12, and it has been renamed to the more appropriate "privacyControlLevel". There are four possible values for this variable: _LOW_, _MEDIUM_, _HIGH_, and _UNLIMITED_
Enhancement2User Database Dataset Extracts: Improve Performance The performance of extracting all the user database details from Futrix into datasets has been greatly improved (i.e. using the "create_user_database_datasets" public class method). As this extraction process is now much faster, the previously conditional creation of datasets for the effective group membership of users and the effective roles of all groups are now always created. (i.e. the advanced configuration macro variable "futrix_create_extra_group_files" is no longer relevant as these datasets are now always created).
Enhancement2Formatted Grouping Change Management: Assess impact without actually changing the attribute The "Formatted Grouping Change Management" administration tool has been enhanced to enable administrators to report on what saved metadata exists for a dimension independently of whether the selected dimension currently has Formatted Grouping turned On or Off. Previously, to assess the impact of turning Formatted Grouping Off, it was necessary to actually make the change to the dimension before the reporting facilities could be used in this tool to see all saved metadata that used that dimension with Formatted Values stored.
Enhancement2Formatted Grouping Change Management: Dimensions using simple $N. formats For dimensions that use a simple $N. format, it is now no longer necessary to run the Formatted Grouping Change Management utility when turning off the Formatted Grouping attribute. Futrix will dynamically adjust any viewpoints using such dimensions at run-time. There are however two scenarios where it will still be necessary to run the change management utility for such dimensions: When the raw dimension values contain leading spaces, or when the raw dimension values were longer than the specified format length leading to truncation of dimension values as a result of applying the format.
Enhancement1Secure Static Content: Download PDF/XLS files into browser window When selecting PDF or XLS files to open within the secure static content (either Static Published content or from the Secure Directories) the user normally gets a dialog where they can choose to "Open or Save" the PDF/XLS file. This enhancement allows a site to remove this prompt and load the PDF/XLS file directly into the browser window. This change can be enabled by setting the new advanced configuration macro variables ("futrix_open_pdf_in_browser" or "futrix_open_xls_in_browser") to 1.
Futrix 6 M028
Released: 22 September 2010

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix1Export to PDF: Improved page rendering of exported dashboards Improved layout of viewpoint cells and filters when exporting dashboards to PDF. Previously, certain output could cause content to overflow across pages.
Bug Fix1Popmenu Manager: Incorrect Popmenu Preview in Admin Client Resolves issue where popmenu previews for calculated measure labels could also display popmenu commands relevant to dimension labels.
Bug Fix1Public API: Possible error condition if public method called before user has logged in Fixed an issue with the public method to retrieve user information ("get_current_user_info") which could throw an error if was called before the user logged in.
Change2Export to PDF: Improved control of the size and positioning of charts in PDF files Added a preference which provides the minimum size for chart rendering as a percentage of the page height of the exported PDF page. Where a chart cannot be rendered larger than this value on a page, it will instead be displayed on a subsequent page. This resolves an issue where limited space was available on a PDF formatted page, charts could potentially be rendered too small to be legible - especially in landscape orientated exports.
Change1Export to PDF: Improve default spacing in CSS attributes Fine-tuned the default padding and placement of data in table cells when exporting to pdf files.
Change1Export to PDF: Orientation when exporting a dashboard Resolved an issue that could arise if any of the viewpoints within the dashboard had a specific export orientation set. In this scenario these should have been ignored when the dashboard was exported as a single page (i.e. when "Export as Individual Reports" is not checked).
Futrix 6 M027
Released: 25 August 2010

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix2Exporting: Split Table/Chart Up/Down issues The width of the table is now correctly calculated for table-beside-chart and chart-beside-table viewpoint types in pdf export.
Bug Fix2Exporting: Error when exporting viewpoints with large filters Fixed an issue that caused an error when a viewpoint with a filter containing large number of values was exported.
Bug Fix2Web Client: Multiple sessions across different browser windows and tabs Previously when a user had multiple Futrix sessions open across different browser windows or tabs the user would occasionally get "Request Cancelled" or "Concurrent Requests" errors. This should now be addressed, so that it should now be possible to run multiple-sessions of Futrix in a browser concurrently. To do this it is important to actually start a totally new Futrix session in the new window/tab, and not create the new session by using Ctrl-N (which duplicates the current URL in a new window) or by copying a "mid-session" URL into the new window, otherwise there could still be issues between the two session.
Bug Fix1Menu Items: Move Menu Items Fixed a Javascript bug that caused issues when moving menu items in Web client.
Bug Fix1Dashboards: Synchronized Filters Synchronized Filters on dashboards are now picked up from the first visual cell on the dashboard, rather than the first created cell.
Bug Fix1Help: Errors on Help About Data page Suppressed error messages on Help About Data page if libraries were not assigned.
Change1Exporting: Ignore blank dashboard cells when exporting a dashboard When exporting a dashboard as individual reports, if there was an empty/blank dashboard cell then previously this would have created a blank page. These blank dashboard cells are now ignored.
Enhancement2Administration: Ability to Filter Values within any Popmenu Window The popup menu utilized within the Futrix Administrator has been enhanced to allow the values to be filtered down to a subset of values of interest, by allowing administrators to provide some text to filter on before displaying the popmenu. If using the hierarchical (expandable) mode for the popmenu (used via the "futrix_expandable_deskt_popmenus" and "futrix_expandable_popmenu_thresh" configuration macro variables) then the filter dialog also gives the ability to "Apply filter to group names and keep all children". The threshold that controls when this filtering option is available is set via the "futrix_filter_popmenu_thresh" configuration macro variable (default = 100).
Enhancement1Exporting: Cosmetic Issues with Spacing & Layout The viewpoint title is now included as part of the 'Continued...' text heading when exporting a single viewpoint and it overflows onto subsequent pages.
Enhancement1Security: Changes to the Security Admin Window Size Role and Sub-Group list boxes were made bigger in the Edit User Group window, and the Edit User window is now resizable so that the list boxes for Group Membership and Roles can be made much bigger. The Edit Security Roles window is also now resizeable.
Enhancement1Exporting: Formatting changes in dashboard export to PDF Enhanced positioning and title placement of dashboards when exported to PDF.
Enhancement1Security: Public method for retrieving logged in user details Improved performance of public method for retrieving the currently logged in user information.
Enhancement1Metabase: Ability to ignore duplicate dimension labels Added "Ignore duplicate labels" dimension attribute. When set, the check for duplicate dimension labels will not include this dimension and will therefore allow it to have a duplicate label.
Futrix 6 M026
Released: 10 August 2010

Web server update required: No

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Enhancement2Exporting: Improved image scaling Image scaling and placing of charts has been improved during exporting.
Enhancement2Administration: Secure static content Secure Static Content administration has been enhanced to allow the administrator to provide description for the Static Contents directory.
Futrix 6 M025
Released: 6 August 2010

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix3Aggregate Filters: Misalignment of values on the rendered viewpoint When aggregate filters with "All Other Values" grouping were used on a report, in combination with nested column dimensions, the values displayed on the rendered viewpoint could be mis-aligned to the wrong columns.
Bug Fix2Export to Excel: Office 2003 issues After a viewpoint is exported to Excel 2003, making formatting changes and attempting to save the spreadsheet could cause Excel to crash. This was due to an issue in Excel 2003, a workaround for the issue has been implemented in this release.
Bug Fix1Filters: HTML encoded characters visible. When moving simple filters to a complex filter structure, HTML encoded special characters were sometimes visible.
Bug Fix1HTML table alignment Fixed an issue with table header alignment when fixed headers were turned on.
Enhancement3Export to PDF: Insufficient space handling If a table does not fit into allocated space during dashboard export to PDF, then a message is displayed in its place (as in previous maintenance releases), but the table will now also be printed on the pages that follow. The message displayed inside the exported dashboard cell defaults to "Table does not fit into available space, item will be displayed on subsequent pages". The futrixweb property "futrixreportml.table-too-big.text" can be used to customize this message.
Enhancement3Export to PDF: Sizing and justification of tables Tables exported to PDF are no longer created at 100% width of the page, but instead rendered at their required size. The position of the table on the page is controlled by "text-align" property of the CSS class FutrixViewpointArea in the style sheet used for export.
Enhancement3Security: Ability to secure static content Added ability to secure static content, which may include output from Futrix static publisher, or any other external files such as documentation, reference material, etc. These types of content can now be set up so that Futrix authentication will be required to access them. Futrix security restrictions for limiting access to various security roles and/or users will also be honored. Refer to documentation for more details.
Enhancement2Export to PDF: Long subtitles When exporting to PDF, viewpoint sub-titles that ran into multiple lines were not being line-wrapped optimally; for example where there are Filters with a large number of values.
Enhancement2Export to PDF: Control over dimension/measure label wrapping Split characters for dimension and measure labels, as configured and used in the Futrix metadata, will now be honored during exports to PDF.
Enhancement2Export to PDF: Control over dimension value wrapping Two new options have been added to control wrapping of long dimension values when exporting to PDF. These options can be used to independently specify the maximum line length of dimension values for row dimensions and column dimensions. These options can be set globally or overridden at user/viewpoint/dashboard levels. When used, line breaks will be inserted within the dimension values at or before the maximum line length.
Enhancement2Export to PDF: Improved column width handling Table column size during PDF export is now determined by a CSS property "white-space", which could be set to "nowrap" or "wrap". To take advantage of this enhancement, the white-space property must be added to the following CSS classes in the style sheet used for exporting: colDimLabel, colDimVal, colMsrLabel, colSmryLabel, rowDimLabel, rowDimVal, rowMsrLabel, and rowSmryLabel. When there is sufficient available space on the page, this property will be honored when sizing the columns of the table. If there is not enough space for all the columns to appear, then wrapping will be turned on for all columns to fit them on the page and a footnote will be added to the viewpoint indicating that wrapping has been turned on.
Enhancement2Exporting: Metaitem level sub-titles It is now possible to configure metaitems to have additional text that will be included as sub-titles during exporting or static publishing of the viewpoints based on this metaitem. The sub-title text is configured in Edit Metaitem screen on Misc2 tab, it can contain macro variables.
Enhancement2Static Publishing: Dashboards as reports It is now possible to configure the "Export dashboard as individual reports" option for specific dashboards within a Static Publishing group. This option is located in Static Publishing -> Static Publishing Setup Management -> (select group) -> Edit -> Dashboards and Viewpoints to be published.
Enhancement2Exporting: Page orientation It is now possible to specify the desired page orientation during export to PDF in the Web client during the export. Page orientation on the export screen defaults to the orientation specified for the viewpoint/dashboard, or to the user preference, but can be overwritten during the export.
Enhancement1Customization: Executive Briefcase access New public methods check_access_to_exec_mode and check_access_to_std_mode have been added to see if the current user has access to the Executive Briefcase and the Standard mode respectively. Refer to the Customization Reference for additional information.
Enhancement1Administration: Metadata Access Analysis It is now possible to configure "Metadata Access Analysis" in "Security and User Management" to use previously extracted user database instead of the live security data. This will allow to significantly improve performance of that screen for sites with very large user databases. Please contact futrix support for details.
Enhancement1Customization: User Database Extract A new column containing the date that user passwords were last modified has been added to the futrixUsers dataset generated via create_user_database_datasets public method.
Enhancement1Filtering ability with desktop client popup menu When using popup menus in the desktop client, and if the size of the list was too large, SAS limitations made the popup selector unusable. Added a mechanism to filter the list of values by name, so that the size of the list can be made more manageable, thereby circumventing the SAS limitation.
Futrix 6 M024
Released: 22 July 2010

Web server update required: No

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix3Charting Issue with "Use the Table Column Dimension for the Chart Classification Dimension" attribute If the viewpoint attribute of "Use the Table Column Dimension for the Chart Classification Dimension" had been overridden to be On, and the user had created a table and chart view within the same viewpoint, and they had both row dimensions and column dimensions specified in the table, and they were sorting the table by a particular column, and they were viewing a line or bar chart, then there may be problems displaying all of the information in the chart.
Bug Fix3Dashboard orientation attribute was not being honored in export The dashboard orientation attribute was not being honored in export, this is now honored correctly.
Futrix 6 M023
Released: 29 June 2010

Web server update required: No

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix3Menu: Viewpoints displayed on the main menu Resolved an issue where the application of subject and meta-item level security was not correctly graying-out or hiding menu items on the main menu. Note: Security was still maintained in that users were unable to run these viewpoints/dashboards however.
Bug Fix3Exporting Debugging: Issues with large debug log lines Exporting was failing in some circumstances due to SAS being unable to handle log lines greater than 132 characters. The log line is now split over several lines if it is greater than 132 characters.
Bug Fix3Exporting: Missing values in Detail Data Exporting to PDF would fail if it encountered a SAS missing value (denoted by a ".") as it was not setting the PDF content correctly. The content is now correctly set to a blank ("") value.
Bug Fix2Stored Cache: Library Assignment Libraries that were set to be assigned when needed were not getting assigned when stored cache was being built.
Bug Fix2Security: User Group Heirarchy Leading spaces in the names of user groups caused the group heirarchy to be displayed incorrectly in certain situations.
Bug Fix2Synchronized Measures in Dashboards Resolved an issue using dashboards with Synchronized Table or Chart Measures and the dashboard contained a mix of tables and charts where some unexpected results could occur with the currently used measures. Changes to the table measures no longer affect the currently used chart measures and vice versa when using the synchronization of measures.
Bug Fix2Promotion Control: Pre and Post Library Handle Use If Custom Handles were under Promotion Control, and the "Set Custom Libraries (pre/post)" handles were being used, then these were not always be executed at the expected promotion level when a user changed between different levels. Also when making changes within the "Dev/Test/Prod Promotion Setup" administration window, some of these changes weren't being refreshed fully in memory until the administrator logged out and back in again (all changes are now refreshed as soon as the administrator returns back to the Adminitration menu).
Enhancement2Checks for unprintable control characters in reach-through output Futrix now gracefully handles unprintable control characters from the detail data that are included within the reach-through "View Detail" data extracted by a user. These control characters are removed from the table shown within the browser window (as they could cause unexpected results if the browser tried to display them). If a user exports or downloads a CSV file of the extracted detail data, the control characters will be encoded into a form that they are readable but won't cause any problems in the exported/downloaded results.
Enhancement1Persistent Errors in Tomcat Logs When the user closed their browser prior to receiving a response it created a nasty-looking long exception trace in the log file. The stack trace is harmless but can be confusing. The raised exception is the Catalina 'ClientAbortException', this is now caught and a simple info-level message is logged instead.
Enhancement1Export Debugging: Return FRML to user If a user export failed from the web client environment and they received a error message saying that the export failed or a "No Content Generated" error, there was previously no easy way to get the FRML that was used for the export process. If the client session is now in Export Debugging Mode then the export process will still return a zip file with all the source files that were used for the export process even though the export failed.
Enhancement1Security Management: Control whether new user groups are restricted by default A new security attribute has been created which provides control of whether new user groups should be restricted by default or not. Previously in Futrix 6 user groups were not restricted when a new one was created, and this will remain the case for existing installations. This attribute can be changed within: Futrix Administration > Security and User Management > General Security and User Settings > General (tab).
Futrix 6 M022
Released: 12 June 2010

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix2Exporting from "View Detail Data" to Excel There was an issue exporting the "View Detail Data" (reach-through data) to Excel. In rare circumstances character values were being misinterpreted as numeric values which could cause a problem during the export. This problem is now fixed so that any columns in the detail data that were character are always treated as character within Excel (and are now also left-aligned).
Enhancement3Static Publishing: Ability to create HTML Content and "Single File" output in one job It is now possible for a single Static Publishing Group to create both HTML Content and also create output in "Single File" format (e.g. a PDF file with a Table of Contents and all reports added to the single file). This enhancement also now allows for a single job to create HTML Content and also publish to export destinations that are not available via HTML (such as *.txt files).
Futrix 6 M021
Released: 28 May 2010

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix2Cube Building: Long Variable Names Fixed an issue when variable names used by multiple measures with different statistics were longer than 25 characters in length.
Bug Fix2Performance: Futrix Indexed Datasets Fixed an issue with Futrix Indexed Datasets and SAS OLAP cubes with Futrix Created Aggregates, that caused the n-way sub-table to be used for all queries, impacting performance. This issue occurred when the source data for the cube was registered in the SAS Metadata Server.
Bug Fix2View Detail Data: Measure Labels Fixed an issue in the View Detail Data screen, to ensure that multiple measures using the same source data variable with different statistics appear consistently between the list of available columns and the table with the detail data.
Bug Fix2Exporting: PDF Exports Fixed issue that prevented document header from being displayed for PDF exports in landscape orientation.
Change3Static Publishing: Menu Item Restrictions The logic for the population of the menu of Static Publishing output has changed. Previously the menu would include all items that were defined within the Static Publishing Group metadata, and any items that were not accessible to the user that was doing the publishing would either create an error, or would create a blank report. This has now changed so that the menu will now only include the items that the user (who is doing the publish) would normally see within the interactive environment.
Enhancement3Exporting: Performance of Large PDF Exports The memory requirements and performance of exporting very large tables to PDF has been significantly improved.
Enhancement2Performance: Count Distinct and Filtered Measures Performance has been improved when using Count Distinct and Filtered Measures within the same report, and where the primary query can be satisfied from cache, but additional Count Distinct Measures are needed to be calculated.
Enhancement2Exporting: PDF Export Column Sizing Added "best-fit" algorithm for PDF export table column sizing. This algorithm sizes columns proportionally to their content (considering the widest cell in each column).
Enhancement2Logging: Control for SAS tier logging The SAS-Tier logging is now configurable in the futrix properties file using the com.futrix.SASLOG property
Enhancement2Web Activity Manager: Pending Responses Pending responses that have been sent but not cleared will now be purged after a configurable amount of time. Please refer to documentatrion for further details
Enhancement1Cube Building: Exclude Based on Last Build Enhanced the "Add based on last build" screen in the Cube Attributes, to automatically deselect any of the selected rows after the "Exclude" button is pressed.
Futrix 6 M020
Released: 4 May 2010

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix2Customization: Wait Page Resolved an issue that prevented custom Wait Page code from executing properly.
Bug Fix1Web Client: Measures Formatted as Dates An issue with mis-aligned column headers when Fixed Headers were on has been fixed. The issue would occur if a viewpoint had a measure formatted as a date.
Enhancement2Exporting: Images Futrix PDF export now honors PPI (aka "DPI") metadata in image files used for header background images. This makes it easier to use high-quality logo images in the PDF header.
Enhancement2Customization: New Handle A new custom handle has been added that will run before any of the top-level pages in Futrix are rendered. There are currently four (4) top-level pages: Home page, Executive Categories page, Executive Category page and the standard Main Menu page. The first three are only available if Executive Briefcase is enabled.
Enhancement2Static Publisher: Running the Same Batch in Parallel Static Publisher allows running different static batches in parallel. With this release it is now also possible to run the same batch in parallel, as long as each instance is using a different location for output. In order to run static batches in parallel macro variable futrix_sp_override_keep_history must be set to 0.
Enhancement2Customization: Executive Briefcase A new command CMD_HOME_PAGE has been added, which allows the Administrator to add an item to the Toolbar or Pull Down Menu to allow the user to go back to the Home Page when they are in the Standard Mode. This command is only relevant when Executive Briefcase is enabled and the user is in the Standard Mode. When adding this command to the User Interface it is recommended to enable "Hidden when not relevant" option.
Enhancement2Administration: User Security In UNIX environments SAS could lock catalogs that are being read by one process and written by another. For example, in environments with a very large number of users saving changes in the Security and User Management could fail due to a SAS lock that is created by a web process reading the security catalog during user login. To prevent this, the Administrator can configure a new advanced macro variable futrix_keep_trying_lock_time with a number of seconds, this will instruct Futrix to re-try saving of the catalog in case of a failure and keep trying up to the number of seconds specified.
Futrix 6 M019
Released: 25 March 2010

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix1Administration: Promotion Management When Futrix Promotion Management is enabled, the "Current Status Overview and Promotion" screen allows administrators to view and promote changes only for subjects and menu groups to which they have administrator level access.
Enhancement3Static Publishing: By-Group processing An enhancement has been added to the Static Publishing processing with By-Groups. It is now possible to query the by-group dimension dynamically from the data during static group processing vs. having to select all the values during the set up. Also, the by-group dimension and its values are added to the dataset optionally created during static group processing to indicate which of the generated files correspond to which by-group dimension value.
Enhancement2External Security: Migration to SAS 9.2 For sites that utilize SAS Metadata Server for External User Database within Futrix, upgrading to SAS 9.2 and migrating security groups from SAS 9.1.3 installation into SAS 9.2 will change SAS internal group IDs. Futrix uses the internal SAS IDs to recognize the external groups, and normally after such an upgrade Futrix will see all external groups as new, which will prevent the users from accessing group shared reports saved in the SAS 9.1.3 environment. A new parameter has been added to the batch job used to synchronize external user database that will allow the newly migrated groups to be recognized as existing groups based on their name rather than ID. Contact Futrix Support for more details.
Enhancement1Administration: Default setting for Allow multiple selection An advanced macro variable futrix_allow_multi_select has been added that allows the site to define the default setting for "Allow multiple selection" checkbox in the pop-up menu used in Futrix Admin client within user and group security management as well as other areas where a selection of items from a list is necessary. Setting the macro to 1 will make the checkbox to be checked by default.
Futrix 6 M018
Released: 2 March 2010

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix1Charting: Horizontal Bar Multiple Measures It is now again possible to produce a multiple measure horizontal bar chart using SAS/Graph charting engine.
Bug Fix1Web Client: URL menu items A bug preventing the use of a very long URL string in the Web URL menu item has been fixed.
Enhancement2Alert Processing: Alerts for a specific user Administrator can now process alerts for a specific user by setting futrix_alert_user_id macro variable inside the alert processing batch program to the Futrix username of the user. If the macro is not set, alerts for all users will be processed.
Enhancement2Customization: Exports and Static Publishing In is now possible to customize exports (interactive or static publishing) to include images and/or text in the header or footer of the page. The images and/or text can be right, center or left justified. To add images the export CSS can be altered to add background-image property to .FutrixHeader or .FutrixFooter class. To add text to the header or the footer of the page the following macro variables can be set respectively: futrix_export_header, futrix_export_footer.
Enhancement1Administration: Futrix Indexed Datasets During creation of Futrix Indexed Datasets it is now possible to default the "Files Prefix" to the Meta-Item ID with an underscore, to ensure that each cube has a unique file prefix. This can be turned on by setting an advanced macro variable futrix_ids_prefix_use_meta_id to 1.
Enhancement1Web Menu: Ability to hide Generate URL option Administrator can prevent the "Generate the URL link for this item..." option from appearing on the pop-up menu by setting advanced macro variable futrix_hide_viewpoint_url to 1.
Enhancement1Indexed Datasets: Record Count During building of Futrix Indexed Datasets a table is created that contains record counts for each sub-table. It also includes source record counts of the sub-table that this sub-table was built from. Previously if the sub-table was built from the source data (and not another sub-table) the source record count was not populated. With this release source record count is populated for all sub-tables. This count can also be seen in the "Add based on last build" screen in the "Excludes" window of cube attributes.
Enhancement1Cube Building: Secondary data out of date If a user tries to run a viewpoint based on a data source that uses secondary data (i.e. a cube), and Futrix determines that the source data of the cube has been refreshed since the cube was last build, normally the user will be given a warning message but the viewpoint using the obsolete cube will still be produced. With this release, an Administrator can set an advanced macro variable futrix_stop_scndry_out_of_date to 1, to instead give a user an error message and prevent the display of the viewpoint.
Enhancement1External Users: User ID Suffix If an External User database is used within Futrix, particularly SAS Metadata Server, it is now possible to alter the user ID entered by the user by adding a suffix to it before the user is authenticated. This might be useful when a site domain needs to be a part of the user ID for proper authentication. The suffix can be specified by the advanced macro variable futrix_sasmds_user_suffix, and then the end users would not have to enter it during the login.
Futrix 6 M017
Released: 10 December 2009

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix2Charting: Geo charts performance on UNIX On some UNIX systems geographical charts might take a long time to render. This is due to missing hardware fonts in those environments. To work around the issue, the administrator could either specify an existing font to be used by SAS/Graph for Geo charts, by setting an advanced configuration macro futrix_sas_graph_font. Alternatively, one can set futrix_sas_graph_nocharacters advanced configuration macro to 1, to let SAS/Graph know to use simulated fonts rather than the hardware fonts. Only one of these macros should be set at a time, if futrix_sas_graph_nocharacters macro is set, the futrix_sas_graph_font macro will be ignored. The fonts are used for the legend text in the Geo chart.
Bug Fix2Exporting: PDF Pagination Some viewpoints that contain very long rows due to multiple nested row dimensions could have missing rows when exported to PDF.
Bug Fix2Filtering: OLAP Cubes A general error could occur when adding a filter to a viewpoint based on a SAS/OLAP data source. This could occur when the filter was based on a dimension that had a long variable name and a long format name.
Bug Fix1Security: Generic login error message For security purposes, a new advanced macro variable futrix_same_failed_login_msg has been added. When this macro is set to 1, the error message that the user sees when trying to login after their account has been deactivated, will be a generic message about invalid login and will not specifically tell the user that the login failed due to the account being inactive.
Bug Fix1Web Client: JavaScript code in URL Additional validation has been added to URL parameters processed by Futrix to ensure that a malicious user cannot change them to run external JavaScript code.
Bug Fix1Admin Client: Cube Optimization screen Small improvements were made to the layout of the Cube Optimization screen in the Admin client to prevent it from crashing in some environments.
Bug Fix1Web Client: Global and Group Menu Management When global or group menu is maintained via the Web Client, and the user attempts to move a menu items into a newly created folder, the folder was not appearing on the list of available folders unless it was first saved.
Enhancement2External User Database: Filtering on groups and users In the environments that use an Open LDAP or Microsoft Active Directory for external user database, it is now possible to specify filters for users and groups to be imported into Futrix.
Enhancement2Web Client: Increased Security Several enhancements have been made to the way Futrix web sessions are established and handled, to make a web session more secure from malicious attacks.
Futrix 6 M016
Released: 21 October 2009

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix2Alert Processing: Group Shared Viewpoints User personal alerts would not be processed if the user had alerts only on group shared viewpoints.
Bug Fix1Customization: Wait Page There was an issue with implementing a custom "Wait Page" functionality, which is now corrected.
Bug Fix1Stored Cache Processing: Personal Reports Stored Cache processing would generate error messages in the SAS log about personal viewpoints. The messages should not have been generated. This issue affected the logging side of the process, the actual cache processing performed correctly.
Bug Fix1Web Client: Help About Java on UNIX systems "Help About Java" screen was not working properly on some UNIX systems.
Bug Fix1Web Client: Right-Click Menu Commands Sometimes selecting a command from the right-click pop-up menu on a dimension in a table would produce an error message saying that command cannot be performed because nothing was selected.
Futrix 6 M015
Released: 14 September 2009

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix2Cube building: Editing "Depth" attribute within UNIX operating systems When building and maintaining cube structures within Futrix on a UNIX operating system, in some cases the "Depth" attribute within the "Inclusion and Exclusion Logic" may not have been editable. The slider that changes the "Depth" attribute could become frozen. In this maintenance for UNIX operating systems, the "Depth" can be set via an entry field instead of the slider.
Bug Fix2Exporting: Logging from Exporting Engine On some systems export might fail due to long lines being logged by the Exporting Engine. In this release the lines are being wrapped to correct this issue.
Enhancement2User Maintenance: Improved Performance Performance of User Database Management has been improved for sites with a very large number of User Groups maintained in the hierarchical view. Also, the time of the initial login for a user with a SuperUser role has been improved if the site has a large number of User Groups.
Enhancement2Futrix Distribution: Separate downloads for SAS 9.2 To reduce the size of the Futrix distribution files, there are now separate files available for download for SAS 9.1 and SAS 9.2 installations. Also, for sites installing Futrix on a 64-bit Windows system, there is now a separate download available of the Futrix SAS Server component in the transport file format.
Enhancement1Indexed Datasets: Macro names Renamed macro variables used during the building of Futrix Indexed Datasets to not contain the word _error_. The old names might have interfered with SAS log scanners.
Enhancement1Exporting: Logging Number of Records Futrix server side log now contains information about the size of the viewpoints or detail data being exported by the users. It can be used by an Administrator to analyze the amount of data being exported. There are Preferences available to limit the size of data being exported by a user: "Maximum Records for Viewpoint Export" and "Maximum Records for View Detail Data export/download". The values of these preferences are also included in the log. By default the preferences are set to allow unlimited size exports.
Futrix 6 M014
Released: 29 July 2009

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix2Customization: Custom IDs not being set for menu items Changes to the Custom ID of viewpoints and dashboards within Menu Item Management were not being saved in all cases.
Bug Fix2Alerts: Alert email with SAS/IntrNet In SAS/IntrNet environment, an email sent to the user about an active alert could have had a truncated viewpoint/dashboard name in the URL link to the viewpoint.
Enhancement2Futrix WEB: SAS 9.2 Integration Futrix Web has been updated with SAS 9.2 Integration Technologies components. A separate war file called futrix6-sas92.war is now included in the futrixweb_sasit_v6mNNN distribution file. The original futrix6.war, which should be used in SAS 9.1.3 environments, is included in the distribution file as well.
Enhancement1Security: Passwords AutoFill Autocomplete of passwords on login page has been turned off.
Enhancement1Web Client: URL generation A new advanced configuration macro futrix_no_port_in_gen_url has been added. If set to 1 it will prevent the port number to be added to the URL that gets generated by Futrix when the user asks to generate the URL link for a menu item. This might be helpful in certain environments where port redirection is used.
Enhancement1Web Client: Tracking Analysis A new advanced configuration macro futrix_hide_return_to_console has been added. If set to 1 it will prevent the Return To Console button from appearing when accessing Admin Analysis viewpoints via direct URL (e.g. Tracking, Metadata, User Security, Menu Analysis). Usually those analysis areas are accessed via the Web console and the button is appropriate, but some sites might choose to provide direct URL access to the users who do not need access to the console, in which case the button is no longer needed.
Futrix 6 M013
Released: 12 June 2009

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix2Remote Admin: Export Styles This release fixes the issue with adding custom export styles when using Remote Administrator.
Bug Fix2Web Client: Adding Calculated Measures or Calculated Dimension Values Edit Calculated Dimension Values and Edit Calculated Measure screens were not populating properly due to the bug introduced in M012. The issue is corrected with this release.
Enhancement2Administration: Data Volume Control Additional enhancements were added to the Volume Control functionality, including automatic addition of the Volume Drill Control Aggregate Measure filter to the viewpoint in order to prevent the users from accessing detail data that they are not authorized to see.
Futrix 6 M012
Released: 29 May 2009

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix3Web Client: SAS/IntrNet with UNIX Futrix 6.0 with SAS/IntrNet on some UNIX systems might not work when SAS generates Session IDs that contain special characters. This release addresses this issue.
Bug Fix2Exporting: Banding Dimensions Banding dimensions that use both numeric and non-numeric characters in the formatted value could have caused an error during export to Excel. This release addresses this issue.
Bug Fix2Administration: Cube Optimization The cube optimization process could fail with an error in the log, which is fixed in this release.
Bug Fix2Web Client: Charts Clicking on chart icons could have produced an error if the "Fit Charts to Available Space" user preference was set to OFF.
Bug Fix2Administration: Futrix Indexed Datasets Build Building of the Futrix Indexed Datasets could fail if multiple builds writing to the same library are running at the same time. This issue is fixed with this release.
Enhancement2Administration: Metadata Access Analysis Additional checks have been added to the Metadata Access Analysis screen to better handle deleted metadata.
Enhancement2Administration: Cube Building Build Dimension Groupings editing screen in the Inclusion/Exclusion window for Secondary Data Sources has been modified to allow resizing of the screen for easy maintenance of a long list of dimensions.
Enhancement2Administration: Cube Building and Compression A new advanced configuration macro variable ("futrix_use_binary_compress") can be set to force the use of binary compression instead of the default character compression when building Futrix Indexed Datasets or SAS OLAP Server Cubes with Futrix Created Aggregates. This macro variable only affects data sources that are set to use compression in Secondary Data Source Attributes. Note, SPDE libraries do not support binary compression, and if a SPDE library is used for secondary data storage, then character compression will be used even if this macro variable is set.
Enhancement2Web Client: Promotion Management With this release the promotion level chosen by the user in the Web session is now stored within the session and does not affect other web sessions for the same user, so different promotion levels can be used in different sessions.
Enhancement2Web Client: Session Clean-up Additional cleaning up of open SAS threads has been added to limit the number of open threads and memory utilization, to avoid "out of memory" errors in SAS Portal within a Single Sign On environment.
Enhancement2Custom Attributes: Menu Items, Meta-items, Dimensions and Measures Changes have been made to the way meta-item, dimension and measure custom attributes are saved within dashboards and viewpoints if they have been altered within the run-time environment. Also the previous concept of report custom attributes has been replaced with a new concept of the menu item custom attributes. Refer to the Futrix Customization Reference for details.
Enhancement2Web Client: Main Menu Performance The Main Menu in the web client was modified to improve performance when it contains a very large number of menu items.
Enhancement2Web Client: Data Dictionary Hover New advanced configuration macro variables ("futrix_suppress_data_dict_hdr" and "futrix_suppress_addl_notes_hdr") were added. If these macro variables are set to 1, the corresponding heading before the data dictionary text and/or additional notes in the viewpoint cell hover will be suppressed.
Enhancement2Web Client: Euro Currency Conversion Euro Currency Conversion functions have been removed from "Edit Calculated Measure" and "Edit Calculated Dimension Values" windows. A new advanced configuration macro variable ("futrix_show_euro_conversion") was added. If set to 1, the euro currency conversion function selection will become available.
Enhancement1Data: Special Characters Viewpoint could error out if a dimension in the data contains a single tilde character. This character has a special meaning within Futrix. With this release a new advanced configuration macro variable is available ("futrix_other_vals_char_constant") to change what character is used by Futrix instead of tilde.
Enhancement1Administration: User Management In the "User Administration" screen the search text that filters the list of displayed users could get cleared if the newly added user would not be visible due to the current search criteria. With this release, the search text is no longer cleared.
Futrix 6 M011
Released: 22 April 2009

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix3Exporting: Chart Exporting There was an issue with exporting charts that got introduced with the M010 release, it has been fixed in this maintenance release.
Change1Installation: UNIX Demo Installation Installation program (install.sas) included in the Futrix maintenance distribution for UNIX has been modified to only install the maintenance release, the installation program included in the Demo release will install the Futrix release as well as the demo data.
Enhancement1Administration: Metabase Management Additional checks and clean up for missing dimensions and measures have been added in Metabase Management Administration screen.
Enhancement1Charting: Multi-Measure Chart Axis Details Additional checks and user-friendly messages added to the Chart Axis Details screen to make it easier to use.
Futrix 6 M010
Released: 17 April 2009

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix3Web Client: Column Sizing with Nested Dimensions Column sizing in the web client could have been a little bit off when Fixed Headers preference is On and multiple nested dimensions are used in the viewpoint layout.
Bug Fix2Exporting: Missing Values in View Detail Data Export An error might have been generated when exporting to Excel from View Detail Data window if some measures only had missing values.
Bug Fix2Exporting: Negative Numbers Formatting Negative Numbers used to appear formatted as text when exported to Excel, which would prevent them from being used in Excel formulas. With this release all numbers exported to Excel are formatted as numbers.
Bug Fix2Exporting: Special Characters in Dimension Formats An error might have occurred during Export to Excel if a dimension was formatted and the formatted value contained plus or minus sign at the end of the string.
Bug Fix2Charting: Multi-Measure Charts and 3D Preferences Multi-Measure charts 3D preference was not honored for bar charts. With this release the 3D appearance of a multi-measure chart is controlled by either Bar Style preference if it is a bar chart or by the Line Chart Style preference if it is a line chart. On a multi-measure chart it is possible to override a particular measure to be a line or a bar, but the 3D appearance of the entire chart is controlled by the preference for the original chart type.
Bug Fix2Charting: Measure Order in Chart Legend Measure order in chart legend of a multi-measure chart was not the same as the order on the chart itself. In this release the order of measures on the chart and the legend is consistent with the order specified in the Chart Axis Details window.
Bug Fix2Web Client: Use of JavaScript in Folder Names Use of JavaScript code or other embedded HTML in the name of a personal folder used to cause JavaScript errors on the page.
Bug Fix2SAS/IntrNet: Upgrading to Futrix 6 Upgrading a SAS/IntrNet Futrix environment to Futrix 6 could have produced errors when accessing Web client.
Bug Fix1Alert Processing: No Alert Processing Groups If Alert Processing is attempted before any Alert Processing Groups have been defined, there was an error message generated in the log that was not clear about the cause of the failure. In this release a new error message clearly states that no Alert Processing Groups are defined.
Enhancement3SAS 9.2 Certification Starting with this release Futrix 6.0 is certified to run on SAS 9.2.
Enhancement2Exporting: Filtered Measures in Raw Data Format Export Filtered and Custom measures are now included when Exporting to Raw Data Format.
Enhancement2Administration: SAS/Access Data Source Engine Passwords entered on the SAS/Access Data Source Engine edit screen are now masked with asterisks.
Futrix 6 M009
Released: 18 March 2009

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Enhancement2Administration: Enhanced Macro Variable Resolution Macro variable resolution was added to some additional areas within Futrix: menu group labels, user notes, data dictionary, menu item labels, custom viewpoint footnotes. A special macro variable metaitem_label defined within Futrix is now available for use in menu item labels.
Enhancement2Cube Building: Improved Error Handling Error handling improved in the administration of OLAP Cubes and Futrix Indexed Datasets when adding sub-tables to be excluded based on the last build.
Enhancement1Samples: Prompting Filters A new entry added to the futrix.samples catalog containing an example of a customization that implements prompting filters.
Futrix 6 M008
Released: 12 February 2009

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix2Static Publishing: Excel formats Previously, if several viewpoints were exported as part of a Static Publisher into a single Excel Workbook, Excel could generate an error about too many cell formats being used. This release fixes this issue.
Bug Fix2Charts: Handling of completely enclosed areas Hover text displaying over fully enclosed areas on map charts is now properly handled. Previously, the enclosed area's hover text would display the surrounding area's information.
Bug Fix2Web Client: Resolution of Macro Variables Macro variables can be resolved within viewpoint titles, and the predefined macro variable "metaitem_label" can be used to include the label of the Data Source as part of the title.
Bug Fix2Futrix Administration: Initialization script The "Initialization Script (post-library and format search path allocation)" might not show previously entered code if the "Initialization Script(pre-library allocation)" was blank. This release fixes this issue.
Enhancement3Administration: Data Volume Control With this release it is now possible to define how much detail the user can see while navigating the data within Futrix via drilling and filtering, also it is possible to prevent the user from viewing a low level detail based on their security settings. This functionality can be turned on for a particular data source. Futrix Administrator would need to specify a measure to be used for the data volume check (usually a frequency measure) and three different thresholds for access (Low/Medium/High). The administrator would then assign the appropriate level of access to User Groups or individual users. By default volume restrictions are turned off.
Enhancement3Submitted Requests: Ability to view requests in the Web browser With this release, the Futrix Administrator can now view submitted requests for global viewpoints in the Web browser as well as in the desktop client. Previously, only requests for dashboards could be viewed in the Web browser.
Enhancement3Submitted Requests: Maintaining email at Menu Group When a user submits a request for global viewpoint or dashboard, an email about the request can now be sent to different email addresses (i.e. different Administrators) based on the current Menu Group. Email options can be specified in the Menu Group Attributes screen. If email settings at the Menu Group Level are not enabled, then the email options specified in "Submitted Dashboard/Viewpoint Request Options" will be used instead.
Enhancement3Indexed Datasets: Ability to control the use of "By" clause at the cube level With this release it is now possible to specify if the "By" clause should be used in summaries for a particular cube created via Futrix Indexed Datasets or SAS OLAP cube using Futrix Created Aggregates option. In addition, it is possible to specify the maximum number of variables to be used as part of the "By" clause to improve performance.
Enhancement2Web Client: Filters information shown when editing filter within group In the Web client, if the user selects an option to "Choose Values (filtered from group)" in the filter drop down menu, the screen displaying dimension values now also displays additional information about the filters applied to the list shown based on other dimensions within the group.
Enhancement2Futrix Administration: Improved Performance in Metadata Maintenance The Metadata Maintenance screen performance has been improved when saving changes.
Enhancement2License: Additional information The Administration screen for Licensing Key details now shows additional information about the licensed products. Similar information is also displayed in the SAS log.
Enhancement1Web Client: Ability to cut and paste generated viewpoint URL It is possible to generate a URL link for the menu item within Futrix by clicking on the menu item and choosing the option to "Generate URL". The window that displays the URL link now has a right-click pop-up menu with options to Copy the link, so it can be pasted in an email for example.
Enhancement1Web Client: Added "Round" function for calculated measures It is now possible to use SAS round() function when creating calculated measures. This function takes 2 parameters: the number to round and the rounding level.
Enhancement1Web Skins: New skin area With this release there is a new Web skin area available: "Futrix 6 Login Border - No Title". By using this skin area, it is possible to configure a web skin to not display the client name. To use this new skin area, Futrix Administrator will need to modify the current skin by choosing "Futrix 6 Login Border - No Title" for Inner Border on Login tab.
Futrix 6 M007
Released: 27 January 2009

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix3Alert Processing: Problem with Futrix 6 M006 There was a problem in Futrix 6 M006 with the processing of alerts. The batch process was exiting abnormally prior to completion.
Enhancement1Distint Lookup of Dimension Values: Ignore blank values A new advanced configuration macro variable is available that allows the dimension lookup of distinct values to ignore blank (i.e. missing) values. This can be used by setting the "futrix_distinct_lookups_no_blank" macro variable to 1. This will ignore blank values for all dimensions that have distinct lookups (i.e. it is not specific to any particular dimension).
Enhancement1Ability to disable local cache for web client It is now possible to completely disable local cache in Web client by setting user preference for "Cache Threshold (Web Client)" to 0. This can be useful to the Futrix Administrators during development of custom handles. The use of local cache for a viewpoint will bypass execution of some handles. Disabling it for the session will allow the administrator to reuse the same web session while testing code changes to the handle that would normally be bypassed.
Enhancement1MDX Query Certain special characters in the dimension values would cause MDX syntax errors when used in the filter of the viewpoint based on SAS OLAP cube. In this release the following characters have been handled to avoid the MDX syntax errors: "<", ">", ":".
Futrix 6 M006
Released: 13 December 2008

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix3Exporting: Styles not be used for exported output when using Java 6 If the version of Java being used for exporting was Java 6 then the exported output was not using the styles specified. All exported content was very plain with no colors, borders, font control or cosmetic images.
Bug Fix3Cube Optimization: Manual exclusion of sub-tables When defining the Inclusion/Exclusion Logic for a cube within Futrix, the Manual Exclusions tab sometimes has the ability to choose which sub-tables to exclude based on a variety of details about each sub-table (e.g. things like the number of rows in the sub-table). This facility was not working correctly for SAS OLAP Server Cubes using the Futrix Created Aggregates option - it was incorrectly giving an error stating that a required file didn't exist (when in fact it was available).
Enhancement4Executive Briefcase: New product The Futrix Executive Briefcase product has been released with this maintenance release of Futrix. This is currently only available to select Futrix customers. The Executive Briefcase product will become available for licensing by all customers with Futrix 6.1.
Enhancement2Web Client: Mini design area changes now give visual cue/reminder to user to click Apply When a user makes a change in the Mini Design Area of the web client's main analysis window to alter the classification dimensions, measures or the filters, a small reminder now appears over the table or chart to remind the user to click the "Apply" button to action their changes.
Enhancement2Preferences: Ability to control whether preferences are overridable at user level or not When creating custom preference definitions it was possible to control whether the preference value could be overridden at dashboard or viewpoint level, and thereby saved with the stored version of the dashboard or viewpoint. It is now also possible to control whether or not a preference can be overridden by individual users with their own default value. Previously every preference could be overridden at user level, but there are some cases where it is not appropriate for users to set their own default value. This occurs where the preference should only be able to be set by an administrator at the default site level, and where it can be overridden for a particular dashboard or viewpoint.
Enhancement2Static Publisher: Publishing of different static publishing groups in parallel Futrix static publishing groups can now be published in parallel when publishing the groups via batch processing. When publishing the groups in parallel it is no longer possible to keep publishing history details, therefore the batch processing code to invoke the publish needs to have the "futrix_sp_override_keep_history" macro variable set to 0.
Enhancement2Security: Row level security now applied to distinct lookups If a user has row level security restrictions imposed on them for a particular dimension, and a distinct lookup query is done on that dimension (where an administrator has provided a distinct lookup table to use for fast retrieval of distinct values), the row level security restrictions will be applied to the values that they are presented with.
Enhancement2Maps: New option to show all map areas vs. only filtered ones There is a new preference, "Show All Map Areas", to control whether or not filters that have been specified for the current level of mapping should be applied to the map areas shown. Filters that have been specified for higher level mapping dimensions will always be used to reduce the areas shown within the map, so this preference only has any effect if the current level of classification. For example, if you have a map of the USA and you are classifying by State, and you also have a filter on State to only show California and Oregon, then if this preference is On you would see the whole of the USA but only two states would have traffic lighting and values. If this preference was Off then you would only see those two states in the map. Note: The value for the current viewpoint can be toggled On and Off via a new item in the right mouse popup menu.
Enhancement1Submitted Dashboard/Viewpoint requests honor "Assign only when needed" library attribute The library that is specified for storage of all dashboard and viewpoint requests can now make use of the "Assign only when needed" library attribute, so that the library doesn't have to always be assigned but will be dynamically assigned only as it is needed.
Enhancement1OpenLDAP External User Database: Ability to rename parameters When using an OpenLDAP External User Database for user management, it is now possible to customize the names of the parameters used for integration with the LDAP integration.
Enhancement1Customization: New public class method "get_filter_set_for_external_storage" A new public class method, "get_filter_set_for_external_storage", is now available for creation of a filter set to be stored externally. This external set of filters can then later be passed back to Futrix for use in the "query" public class method. Futrix will look after all versioning required to ensure that the filter metadata is correctly amended for future changes to the Futrix metadata structure.
Futrix 6 M005
Released: 26 November 2008

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix2Customization: Filter overrides causing crash in web client When filters were overridden during the invocation of a particular viewpoint in the Futrix web client (by setting custom parameters on the URL), there were some circumstances when Futrix would crash.
Bug Fix2Exporting: Dashboard layout in PDF Dashboard exporting to PDF could produce overlapping cells if the dashboard had more than 2 columns and more than 2 rows of dashboard cells.
Bug Fix1Web Interface: Column label pixel width warning with measures "on rows" When using the "Fixed Headers on Scrollable Tables" preference in web client tables, and displaying the measures down the table "on rows" with a mix of different measure formats, there was a possibility that the user could get a popup warning about the column labels not lining up with cell values.
Bug Fix1Web Interface: Overwritten chart axis range Viewpoint level overwrites to the chart axis minimum/maximum boundaries were not honored after upgrade to Futrix 6 for viewpoints saved prior to the upgrade.
Enhancement2Furtix Web for SAS IT: disabling debugging parameters It is now possible to disable debugging output to be included in the web client when using Futrix Web with SAS Integration Technologies. Debugging will still occur, but the output will only be recorded in the server side logs, and will not be sent to the end user web session. To enable this functionality, set futrixweb.logging.allowDebugInResponse=false in the futrixweb.properties file. By default this property has a value of true and allows debugging output to the web session.
Enhancement1Futrix website: RSS feeds for Furtix 6 Maintenance Releases RSS feeds for Futrix 6 Maintenance Releases are now available on Futrix web site http://futrix.com. There are 2 feeds available: for end users (listing the changes relevant to the end user experience) and for administrators (listing all the changes).
Futrix 6 M004
Released: 18 November 2008

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix1Metadata Maintenance: Default viewpoint not being added to the menu When adding a new meta-item to a subject and expecting a new viewpoint to be added to the associated menu group, there was one scenario where it may not have been added. This could occur when the associated menu group didn't have a folder in the top level of the menu group with the same name as the subject, but there was a dashboard or viewpoint in the top level with exactly the same name as the subject.
Bug Fix1End User Interface: Saving dimension attributes if it always shows in the filter area Futrix 6 handles modified attributes of dimensions and measures in the viewpoint differently from Futrix 5. In Futrix 5 all changes were saved with the viewpoint. In Futrix 6 the changed attributes are only saved if the dimension/measure is used by the viewpoint. It is possible to alter a dimension attribute within the viewpoint to make it always show in the filter area, which was not saved with the viewpoint in Futrix 6. With this release setting of this attribute for a dimension will be handled as if the dimension was used by the viewpoint and all modified attributes of that dimension will be saved.
Bug Fix1Web Interface: Column label alignment On viewpoints with nested row dimensions, labels in the column headers could get mis-aligned.
Bug Fix1SAS Stored Process: SAS Stored Process not found If a SAS Stored Process was registered within SAS Metadata Server, and at least one folder in the path to the stored process had a non-unique name within the tree structure, Futrix sometimes could not find the stored process.
Enhancement3End User Performance: Installations with large numbers of measures The performance of the end user interface has been improved for the loading of menu items. Users should notice a significant improvement in performance for installations that have very large number of measures, especially when loading dashboards.
Enhancement1Futrix Administration: Saving new and modified dimensions/measures with the viewpoint A new advanced configuration option can be used to simulate Futrix 5 behaviour of saving all new and modified dimensions and measures with the viewpoint whether they are used by the viewpoint or not. To enable this option, set futrix_save_all_attr_overrides macro variable to 1 in the Futrix initialization script.
Enhancement1End User Performance: Viewpoints based on SAS OLAP cubes This release contains an enhancement that significantly improves query performance for viewpoints accessing pure SAS OLAP cubes.
Futrix 6 M003
Released: 6 November 2008

Web server update required: No

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix3Web Client: Synchronized Filters not honored on dashboard load Filters could be dropped from the set of synchronized filters in a dashboard, if the dashboard contains viewpoints from different data sources (different meta-items), and where a synchronized filter was based on a dimension or measure not available in the data source used by the first (top left) viewpoint within the dashboard.
Bug Fix2SAS Stored Processes: End user viewer crash if stored process registration deleted If the registration of a SAS stored process currently set up for use in a dashboard was deleted from Futrix, then the web client viewer would crash when trying to load a dashboard requiring the deleted stored process.
Bug Fix2Remote Administrator: Problem saving code for creation of secondary data sources The ability to save the source code for the creation of secondary data sources was not working within the "View/Save Code" screen while using Futrix via the Remote Administrator and trying to upload the source code to the remote server in the form of a SAS catalog SOURCE entry.
Bug Fix2Desktop Client: Crash when trying to load a pre-saved filter The desktop client was crashing when trying to load pre-saved filters into the Edit Filters window.
Bug Fix2Web Client: Pixel alignment popup warning When using the "Fixed Headers in Scrollable Tables" option in the web client there was a scenario where a popup warning would be given about the pixel widths of the column labels not matching up with the body of cells. This occurred when the column contained cells with a mix of large negative and positive numbers and the first one of them was negative.
Bug Fix2SAS Stored Processes: Admin Menu Item Management If a SAS Stored Process was added to a dashboard within the Menu Item Management administration screen, then Futrix would crash in the web end user environment is the user opened the Dashboard Attributes window for that dashboard.
Bug Fix2Exporting: Background color for Map charts Chart Background color preference was not being honored during exporting of spatial map charts.
Bug Fix2SAS Stored Process: Running if SAS Metadata Server Integration is not enabled Futrix could find and run SAS Stored Process using default SAS system options even if SAS Metadata Server Integration was not enabled within Futrix Administration. With this maintenance release, SAS Metadata Server Integration must be enabled in order for Futrix to run SAS Stored processes.
Bug Fix1Web Client: Dashboard Layout: Unnecessary Error Messages The user would receive error messages during the editing of dashboard layout within the web client's Dashboard Attributes window if the layout was not in a legal state. These messages should only occur after making changes to the layout and clicking OK to return to the main analysis window.
Change1Increase default length for measure formats The default maximum length for measure formats was 16 digits within Futrix 5, but this has now changed to 32 digits within Futrix 6. All characters used within numbers are considered a "digit" and therefore commas and decimal places within the numeric values are also counted. The new Futrix 6 functionality in the web client for "Fixed Headers in Scrollable Tables" requires that the formatting of numbers is consistent for each measure. Issues could arise with very large numbers when the maximum format length was only 16 digits and while using a "comma" format as the table cell values, which could result in the summary row value not having enough digits left to show commas and therefore the commas would be dropped causing inconsistent formatting of a measure.
Enhancement2SAS Metadata Server Integration: Option to use the logged in user credentials When interacting with the SAS Metadata Server, Futrix needs security access to perform a variety of tasks and queries. For the tasks that do not require unrestricted access, Futrix had two methods of interacting with the SAS Metadata Server (Trusted Peer and the use of a generic user userid/password). This maintenance release of Futrix 6 introduces a new method that can be used when the logged in user has been authenticated via the SAS Metadata Server (i.e. that they are a user in the External User Database where this has been set up to use the SAS Metadata Server as the source of the external users). Once authenticated by the SAS Metadata Server those credentials can then be used for all SAS Metadata Server integration. If the logged in user is not a SAS Metadata Server user then the previously available methods will be used (Trusted Peer or Generic User). Note: This new feature is not available for users logging in via Single Sign On.
Enhancement2SAS Stored Process: Futrix filter descriptions Futrix filter descriptions are now available to the SAS Stored Process via a separate dataset. Futrix sample code for a stored process demonstrates how it can be used to add titles to the output of the stored process.
Futrix 6 M002
Released: 28 October 2008

Web server update required: Yes

Change TypeSeverity
(1 Low - 5 High)
SummaryDetailed Comments
Bug Fix3Web Client: Reference Lines associated with the wrong axis There were several issues in the web client when using reference lines in a multi-axis chart. While editing axis details, there were occassions where the axis that the reference lines should be associated with could change when they should not. Also, in some circumstances, reference lines configured to be associated with an axis on the right of the chart could become associated with one of the left axes.
Bug Fix2Personal Alert Processing: Unnecessary alert status of "Unprocessed" Processing of personal alerts for a user could result in "unprocessed alerts" emails being sent to the user prematurely (with a reason of "Load Dashboard/Viewpoint Failed") when it may have been possible to process it. This could occur on alerts that were set up for a personal dashboard or personal viewpoint and the last used menu group for that user was a different menu group to the one where the personal menu item was saved.
Bug Fix2Personal Alerts: Alert not created on "Save As..." Personal alerts were not being created during the "Save As..." process if a dashboard was loaded and the user then drilled to a specific viewpoint (that contained an existing personal alert), then clicking "Save As..." to save the viewpoint to the menu and they also selected the checkbox to create a new alert for the new viewpoint being saved.
Bug Fix2Web Client: End user viewer could crash after change to viewpoint Under certain circumstances the web client viewer could crash after changing from a dashboard to a viewpoint when the viewpoint being loaded had several row dimensions (three or more).
Bug Fix2Web Client: End user viewer could crash after menu item selection The web client viewer could crash if a viewpoint being loaded had only a few dimensions available due to security restrictions, and where there were numerous measure dependencies (i.e. measures that depend on other measures or dimensions such as calculated measures, relative measures, filtered measures, inter-measure traffic lighting, etc.).
Futrix 6 M001
Released: 20 October 2008

Web server update required: Yes