XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "Version 9.1"

(Main Additions)
 
(18 intermediate revisions by 5 users not shown)
Line 2: Line 2:
  
 
=Main Additions=
 
=Main Additions=
* [[Cube Comments#Reporting with Comment Frames|Improved reporting on Comments]]
+
* [[Cube Comments#Viewing and entering comments|Commentary - formatting, attachments, screengrabs, replies, history...]]
* [[Pivot View#New storage mode|Extended Pivot Views for relational reporting]] - support for multi-level hierarchies and session calculations.
+
* [[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.
 
* [[Repeaters]]  - Easily replicate a formatted report section across multiple variables.
 
* [[Slicer Lists]] - Group slicers together in one control for ease of layout and presentation.
 
* [[Slicer Lists]] - Group slicers together in one control for ease of layout and presentation.
Line 23: Line 24:
  
 
==Small Multiples==
 
==Small Multiples==
* [[Small Multiple Charts#Row customisation|Small multiples can be customised per row]]  
+
* [[Small Multiple Charts#Row customisation|Can be customised per row]] - useful when charting different measures
* [[Small Multiple Charts#Data Table|Small multiples data can be viewed in a table]]  
+
* [[Small Multiple Charts#Data Table|Underlying data can be viewed in a table]]  
* Small multiples can have a button to clear selections
+
* Optional button to clear selections
* Small multiple bubble borders can have width customised
+
* Bubble and dot plot borders can have width customised  
* Small multiple dot plot borders can have width customised  
+
* 'Apply' button on the "Spacing" tab to preview changes  
* Small multiples have apply button on the "Spacing" tab to preview changes  
+
* More flexibility to customise series appearance.  
* Small multiples have more flexibility to customise series appearance.  
+
* Support for axis crossing properties  
* Small multiples support axis crossing properties  
+
* Support for Pie and Doughnut chart types
* Small multiples support Pie and Doughnut chart types
 
 
* Drilling still keeps slicer links
 
* Drilling still keeps slicer links
  
Line 39: Line 39:
 
* Treemaps can customise fonts  
 
* Treemaps can customise fonts  
 
* Viewports can maintain aspect ratio when resized - useful for dashboards
 
* Viewports can maintain aspect ratio when resized - useful for dashboards
* Maps can multi-pick using Ctrl <code>needs to be deployed to public web site</code>
+
* Maps published to the web can multi-pick using Ctrl
  
 
==Excel Charting==
 
==Excel Charting==
Line 56: Line 56:
 
* Slicers can use parent/child columns to create trees
 
* Slicers can use parent/child columns to create trees
 
* Slicers can be set to clear other ranges
 
* Slicers can be set to clear other ranges
 +
* Slicer selections can [[Dimension Slicers#Activate XL3Link|activate an XL3Link]]
  
==Pivot Views==
+
==Pivot Views (for SQL and relational reporting)==
* [[Pivot View#New storage mode|Pivot views have a new data storage mode]]
+
* [[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 View#Custom query|Pivot views can have a custom query]]
 
* Pivot views can be created from any existing connection
 
* Pivot views can be created from any existing connection
Line 74: Line 75:
 
** Viewport  
 
** Viewport  
 
** Chart axis crossing  
 
** Chart axis crossing  
 +
** Picture links
 
* XL3WebReportLink can link to a specific cell instead of a sheet
 
* 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.
 
* Formuale can optionally remove drill indicators from member text in case they reference a grid.
Line 89: Line 91:
 
==Relational Connections==
 
==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]]
 +
* Improved options for [[Rest Queries]]
 
* Tables based on Tabular SSAS support drill indicators
 
* Tables based on Tabular SSAS support drill indicators
 
* Tables named range for Last Cell. Useful for viewports e.g. based on Sheet1!A1:LastCell
 
* Tables named range for Last Cell. Useful for viewports e.g. based on Sheet1!A1:LastCell
Line 98: Line 101:
  
 
==Dashboards==
 
==Dashboards==
* [[Dashboards]] Can add pagers  
+
* [[Dashboard_sheets|Dashboards]] Can add pagers  
 
* Dashboards can toggle auto-linking on/off.  
 
* Dashboards can toggle auto-linking on/off.  
 
* Dashboards can mix connections from different cubes with varying hierarchies.  
 
* Dashboards can mix connections from different cubes with varying hierarchies.  
Line 113: Line 116:
 
* [[Table Charts]]  
 
* [[Table Charts]]  
 
* [[Managing Connections]] handle structure changes across reports also updates calculations
 
* [[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=
 
=Excel Edition=
Line 145: Line 149:
 
* Custom validation rule improvements on the web
 
* Custom validation rule improvements on the web
 
* Improved error message logging on the web  
 
* Improved error message logging on the web  
* New download options csv and txt. Options for XL3ReportType and PrintRendererServer web service.  
+
* New [[Downloading reports|download options]] csv and txt. Options for XL3ReportType and PrintRendererServer web service.  
 
* [[Web Development]] JS API - get cell/range value   
 
* [[Web Development]] JS API - get cell/range value   
 
* Allow data access on web to run as AppPool user [[Customising web config|web.config]] setting.  
 
* Allow data access on web to run as AppPool user [[Customising web config|web.config]] setting.  
Line 160: Line 164:
 
* [[XL3WebReportLink#Relative_Paths|Relative path]] support for reports when using the SQL repository
 
* [[XL3WebReportLink#Relative_Paths|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
 
* Original workbook can be published to the repository so can be recovered at a later date
 +
* Option to override the default folder order
  
 
==Printing==
 
==Printing==
Line 176: Line 181:
 
* Allow offline reports to be refreshed
 
* Allow offline reports to be refreshed
 
* Allow scheduled refreshing of offline reports
 
* Allow scheduled refreshing of offline reports
 +
 +
[[Category: Versions]]

Latest revision as of 07:28, 15 April 2019

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

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