| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Version 7.5"
(→Slicers) |
|||
| (39 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
What's new in XLCubed Version 7.5. | What's new in XLCubed Version 7.5. | ||
| + | |||
| + | =Main Additions= | ||
| + | * New [[Analytics books|web ad-hoc analytic and reporting]] capability for web based users | ||
| + | * Slice and dice [[Mobile analytics|analytics in Mobile apps]] and devices | ||
| + | * [[Interactive Charting]] | ||
| + | * [[Publishing PowerPivot Reports|Publication and sharing of PowerPivot reports]] | ||
=General= | =General= | ||
| Line 10: | Line 16: | ||
==Visualisation== | ==Visualisation== | ||
* [[Treemaps#Cube|Cube-based treemaps can use custom number formats]] | * [[Treemaps#Cube|Cube-based treemaps can use custom number formats]] | ||
| − | * Interactive | + | * [[Interactive Charting]] |
* In-Cell box plots: [[SparkBox Chart Designer|option to plot a value]] | * In-Cell box plots: [[SparkBox Chart Designer|option to plot a value]] | ||
* In-Cell box plots: [[SparkBox Chart Designer|option to 'other values' as a dot or line]] | * In-Cell box plots: [[SparkBox Chart Designer|option to 'other values' as a dot or line]] | ||
| Line 26: | Line 32: | ||
* [[Dimension_Slicers#Version_7.5|Initial value slicer selection can use multiple cells]] | * [[Dimension_Slicers#Version_7.5|Initial value slicer selection can use multiple cells]] | ||
* [[Dimension_Slicers#Version_7.5|Initial value slicer selection can be applied when its contents changes]] | * [[Dimension_Slicers#Version_7.5|Initial value slicer selection can be applied when its contents changes]] | ||
| − | * New feature - Wait for submit on Web | + | * New feature - [[Dimension_Slicers#Wait_for_Submit_on_Web_.28new_in_v7.5.29|Wait for submit on Web]] |
==Formulae== | ==Formulae== | ||
| − | * XL3GridMember formula changes | + | * [[XL3GridMember]] formula changes |
| + | |||
==Miscellaneous== | ==Miscellaneous== | ||
* Allow picking Measure Group and Display Folders for custom calculated measures | * Allow picking Measure Group and Display Folders for custom calculated measures | ||
| Line 38: | Line 45: | ||
=Excel Edition= | =Excel Edition= | ||
==Grids== | ==Grids== | ||
| − | * Smarter handling of invalid members | + | * [[Managing_cube_structure_changes|Smarter handling of invalid members]] |
* 'Format Cell' option highlights an individual cell | * 'Format Cell' option highlights an individual cell | ||
| − | * Pager control for Grids | + | * [[Pager_Properties|Pager]] control for Grids |
==Miscellaneous== | ==Miscellaneous== | ||
| − | * Propagate across sheets can propagate into a new workbook | + | * [[Propagate_Across_Sheets|Propagate across sheets]] can propagate into a new workbook |
| + | |||
=Web Edition= | =Web Edition= | ||
==General== | ==General== | ||
| − | * Multi-language workbook name and descriptions can be set | + | * New [[Analytics books|web ad-hoc analytic and reporting]] capability for web based users |
| − | * Grids and formula values can be cleared for security | + | * Slice and dice [[Mobile analytics|analytics in Mobile apps]] and devices |
| − | * Cells starting with | + | * [[Publishing PowerPivot Reports|Publication and sharing of PowerPivot reports]] |
| − | * Help button can be redirected to an alternative URL | + | * [[SharePoint|SharePoint 2013 WebPart]] |
| − | + | * [[Workbook_Options|Multi-language]] workbook name and descriptions can be set | |
| − | + | * Grids and formula values can be [[Clear_all_data_values|cleared for security]] | |
| − | + | * Cells starting with [[HTML:]] can be passed to the browser as is (must be enabled on the web server for security) | |
| + | * [[Customising web config|Help button]] can be redirected to an alternative URL | ||
==Formulae== | ==Formulae== | ||
| − | * XL3IsWeb formula | + | * [[XL3IsWeb]] formula |
| − | * XL3WebReportLink supports relative paths | + | * [[XL3WebReportLink]] supports relative paths |
| + | |||
==Scheduling== | ==Scheduling== | ||
| − | |||
* Allow an email alert to be sent based on a limit value | * Allow an email alert to be sent based on a limit value | ||
* Ability to write report out to a network share | * Ability to write report out to a network share | ||
| + | |||
| + | [[Category: Versions]] | ||
Latest revision as of 12:01, 1 July 2015
What's new in XLCubed Version 7.5.
Contents
[hide]Main Additions
- New web ad-hoc analytic and reporting capability for web based users
- Slice and dice analytics in Mobile apps and devices
- Interactive Charting
- Publication and sharing of PowerPivot reports
General
Grids
Tables
- Columns as sections - option to show only changing values
Visualisation
- Cube-based treemaps can use custom number formats
- Interactive Charting
- In-Cell box plots: option to plot a value
- In-Cell box plots: option to 'other values' as a dot or line
- Small Multiple Charts: add support for datapoint tooltip
- Small Multiple Charts: control thickness of line charts
- Small Multiple Charts: control label and legend text attributes
- Small Multiple Charts: support outputting multiple points to a range
- Small Multiple Charts: display trend line
- Small Multiple Charts: output all of the details about an individual data point
- Small Multiple Charts: use an Excel range as a data source
- Small Multiple Charts: use SQL as a data source
- Mobile: Design frame for scaling reports for mobile delivery
Slicers
- Initial value slicer selection can use multiple cells
- Initial value slicer selection can be applied when its contents changes
- New feature - Wait for submit on Web
Formulae
- XL3GridMember formula changes
Miscellaneous
- Allow picking Measure Group and Display Folders for custom calculated measures
- Picture Links
- Drillthrough uses format sheet for formatting
- Option to refresh Grid after an invalid writeback
Excel Edition
Grids
- Smarter handling of invalid members
- 'Format Cell' option highlights an individual cell
- Pager control for Grids
Miscellaneous
- Propagate across sheets can propagate into a new workbook
Web Edition
General
- New web ad-hoc analytic and reporting capability for web based users
- Slice and dice analytics in Mobile apps and devices
- Publication and sharing of PowerPivot reports
- SharePoint 2013 WebPart
- Multi-language workbook name and descriptions can be set
- Grids and formula values can be cleared for security
- Cells starting with HTML: can be passed to the browser as is (must be enabled on the web server for security)
- Help button can be redirected to an alternative URL
Formulae
- XL3IsWeb formula
- XL3WebReportLink supports relative paths
Scheduling
- Allow an email alert to be sent based on a limit value
- Ability to write report out to a network share
