Difference between revisions of "Version 9.1"
Line 7: | Line 7: | ||
* [[Conditional formatting#New in Version 9.1|Conditional formatting enhancements]] | * [[Conditional formatting#New in Version 9.1|Conditional formatting enhancements]] | ||
* [[MDX:#Adding hidden calculations|Hidden MDX calculations in grids]] XLE-1553 | * [[MDX:#Adding hidden calculations|Hidden MDX calculations in grids]] XLE-1553 | ||
+ | * 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 | ||
+ | * Member selections support Exists XLE-1454 | ||
+ | |||
+ | |||
+ | ==Small Multiples== | ||
+ | * [[Small Multiple Charts#Row customisation|Small multiples can be customised per row]] | ||
+ | * [[Small Multiple Charts#Data Table|Small multiples data can be viewed in a table]] | ||
+ | * 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 | ||
==Visualisation== | ==Visualisation== | ||
* [[Repeaters]] | * [[Repeaters]] | ||
− | |||
− | |||
* [[Viewports#Version 9.1|Viewports can contain XLCubed chart types]] XLE-1662 | * [[Viewports#Version 9.1|Viewports can contain XLCubed chart types]] XLE-1662 | ||
+ | * 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 <code>needs to be deployed to public web site</code> | ||
− | ==Charting== | + | ==Excel Charting== |
* [[Excel Charts]] Support data tables on web XLW-695 | * [[Excel Charts]] Support data tables on web XLW-695 | ||
* [[Excel Charts]] Support leader lines on web XLW-694 | * [[Excel Charts]] Support leader lines on web XLW-694 | ||
Line 22: | Line 44: | ||
* [[Slicer Lists]] | * [[Slicer Lists]] | ||
* [[Dimension Slicers#Custom Query|Slicers can have a custom query]] XLE-1766 | * [[Dimension Slicers#Custom Query|Slicers can have a custom query]] XLE-1766 | ||
+ | * Slicers can use parent/child columns to create trees XLE-1658 | ||
==Pivot Views== | ==Pivot Views== | ||
Line 39: | Line 62: | ||
** Viewport XLE-1743 | ** Viewport XLE-1743 | ||
** Chart axis crossing XLE-1741 | ** Chart axis crossing XLE-1741 | ||
+ | * 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. XLE 1710 | ||
+ | * Activate XL3Link option added to many controls. XLE-1398 | ||
+ | ** When outputting a selection the XL3Link is activated which can clear out cell selections | ||
+ | |||
==Commentry== | ==Commentry== | ||
Line 44: | Line 73: | ||
* [[Comment Block]] | * [[Comment Block]] | ||
* [[XL3CubeFormattedComment]] XLE-1219 | * [[XL3CubeFormattedComment]] XLE-1219 | ||
+ | * Comments improved handling of pasting from Word | ||
+ | |||
− | == | + | ==Relational Connections== |
* [[Using_SQL_Parameters#Using_stored_procedure_paramaters|Pass table variables to stored procedures in SQL Server]] | * [[Using_SQL_Parameters#Using_stored_procedure_paramaters|Pass table variables to stored procedures in SQL Server]] | ||
+ | * 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 | ||
==Scheduling== | ==Scheduling== | ||
* [[Scheduling]] SQL distribution list XLW-710 | * [[Scheduling]] SQL distribution list XLW-710 | ||
+ | * [[https://help.xlcubed.com/Controlling_Scheduling_with_a_SQL_Query#Preparing_the_SQL_Statement|SQL-driven distribution lists can have semicolon-delimited email addresses]] | ||
+ | * Admin users can view all schedules XLW-649 | ||
+ | |||
==Dashboards== | ==Dashboards== | ||
* [[Dashboards]] Can add pagers | * [[Dashboards]] Can add pagers | ||
+ | * Dashboards can toggle auto-linking on/off. XLE-1724 | ||
+ | * Dashboards can mix connections from different cubes with varying hierarchies. XLE-1612 | ||
==Misc== | ==Misc== | ||
Line 59: | Line 97: | ||
* [[Table Charts]] XLE-1715 | * [[Table Charts]] XLE-1715 | ||
* [[Managing Connections]] handle structure changes across reports XLE-561 | * [[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. XLE-1669 | ||
+ | * Custom calculation export can filter items exported. XLE-1770 | ||
+ | * Calculated members can be renamed directly in the member selector. XLE-861 | ||
+ | * Measure group filter added to Hierarchy drop downs. XLE-1748 | ||
+ | * Named sets use display folders XLE-1225 | ||
Line 65: | Line 113: | ||
* [[Licensing]] Named users on web XLW-686 | * [[Licensing]] Named users on web XLW-686 | ||
* [[Customise publishing dependencies]] - XLE-952 | * [[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 [[Customising web config|web.config]] setting. XLW-500 | ||
+ | * Improved slicer formatting XLW-724 | ||
+ | * Option to hide toolbar buttons | ||
+ | |||
==Formulae== | ==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 on web names sheets after members XLW-655 | ||
* Multisheet printing improves page numbering consistency XLW-629 | * Multisheet printing improves page numbering consistency XLW-629 | ||
* Multisheet printing improves formula handing across sheets XLE-1670 | * Multisheet printing improves formula handing across sheets XLE-1670 | ||
− | + | * Improved map printing on web XLW-681 | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | * Improved | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Revision as of 13:05, 13 October 2017
What's new in Version 9.1
Contents
[hide]Main Additions
General
Grids
- Conditional formatting enhancements
- Hidden MDX calculations in grids XLE-1553
- 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
- Member selections support Exists XLE-1454
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 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
Visualisation
- Repeaters
- Viewports can contain XLCubed chart types XLE-1662
- 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
Excel 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
- Slicers can use parent/child columns to create trees XLE-1658
Pivot Views
Formulae
- MDX formula wizard
- XL3Set XLE-1773
- XL3GridArrayLookup and XL3TableArrayLookup XLE-1606
- XL3ReportInfo XLW-417
- XL3SetProperty Additional functionality
- Pagers XLE-1240
- Shapes XLE-1760
- Workbook Permission XLE-1759
- Connection XLE-1755
- Viewport XLE-1743
- Chart axis crossing XLE-1741
- 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. XLE 1710
- Activate XL3Link option added to many controls. XLE-1398
- When outputting a selection the XL3Link is activated which can clear out cell selections
Commentry
- Comments Allow attachments
- Comment Block
- XL3CubeFormattedComment XLE-1219
- 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 XLE-1714
- Tables named range for Last Cell. Useful for viewports e.g. based on Sheet1!A1:LastCell
Scheduling
- Scheduling SQL distribution list XLW-710
- [distribution lists can have semicolon-delimited email addresses]
- Admin users can view all schedules XLW-649
Dashboards
- Dashboards Can add pagers
- Dashboards can toggle auto-linking on/off. XLE-1724
- Dashboards can mix connections from different cubes with varying hierarchies. XLE-1612
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. XLE-1669
- Custom calculation export can filter items exported. XLE-1770
- Calculated members can be renamed directly in the member selector. XLE-861
- Measure group filter added to Hierarchy drop downs. XLE-1748
- Named sets use display folders XLE-1225
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
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