| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Version 8.1"
(→Visualisation) |
(→General: wikified somewhat; corrected FONT_FLAGS name) |
||
| Line 12: | Line 12: | ||
* Support for "[[MDX Calculations#Dynamic sets|Dynamic]]" sets in client calculations | * Support for "[[MDX Calculations#Dynamic sets|Dynamic]]" sets in client calculations | ||
* Excel "Report Viewer" option - user can't change reports but can run them | * Excel "Report Viewer" option - user can't change reports but can run them | ||
| − | * Show Hierarchy descriptions as tooltips in | + | * Show Hierarchy descriptions as tooltips in [[Report Designer]] |
==Grids== | ==Grids== | ||
| − | * Support for | + | * Support for [https://msdn.microsoft.com/en-us/library/ms145573.aspx FONT_FLAGS] cube formatting |
* [[Active Cell Grid Selections|Active cell tracking]] includes an option to allow clicking on members as well as data cells | * [[Active Cell Grid Selections|Active cell tracking]] includes an option to allow clicking on members as well as data cells | ||
* Additional options to [[Keep Members]] and create sets | * Additional options to [[Keep Members]] and create sets | ||
| − | * Can copy existing member selection in Member Selector | + | * Can copy existing member selection in [[Member Selector]] |
* Grids on tabular cubes support [[Grids on tabular cubes#Dynamic Measures|dynamically created measures]]. | * Grids on tabular cubes support [[Grids on tabular cubes#Dynamic Measures|dynamically created measures]]. | ||
| − | * Member formatting will now apply to member properties | + | * [[Formatting Grids|Member formatting]] will now apply to member properties |
| − | * Ability to format a member based on a member property value | + | * Ability to [[Formatting Grids|format a member]] based on a member property value |
| − | * Group members option in | + | * Group members option in [[Member Selector]] |
* Automatically handle formatting when captions start with "[" | * Automatically handle formatting when captions start with "[" | ||
* Improved advanced member searching - can keep added members and running another search without leaving form | * Improved advanced member searching - can keep added members and running another search without leaving form | ||
| Line 29: | Line 29: | ||
==Tables== | ==Tables== | ||
| − | * Option to Prompt for user id and password on Relational connections | + | * Option to Prompt for user id and password on [[SQL|Relational connections]] |
* Support for more [[Tabular Designer#Advanced filters|DAX table operators]] | * Support for more [[Tabular Designer#Advanced filters|DAX table operators]] | ||
* Support for [[Tabular Designer#Dynamic Measures|dynamically created measures]] | * Support for [[Tabular Designer#Dynamic Measures|dynamically created measures]] | ||
| − | * Transpose | + | * Transpose [[Tables]] |
==Visualisation== | ==Visualisation== | ||
| Line 38: | Line 38: | ||
* Option to format the text in [[Treemaps]] | * Option to format the text in [[Treemaps]] | ||
* Can switch chart type by series | * Can switch chart type by series | ||
| − | * More customisation options for [[Small Multiples]] | + | * More customisation options for [[Small Multiples]]: |
** Axis titles | ** Axis titles | ||
** Data Labels | ** Data Labels | ||
| Line 44: | Line 44: | ||
** Marker style on line graph | ** Marker style on line graph | ||
** Switch connection | ** Switch connection | ||
| − | *Small multiples - configure drill to level | + | * Small multiples - configure drill to level |
| − | *Small multiples can output unique name or caption based on selection | + | * Small multiples can output unique name or caption based on selection |
| − | * Grid | + | * Grid In-cell charts - can switch the member that the chart is based on |
* Format sheet on network location - warning message if network drive not available | * Format sheet on network location - warning message if network drive not available | ||
==Slicers== | ==Slicers== | ||
| − | * Slicer title can be driven from Excel range | + | * [[Dimension Slicers|Slicer]] title can be driven from Excel range |
| − | |||
==Formulae== | ==Formulae== | ||
Revision as of 10:36, 2 June 2015
What's new in XLCubed Version 8.1
Contents
[hide]Main Additions
- Cube Comments
- Viewports
- Support for SAP HANA connections
General
- Support for "Dynamic" sets in client calculations
- Excel "Report Viewer" option - user can't change reports but can run them
- Show Hierarchy descriptions as tooltips in Report Designer
Grids
- Support for FONT_FLAGS cube formatting
- Active cell tracking includes an option to allow clicking on members as well as data cells
- Additional options to Keep Members and create sets
- Can copy existing member selection in Member Selector
- Grids on tabular cubes support dynamically created measures.
- Member formatting will now apply to member properties
- Ability to format a member based on a member property value
- Group members option in Member Selector
- Automatically handle formatting when captions start with "["
- Improved advanced member searching - can keep added members and running another search without leaving form
- NonEmpty advanced member selection option
Tables
- Option to Prompt for user id and password on Relational connections
- Support for more DAX table operators
- Support for dynamically created measures
- Transpose Tables
Visualisation
- Option to format the text in Treemaps
- Can switch chart type by series
- More customisation options for Small Multiples:
- Axis titles
- Data Labels
- Background fill
- Marker style on line graph
- Switch connection
- Small multiples - configure drill to level
- Small multiples can output unique name or caption based on selection
- Grid In-cell charts - can switch the member that the chart is based on
- Format sheet on network location - warning message if network drive not available
Slicers
- Slicer title can be driven from Excel range
Formulae
- XL3Link can set the tooltip
- XL3SetProperty extended:
- Enable/Disable slicers
- Switch Small Multiples between more chart types
- XL3SparkDotPlot
SQL
Scheduling
Web Edition
General
- XLCubedWeb Option to display Reports before Sub-folders in repository view
- Support for printing header and footer images
- Ability to delete reports from the Web UI
- Option for "Keep Alive" from client browser so session doesn't expire
- Workbook option to set the "Download to Excel/PDF" filename
- Warn when leaving a report with unsaved writeback changes
- Option to auto refresh after editing cell value
- Connection mapping - option to not unmap when the file is saved to Excel as live
- LongQueryCancelTimeout setting
- Option to download to Excel any reports that can't be run due to errors
Formulae
- Support for XL3Link to trigger "Active Cell Tracking" when linking to a grid
- XLCubedWeb Option to use Report path instead of Guid when embedding SQL Repository reports
Visualisation
- Support for Pattern fills on published charts
- Improved Small Multiple default formatting
- Camera object zooming support
API
- Web API update to support multi-cell parameters
