| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Version 7.6"
(added link to Named Grid Ranges) |
(→General) |
||
| (12 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
=Main Additions= | =Main Additions= | ||
| + | *[[Flex Reporting]] lets report builders define custom drill paths at a report level. This can be used to deliver a drill down logic not directly provided in the cube (for example Product -> Geography -> Promotion), and to give report users the flexibility to expand the data by the provided drill paths while shielding them from the overall complexity of the full hierarchy model of the cube. | ||
| + | |||
| + | *[[SharePoint Integration]] is now entirely seamless from a user perspective. Simply connect XLCubed Excel Edition to the SharePoint server and publish your report. It is then available in SharePoint as with any other report and benefits from version history and site search. | ||
=General= | =General= | ||
| Line 7: | Line 10: | ||
==Grids== | ==Grids== | ||
*[[Visual Totals]] | *[[Visual Totals]] | ||
| − | *[[Named | + | *[[Named Ranges|Named ranges - maintain named ranges based on grid areas]] |
*[[Drilling_in_Grids#Drill_Across|Drill across]] | *[[Drilling_in_Grids#Drill_Across|Drill across]] | ||
==Tables== | ==Tables== | ||
*Tabular (DAX) tables now support [[Tabular#Hierarchies|hierarchies]] | *Tabular (DAX) tables now support [[Tabular#Hierarchies|hierarchies]] | ||
| − | *Named ranges - maintain named ranges based on table areas | + | *[[Named Ranges|Named ranges - maintain named ranges based on table areas]] |
==Visualisation== | ==Visualisation== | ||
| Line 28: | Line 31: | ||
*[[XL3MemberNavigate]] - added defaultmember option | *[[XL3MemberNavigate]] - added defaultmember option | ||
*New Workbook option: [[Workbook_Options#Formula_Options|Lighten background colour on drill]] | *New Workbook option: [[Workbook_Options#Formula_Options|Lighten background colour on drill]] | ||
| + | |||
| + | ==SQL== | ||
| + | *[[SQL|SQL Tables and Slicers]] now support parameters with [[Using_SQL_Parameters|multiple values]] | ||
=Web Edition= | =Web Edition= | ||
| Line 33: | Line 39: | ||
*[[SharePoint Integration]] | *[[SharePoint Integration]] | ||
*Published connections can be used for Adhoc grids | *Published connections can be used for Adhoc grids | ||
| − | *Published connections will merge calculations with workbook calculations | + | *Published connections will merge [[MDX Calculations|calculations]] with workbook calculations |
| + | |||
| + | [[Category: Versions]] | ||
Latest revision as of 12:02, 1 July 2015
What's new in XLCubed Version 7.6.
Contents
[hide]Main Additions
- Flex Reporting lets report builders define custom drill paths at a report level. This can be used to deliver a drill down logic not directly provided in the cube (for example Product -> Geography -> Promotion), and to give report users the flexibility to expand the data by the provided drill paths while shielding them from the overall complexity of the full hierarchy model of the cube.
- SharePoint Integration is now entirely seamless from a user perspective. Simply connect XLCubed Excel Edition to the SharePoint server and publish your report. It is then available in SharePoint as with any other report and benefits from version history and site search.
General
Grids
Tables
- Tabular (DAX) tables now support hierarchies
- Named ranges - maintain named ranges based on table areas
Visualisation
- Mapping - zoom state saved
- Mapping - Layers can be turned off
- Mapping - Maps#Named placesShape transparency and borders can be configured
- Mapping - Can plot simple Pie Charts
- Small multiples - Improved colour configuration options
Slicers
- Tree slicers maintain filters on expansion
Formulae
- Flex Reporting
- XL3MemberNavigate - added defaultmember option
- New Workbook option: Lighten background colour on drill
SQL
- SQL Tables and Slicers now support parameters with multiple values
Web Edition
General
- SharePoint Integration
- Published connections can be used for Adhoc grids
- Published connections will merge calculations with workbook calculations
