Version 9.1

What's new in Version 9.1

General

Grids

• Conditional formatting enhancements
• Hidden MDX calculations in grids XLE-1553

Visualisation

• Repeaters
• Small multiples can be customised per row
• Small multiples data can be viewed in a table
• Viewports can contain XLCubed chart types XLE-1662

Charting

• Excel Charts Support data tables on web XLW-695
• Excel Charts Support leader lines on web XLW-694
• Excel Charts Support waterfall on web XLE-1128

Slicers

• Slicer Lists
• Slicers can have a custom query XLE-1766

Pivot Views

• Pivot views have a new data storage mode
• Pivot views can have a custom query

Formulae

• MDX formula wizard
• XL3Set XLE-1773
• XL3GridArrayLookup and XL3TableArrayLookup XLE-1606
• XL3ReportInfo XLW-417
• XL3SetProperty Additional functionality

Commentry

• Comments Allow attachments
• Comment Block
• XL3CubeFormattedComment XLE-1219

SQL

• Pass table variables to stored procedures in SQL Server

Scheduling

• Scheduling SQL distribution list XLW-710

Dashboards

• Dashboards Can add pagers

Misc

• Query Generators Allow MDX to be generated and put into the worksheet
• Offline Cubes
• Table Charts XLE-1715
• Managing Connections handle structure changes across reports XLE-561

Web Edition

General

• Licensing Named users on web XLW-686
• Customise publishing dependencies - XLE-952

New Features

• • Pagers XLE-1240
  • Shapes XLE-1760
  • Workbook Permission XLE-1759
  • Connection XLE-1755
  • Viewport XLE-1743
  • Chart axis crossing XLE-1741
• Option to hide toolbar buttons

Enhancements

• Connection screen can filter connection types
• Connection screen can import .odc files
• Previous/Next member counts can come from a range XLE-421
• Grid custom MDX on Axis XLE-1555
• Grid merging can be done on columns and rows independantly XLE-963
• Grid option to display set members on headers XLE-1220
• Grid option to "not merge where" can simplify MDX XLE-1455
• Grid named range for members and data that excludes labels. XLE-1771
• Grid named range for Last Cell. Useful for viewports e.g. based on Sheet1!A1:LastCell
• Grid sort alphabetically button added to ribbon. XLE-451
• Tables based on Tabular SSAS support drill indicators XLE-1714
• Tables named range for Last Cell. Useful for viewports e.g. based on Sheet1!A1:LastCell
• Slicers can use parent/child columns to create trees XLE-1658
• Small multiples can have a button to clear selections XLE-464
• Small multiple bubble borders can have width customised XLE-1139
• Small multiple dot plot borders can have width customised XLE-1786
• Small multiples have apply button on the "Spacing" tab to preview changes XLE-1200
• Small multiples have more flexibility to customise series appearance. XLE-1592
• Small multiples support axis crossing properties XLE-1695
• Small multiples support Pie and Doughnut chart types
• Treemaps can customise fonts XLE-1375
• Viewports can maintain aspect ratio when resized - useful doe dashboards XLE-1664
• Maps can multi-pick using Ctrl XLE-1780 needs to be deployed to public web site
• Dashboards can toggle auto-linking on/off. XLE-1724
• Dashboards can mix connections from different cubes with varying hierarchies. XLE-1612
• Comments improved handling of pasting from Word
• Activate XL3Link option added to many controls. XLE-1398
  • When outputting a selection the XL3Link is activated which can clear out cell selections
• Picture links can get a cell address to jump to from a range. XLE 1710
• Measure group filter added to Hierarchy drop downs. XLE-1748
• Calculated members can be renamed directly in the member selector. XLE-861
• Member selections support Exists XLE-1454
• Named sets use display folders XLE-1225
• Custom calculation export can filter items exported. XLE-1770
• Improved slicer formatting XLW-724
• Improved map printing on web XLW-681
• Multisheet printing on web names sheets after members XLW-655
• Multisheet printing improves page numbering consistency XLW-629
• Multisheet printing improves formula handing across sheets XLE-1670
• "Refresh on driving cells change" can optionally affect the web (new option) XLW-697
• Admin users can view all schedules XLW-649
• Relative path support for reports when using the SQL repository XLW-630
• Allow data access on web to run as AppPool user web.config setting. XLW-500
• SQL Repository can hide folders or reports so they are only available through links XLW-515
• SQL Repository has colour coded folders on web XLW-316
• Web Development JS API - get cell/range value XLW-392
• New download options csv and txt. Options for XL3ReportType and PrintRendererServer web service. XLW-451
• Improved error message logging on the web XLW-542
• Formuale can optionally remove drill indicators from member text in case they reference a grid.
• XL3WebReportLink can link to a specific cell instead of a sheet
• Custom validation rule improvements on the web XLW-696
• Improved handling of protected and macro-enabled workbooks. XLE-1669
• [distribution lists can have semicolon-delimited email addresses]
• Numerous minor improvements and bug fixes