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]]
* [[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]]
 
 
* [[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
 +
  
==SQL==
+
==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
  
=New Features=
+
==Printing==
 
 
 
 
* 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 <code>needs to be deployed to public web site</code>
 
* 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 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
* "Refresh on driving cells change" can optionally affect the web (new option) XLW-697
+
* Improved map printing on web XLW-681
* 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 [[Customising web config|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
 
* [[https://help.xlcubed.com/Controlling_Scheduling_with_a_SQL_Query#Preparing_the_SQL_Statement|SQL-driven distribution lists can have semicolon-delimited email addresses]]
 
* Numerous minor improvements and bug fixes
 

Revision as of 13:05, 13 October 2017

What's new in Version 9.1

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

Slicers

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


Relational Connections

Scheduling


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

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