Version 9.1

What's new in Version 9.1

General

Grids

• Conditional formatting enhancements
• Hidden MDX calculations in grids
• Previous/Next member counts can come from a range
• Grid custom MDX on Axis
• Grid merging can be done on columns and rows independently
• Grid option to display set members on headers
• Grid option to "not merge where" can simplify MDX
• Grid named range for members and data that excludes labels.
• Grid named range for Last Cell. Useful for viewports e.g. based on Sheet1!A1:LastCell
• Grid sort alphabetically button added to ribbon.
• Member selections support Exists

Small Multiples

• Small multiples can be customised per row
• Small multiples data can be viewed in a table
• Small multiples can have a button to clear selections
• Small multiple bubble borders can have width customised
• Small multiple dot plot borders can have width customised
• Small multiples have apply button on the "Spacing" tab to preview changes
• Small multiples have more flexibility to customise series appearance.
• Small multiples support axis crossing properties
• Small multiples support Pie and Doughnut chart types

Visualisation

• Repeaters
• Viewports can contain XLCubed chart types
• Treemaps can customise fonts
• Viewports can maintain aspect ratio when resized - useful for dashboards
• Maps can multi-pick using Ctrl needs to be deployed to public web site

Excel Charting

• Additional Excel Chart features supported for XLCubed Web publication:
  • Data tables in Excel charts
  • Leader lines in Excel charts

• Additional Excel Chart types supported for XLCubed Web publication:
  • Waterfall charts
  • Histograms
  • Pareto charts

Slicers

• Slicer Lists
• Slicers can have a custom query
• Slicers can use parent/child columns to create trees

Pivot Views

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

Formulae

• MDX formula wizard
• XL3Set
• XL3GridArrayLookup and XL3TableArrayLookup
• XL3ReportInfo
• XL3SetProperty Additional functionality
  • Pagers
  • Shapes
  • Workbook Permission
  • Connection
  • Viewport
  • Chart axis crossing
• XL3WebReportLink can link to a specific cell instead of a sheet
• Formuale can optionally remove drill indicators from member text in case they reference a grid.
• Picture links can get a cell address to jump to from a range.
• Activate XL3Link option added to many controls.
  • When outputting a selection the XL3Link is activated which can clear out cell selections

Commentry

• Comments Allow attachments
• Comment Block
• XL3CubeFormattedComment
• Comments improved handling of pasting from Word

Relational Connections

• Pass table variables to stored procedures in SQL Server
• Tables based on Tabular SSAS support drill indicators
• Tables named range for Last Cell. Useful for viewports e.g. based on Sheet1!A1:LastCell

Scheduling

• Scheduling SQL distribution list
• [distribution lists can have semicolon-delimited email addresses]
• Admin users can view all schedules

Dashboards

• Dashboards Can add pagers
• Dashboards can toggle auto-linking on/off.
• Dashboards can mix connections from different cubes with varying hierarchies.
• Can set rows and columns to have fixed sizes

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

Excel Edition

General

• Connection screen can filter connection types
• Connection screen can import .odc files
• Improved handling of protected and macro-enabled workbooks.
• Custom calculation export can filter items exported.
• Calculated members can be renamed directly in the member selector.
• Measure group filter added to Hierarchy drop downs.
• Named sets use display folders
• Improved options screen with better High-DPI support

Web Edition

General

• Licensing Named users on web
• Customise publishing dependencies
• Custom validation rule improvements on the web
• Improved error message logging on the web
• New download options csv and txt. Options for XL3ReportType and PrintRendererServer web service.
• Web Development JS API - get cell/range value
• Allow data access on web to run as AppPool user web.config setting.
• Improved slicer formatting
• Option to hide toolbar buttons
• Powerpoint export

Formulae

• "Refresh on driving cells change" can optionally affect the web (new option)

SQL Repository

• SQL Repository can hide folders or reports so they are only available through links
• SQL Repository has colour coded folders on web
• Relative path support for reports when using the SQL repository

Printing

• Multisheet printing on web names sheets after members
• Multisheet printing improves page numbering consistency
• Multisheet printing improves formula handing across sheets
• Improved map printing on web
• Option to include workbook slicers on a page in PDF