Difference between revisions of "Version 9.1"

(New Features)
m (Text replacement - "XLCubed" to "FluenceXL")
 
(108 intermediate revisions by 5 users not shown)
Line 1: Line 1:
=New Features=
+
What's new in Version 9.1
  
* [[Pivot View]] - new data storage mode
+
=Main Additions=
* [[Offline Cubes]]
+
* [[Cube Comments#Viewing and entering comments|Commentary - formatting, attachments, screengrabs, replies, history...]]
 +
* [[Cube Comments#Reporting with Comment Frames|Commentary - Improved reporting]]
 +
* [[Pivot View#New in Version 9.1|Extended Pivot Views for relational reporting]] - support for multi-level hierarchies and session calculations.
 +
* [[Repeaters]]  - Easily replicate a formatted report section across multiple variables.
 +
* [[Slicer Lists]] - Group slicers together in one control for ease of layout and presentation.
 +
* [[Conditional formatting#New in Version 9.1|Conditional formatting enhancements]] - Full grid integration with support for colour gradients and icon sets.
 +
 
 +
=General=
 +
==Grids==
 +
* [[Conditional formatting#New in Version 9.1|Conditional formatting enhancements]]
 +
* [[MDX:#Adding hidden calculations|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 Multiple Charts#Row customisation|Can be customised per row]]  - useful when charting different measures
 +
* [[Small Multiple Charts#Data Table|Underlying data can be viewed in a table]]
 +
* Optional button to clear selections
 +
* Bubble and dot plot borders can have width customised
 +
* 'Apply' button on the "Spacing" tab to preview changes
 +
* More flexibility to customise series appearance.
 +
* Support for axis crossing properties
 +
* Support for Pie and Doughnut chart types
 +
* Drilling still keeps slicer links
 +
 
 +
==Visualisation==
 +
* [[Repeaters]] 
 +
* [[Viewports#Version 9.1|Viewports can contain FluenceXL chart types]]
 +
* Treemaps can customise fonts
 +
* Viewports can maintain aspect ratio when resized - useful for dashboards
 +
* Maps published to the web can multi-pick using Ctrl
 +
 
 +
==Excel Charting==
 +
* Additional Excel Chart features supported for FluenceXL Web publication:
 +
** Data tables in Excel charts
 +
** Leader lines in Excel charts
 +
 
 +
* Additional Excel Chart types supported for FluenceXL Web publication:
 +
** Waterfall charts
 +
** Histograms
 +
** Pareto charts
 +
 
 +
==Slicers==
 +
* [[Slicer Lists]]
 +
* [[Dimension Slicers#Custom Query|Slicers can have a custom query]]
 +
* Slicers can use parent/child columns to create trees
 +
* Slicers can be set to clear other ranges
 +
* Slicer selections can [[Dimension Slicers#Activate XL3Link|activate an XL3Link]]
 +
 
 +
==Pivot Views (for SQL and relational reporting)==
 +
* [[Pivot View#Extract (fast query) storage mode|Support for Hierarchies and custom calculations]]
 +
* [[Pivot View#Custom query|Pivot views can have a custom query]]
 +
* Pivot views can be created from any existing connection
 +
 
 +
==Formulae==
 
* [[MDX formula wizard]]
 
* [[MDX formula wizard]]
* [[Repeaters]]
+
* [[XL3Set]]  
* [[Conditional formatting#New in Version 9.1|Conditional formatting enhancements]]
+
* [[XL3GridArrayLookup]] and [[XL3TableArrayLookup]]
 +
* [[XL3ReportInfo]]
 +
* [[XL3SetProperty]] Additional functionality
 +
** Pagers
 +
** Shapes
 +
** Workbook Permission
 +
** Connection
 +
** Viewport
 +
** Chart axis crossing
 +
** Picture links
 +
* 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 Frame]]
 +
* [[XL3CubeFormattedComment]]
 +
* Comments improved handling of pasting from Word
 +
* Comments - general speed up if not "Showing descendants"
 +
 
 +
==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]]
* [[Comments]] Allow attachments XLW-405
+
* Improved options for [[Rest Queries]]
* [[Comment Block]] XLE-1719
+
* Tables based on Tabular SSAS support drill indicators
* [[Slicer Lists]] XLE-1747/XLE-1736
+
* Tables named range for Last Cell. Useful for viewports e.g. based on Sheet1!A1:LastCell
* [[Table Charts]] XLE-1715
+
 
* [[Small Multiple Charts#Row customisation|Small multiples can be customised per row]] XLE-481
+
==Scheduling==
* [[Small Multiple Charts#Data Table]] XLE-1691
+
* [[Scheduling]] SQL distribution list
* [[Viewports#XLCubed Charts]] XLE-1662
+
* [[https://help.xlcubed.com/Controlling_Scheduling_with_a_SQL_Query#Preparing_the_SQL_Statement|SQL-driven distribution lists can have semicolon-delimited email addresses]]
* [[Grids]] Custom MDX on Axis XLE-1555
+
* Admin users can view all schedules
* [[Grids]] MDX calculations in query XLE-1553
+
 
* [[XL3CubeFormattedComment]] XLE-1219
+
==Dashboards==
* [[Publishing]] Customise dependencies - XLE-952
+
* [[Dashboard_sheets|Dashboards]] Can add pagers  
* [[Dimension Slicers#Custom Query]] XLE-1766
+
* Dashboards can toggle auto-linking on/off.
* [[HANA#SQL]] XLE-1763
+
* Dashboards can mix connections from different cubes with varying hierarchies.
* [[Pivot Views]] Custom Query XLE-1754
+
* Can set rows and columns to have fixed sizes
* [[Scheduling]] SQL distribution list XLW-710
+
* Can include a "Zoom" option when published to view control full-page
* [[Excel Charts]] Support data tables on web XLW-695
+
* Dashboard Labels can be named to easier track them
* [[Excel Charts]] Support leader lines on web XLW-694
 
* [[Excel Charts]] Support waterfall on web XLE-1128
 
* [[Dashboards]] Can have pagers XLE-1568
 
* [[Licensing]] Named users on web XLW-686
 
* [[Managing Connections]] handle structure changes across reports XLE-561
 
* [[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
 
  
=Enhancements=
+
==Supported backends==
 +
* Improved Sap HANA connectivity
  
 +
==Misc==
 +
* [[Query Generators]] Allow MDX to be generated and put into the worksheet
 +
* [[Offline Cubes]]
 +
* [[Table Charts]]
 +
* [[Managing Connections]] handle structure changes across reports also updates calculations
 +
* [[Widgets]] allowing custom content to be embedded in a workbook on the web
 +
 +
=Excel Edition=
 +
==General==
 
* Connection screen can filter connection types
 
* Connection screen can filter connection types
* Connection screen can pick .odc files
+
* Connection screen can import .odc files
* Previous/Next member counts can come from a range XLE-421
+
* Improved handling of protected and macro-enabled workbooks.  
* Grid merging can be done on columns and rows independantly XLE-963
+
* Measure group filter added to Hierarchy drop downs.  
* Grid option to display set members on headers XLE-1220
+
* Named sets use display folders
* Grid option to "not merge where" can simplify MDX XLE-1455
+
* Improved options screen with better High-DPI support
* Grid named range for members and data that excludes labels. XLE-1771
+
* Faster Excel load time
* Grid named range for Last Cell. Useful for viewports e.g. based on Sheet1!A1:LastCell
+
* "Designer Ribbon" to easily layout FluenceXL Objects en masse
* Grid sort alphabetically button added to ribbon. XLE-451
+
* Can multi-select reports in Publishing to move between folders
* Tables based on Tabular SSAS support drill indicators XLE-1714
+
* Improved Small Multiple task pane
* 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
+
==Custom Calculations==
* Small multiples can have a button to clear selections XLE-464
+
* Custom calculation export can filter items exported.  
* Small multiple bubble borders can have width customised XLE-1139
+
* Calculated members can be renamed directly in the member selector.
* 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
+
==Grid==
* Small multiples have more flexibility to customise series appearance. XLE-1592
+
* Can right-click on a selected member and "Show member in Tree"
* Small multiples support axis crossing properties XLE-1695
+
* Sort A-Z added to grid ribbon to sort members alphabetically
* Treemaps can customise fonts XLE-1375
+
* Show warning if grid links are being used
* 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>
+
==Slicers==
* Dashboards can toggle auto-linking on/off. XLE-1724
+
* Can set defaults to use for new slicers
* Dashboards can mix connections from different cubes with varying hierarchies. XLE-1612
+
 
* Comments improved handling of pasting from Word
+
=Web Edition=
* Activate XL3Link option added to many controls. XLE-1398
+
==General==
** When outputting a selection the XL3Link is activated which can clear out cell selections
+
* [[Licensing]] Named users on web  
* Picture links can get a cell address to jump to from a range. XLE 1710
+
* [[Customise publishing dependencies]]
* Measure group filter added to Hierarchy drop downs. XLE-1748
+
* Custom validation rule improvements on the web
* Calculated members can be renamed directly in the member selector. XLE-861
+
* Improved error message logging on the web  
* Member selections support Exists XLE-1454
+
* New [[Downloading reports|download options]] csv and txt. Options for XL3ReportType and PrintRendererServer web service.
* Named sets use display folders XLE-1225
+
* [[Web Development]] JS API - get cell/range value 
* Custom calculation export can filter items exported. XLE-1770
+
* Allow data access on web to run as AppPool user [[Customising web config|web.config]] setting.  
* Improved slicer formatting XLW-724
+
* Improved slicer formatting
* Improved map printing on web XLW-681
+
* [[ Customising_web_config|Option to hide toolbar buttons]]
* Multisheet printing on web names sheets after members XLW-655
+
* [[PowerPoint export]]
* Multisheet printing improves page numbering consistency XLW-629
+
 
* Multisheet printing improves formula handing across sheets XLE-1670
+
==Formulae==
* "Refresh on driving cells change" can optionally affect the web (new option) XLW-697
+
* "Refresh on driving cells change" can optionally affect the web (new option)
* Admin users can view all schedules XLW-649
+
 
* Relative path support for reports when using the SQL repository XLW-630
+
==SQL Repository==
* Allow data access on web to run as AppPool user [[Customising web config|web.config]] setting. XLW-500
+
* [[SQL_Repository#Administration|SQL Repository]] can hide folders or reports so they are only available through links
* SQL Repository can hide folders or reports so they are only available through links XLW-515
+
* [[SQL_Repository#Administration|SQL Repository]] has colour coded folders on web
* SQL Repository has colour coded folders on web XLW-316
+
* [[XL3WebReportLink#Relative_Paths|Relative path]] support for reports when using the SQL repository
* [[Web Development]] JS API - get cell/range value  XLW-392
+
* Original workbook can be published to the repository so can be recovered at a later date
* New download options csv and txt. Options for XL3ReportType and PrintRendererServer web service. XLW-451
+
* Option to override the default folder order
* Improved error message logging on the web XLW-542
+
 
* Formuale can optionally remove drill indicators from member text in case they reference a grid.
+
==Printing==
* XL3WebReportLink can link to a specific cell instead of a sheet
+
* Multisheet printing on web names sheets after members
* Custom validation rule improvements on the web XLW-696
+
* Multisheet printing improves page numbering consistency
* Improved handling of protected and macro-enabled workbooks. XLE-1669
+
* Multisheet printing improves formula handing across sheets
* Numerous minor improvements and bug fixes
+
* Improved map printing on web  
 +
* Option to include workbook slicers on a page in PDF
 +
* Better slicer and other FluenceXL object positioning and sizing
 +
 
 +
=Mobile App=
 +
 
 +
==General==
 +
* Support zooming in offline reports
 +
* Support offline reports in Android
 +
* Allow offline reports to be refreshed
 +
* Allow scheduled refreshing of offline reports
 +
 
 +
[[Category: Versions]]

Latest revision as of 09:37, 4 July 2023

What's new in Version 9.1

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 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

  • Can be customised per row - useful when charting different measures
  • Underlying data can be viewed in a table
  • Optional button to clear selections
  • Bubble and dot plot borders can have width customised
  • 'Apply' button on the "Spacing" tab to preview changes
  • More flexibility to customise series appearance.
  • Support for axis crossing properties
  • Support for Pie and Doughnut chart types
  • Drilling still keeps slicer links

Visualisation

Excel Charting

  • Additional Excel Chart features supported for FluenceXL Web publication:
    • Data tables in Excel charts
    • Leader lines in Excel charts
  • Additional Excel Chart types supported for FluenceXL Web publication:
    • Waterfall charts
    • Histograms
    • Pareto charts

Slicers

Pivot Views (for SQL and relational reporting)

Formulae

  • MDX formula wizard
  • XL3Set
  • XL3GridArrayLookup and XL3TableArrayLookup
  • XL3ReportInfo
  • XL3SetProperty Additional functionality
    • Pagers
    • Shapes
    • Workbook Permission
    • Connection
    • Viewport
    • Chart axis crossing
    • Picture links
  • 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

Relational Connections

Scheduling

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
  • Can include a "Zoom" option when published to view control full-page
  • Dashboard Labels can be named to easier track them

Supported backends

  • Improved Sap HANA connectivity

Misc

Excel Edition

General

  • Connection screen can filter connection types
  • Connection screen can import .odc files
  • Improved handling of protected and macro-enabled workbooks.
  • Measure group filter added to Hierarchy drop downs.
  • Named sets use display folders
  • Improved options screen with better High-DPI support
  • Faster Excel load time
  • "Designer Ribbon" to easily layout FluenceXL Objects en masse
  • Can multi-select reports in Publishing to move between folders
  • Improved Small Multiple task pane

Custom Calculations

  • Custom calculation export can filter items exported.
  • Calculated members can be renamed directly in the member selector.

Grid

  • Can right-click on a selected member and "Show member in Tree"
  • Sort A-Z added to grid ribbon to sort members alphabetically
  • Show warning if grid links are being used

Slicers

  • Can set defaults to use for new slicers

Web Edition

General

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
  • Original workbook can be published to the repository so can be recovered at a later date
  • Option to override the default folder order

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
  • Better slicer and other FluenceXL object positioning and sizing

Mobile App

General

  • Support zooming in offline reports
  • Support offline reports in Android
  • Allow offline reports to be refreshed
  • Allow scheduled refreshing of offline reports