| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Version 8.1"
(→Tables) |
|||
| (91 intermediate revisions by 6 users not shown) | |||
| Line 11: | Line 11: | ||
* 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 | |
| + | * Show [[Report Designer#Hierarchy Descriptions|Hierarchy Descriptions]] as tooltips in Report Designer | ||
| + | * Ability to set time in seconds before [[XLCubed Options#Data Options|long queries]] will be cancelled | ||
==Grids== | ==Grids== | ||
| − | + | * Support for [https://msdn.microsoft.com/en-us/library/ms145573.aspx FONT_FLAGS] cube formatting | |
| − | * Support for | + | * [[Active Cell Grid Selections#Track on Member Cells|Active cell tracking]] includes an option to allow clicking on members as well as data cells |
| − | * Active cell tracking includes an option to allow clicking on | + | * Additional options to [[Keep Members]] and create sets |
| − | * | + | * Can [[Hierarchy Editor#Copy Existing Member|Copy Existing Member]] selection in [[Member Selector]] |
| − | + | * Grids on tabular cubes support [[Grids on tabular cubes#Dynamic Measures|dynamically created measures]]. | |
| + | * [[Formatting_Grids|Member formatting]] will now apply to member properties | ||
| + | * Ability to [[Formatting Grids#Format_by_Member_Property|format a member]] based on a member property value | ||
| + | * Group members option in [[Hierarchy Editor#Group Members in Member Selector|Member Selector]] | ||
| + | * Improved [[Set Searching|Advanced member searching]] - can keep added members and running another search without leaving form | ||
| + | * [[Ranking,_Sorting_and_Filtering#Non_Empty|NonEmpty]] advanced member selection option | ||
==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]] | ||
| + | * [[Table Properties#Formatting|Transpose]] Tables | ||
==Visualisation== | ==Visualisation== | ||
| − | * Option to format the text in [[Treemaps]] | + | * Option to format the text in [[Treemaps#Formatting|Treemaps]] |
| − | * Can | + | * Can [[Small Multiple Charts#Switch Chart Type|Switch Chart Type]] by series for Small Multiple Charts |
| − | * More customisation options for Small Multiples | + | * More customisation options for [[Small Multiples]]: |
** Axis titles | ** Axis titles | ||
** Data Labels | ** Data Labels | ||
** Background fill | ** Background fill | ||
| + | ** Marker style on line graph | ||
** Switch connection | ** Switch connection | ||
| − | *Small | + | ** Spacing |
| − | *Small | + | * [[Small Multiples]] - configure [[Small_Multiple_Charts#Drill_Into:_for_a_breakdown_on_the_Column|drill to level]] |
| − | * | + | * Small Multiples can output [[Small Multiples#Behaviour|Unique Name or Caption]] based on selection |
| + | * Can [[In-Cell Charts in Grids#Switch Members|Switch Members]] on which In-Cell charts are based | ||
| + | * [[Format Sheet|Format Sheet]] on network location - warning message if network drive not available | ||
==Slicers== | ==Slicers== | ||
| − | * Slicer | + | * [[Dimension Slicers#Slicer Title from Excel range (new in v8.1)|Slicer Title]] can be driven from Excel range |
| − | |||
==Formulae== | ==Formulae== | ||
| − | * XL3Link can set the tooltip | + | * [[XL3Link]] can set the tooltip |
| − | + | * [[XL3SetProperty]] extended: | |
| + | **[[XL3SetProperty#Slicer|Enable/Disable slicers]] | ||
| + | **[[XL3SetProperty#SmallMultiple|Switch Small Multiples]] between more chart types | ||
| + | * [[XL3SparkDotPlot]] | ||
==SQL== | ==SQL== | ||
| Line 55: | Line 69: | ||
==General== | ==General== | ||
| − | * web | + | * [[Customising web config|XLCubedWeb Option]] to display Reports before Sub-folders in repository view |
* Support for printing header and footer images | * Support for printing header and footer images | ||
| − | * Ability to delete reports from the Web UI | + | * Ability to delete reports from the [[Web HomePage|Web UI]] |
| + | * [[Customising web config|Keep Alive]] option from client browser so session doesn't expire | ||
| + | * [[Workbook Options#Web Publication| Workbook option]] to set the "Download to Excel/PDF" filename | ||
| + | * Warn when leaving a report with unsaved [[writeback]] changes | ||
| + | * [[Workbook_Options#Web_Publication|Option]] to auto refresh after editing cell value | ||
| + | * [[Connection Mapping | Connection mapping]] - option to not unmap when the file is saved to Excel as live | ||
| + | * Option to download to Excel any reports that can't be run due to errors, [[Rescue workbook]] | ||
==Formulae== | ==Formulae== | ||
| − | * Support for XL3Link to trigger "Active Cell Tracking" when linking to a grid | + | * Support for XL3Link to trigger [[Active Cell Grid Selections|"Active Cell Tracking"]] when linking to a grid |
==SharePoint== | ==SharePoint== | ||
| − | * Option to use Report path instead of Guid when embedding SQL Repository reports | + | * [[Customising web config|XLCubedWeb Option]] to use Report path instead of Guid when embedding SQL Repository reports |
==Visualisation== | ==Visualisation== | ||
| − | + | *[[Viewports]] - an interactive and scrollable control which can display content held in another part of the workbook. Very useful for report layout where one or more data areas can change in size. | |
* Support for Pattern fills on published charts | * Support for Pattern fills on published charts | ||
* Improved Small Multiple default formatting | * Improved Small Multiple default formatting | ||
| − | + | * Camera object zooming support | |
==API== | ==API== | ||
* Web API update to support multi-cell parameters | * Web API update to support multi-cell parameters | ||
| + | |||
| + | [[Category: Versions]] | ||
Latest revision as of 11:07, 5 February 2018
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
- Ability to set time in seconds before long queries will be cancelled
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
- 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 for Small Multiple Charts
- More customisation options for Small Multiples:
- Axis titles
- Data Labels
- Background fill
- Marker style on line graph
- Switch connection
- Spacing
- Small Multiples - configure drill to level
- Small Multiples can output Unique Name or Caption based on selection
- Can Switch Members on which In-Cell charts are based
- 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
- Keep Alive option 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
- Option to download to Excel any reports that can't be run due to errors, Rescue workbook
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
- Viewports - an interactive and scrollable control which can display content held in another part of the workbook. Very useful for report layout where one or more data areas can change in size.
- 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
