Difference between revisions of "Version 9.1"
(→Dashboards) |
(→General) |
||
| Line 99: | Line 99: | ||
* Connection screen can filter connection types | * Connection screen can filter connection types | ||
* Connection screen can import .odc files | * Connection screen can import .odc files | ||
| − | * Improved handling of protected and macro-enabled workbooks. | + | * Improved handling of protected and macro-enabled workbooks. |
| − | * Custom calculation export can filter items exported. | + | * Custom calculation export can filter items exported. |
| − | * Calculated members can be renamed directly in the member selector. | + | * Calculated members can be renamed directly in the member selector. |
| − | * Measure group filter added to Hierarchy drop downs. | + | * Measure group filter added to Hierarchy drop downs. |
| − | * Named sets use display folders | + | * Named sets use display folders |
* Improved options screen with better High-DPI support | * Improved options screen with better High-DPI support | ||
Revision as of 13:39, 13 October 2017
What's new in Version 9.1
Contents
[hide]Main Additions
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 independantly
- 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 doe dashboards
- Maps can multi-pick using Ctrl
needs to be deployed to public web site
Excel Charting
- Excel Charts Support data tables on web
- Excel Charts Support leader lines on web
- Excel Charts Support waterfall on web
Slicers
- Slicer Lists
- Slicers can have a custom query
- Slicers can use parent/child columns to create trees
Pivot Views
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 XLE-561
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 XLW-686
- Customise publishing dependencies - XLE-952
- Custom validation rule improvements on the web XLW-696
- Improved error message logging on the web XLW-542
- New download options csv and txt. Options for XL3ReportType and PrintRendererServer web service. XLW-451
- Web Development JS API - get cell/range value XLW-392
- Allow data access on web to run as AppPool user web.config setting. XLW-500
- Improved slicer formatting XLW-724
- Option to hide toolbar buttons
- Powerpoint export
Formulae
- "Refresh on driving cells change" can optionally affect the web (new option) XLW-697
SQL Repository
- 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
- Relative path support for reports when using the SQL repository XLW-630
Printing
- 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
- Improved map printing on web XLW-681
- Option to include workbook slicers on a page in PDF
