| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Version 7.6"
(→General) |
|||
| (32 intermediate revisions by 4 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= | ||
==Grids== | ==Grids== | ||
| − | Visual Totals | + | *[[Visual Totals]] |
| − | Named ranges - maintain named ranges based on grid areas | + | *[[Named Ranges|Named ranges - maintain named ranges based on grid areas]] |
| − | Drill across | + | *[[Drilling_in_Grids#Drill_Across|Drill across]] |
==Tables== | ==Tables== | ||
| + | *Tabular (DAX) tables now support [[Tabular#Hierarchies|hierarchies]] | ||
| + | *[[Named Ranges|Named ranges - maintain named ranges based on table areas]] | ||
==Visualisation== | ==Visualisation== | ||
| − | Mapping - zoom state saved | + | *Mapping - [[Maps#Initial_view|zoom state saved]] |
| − | Mapping - | + | *Mapping - [[Maps#Custom_style|Layers can be turned off]] |
| − | + | *Mapping - [[Maps#Named places]]Shape transparency and borders can be configured | |
| − | Mapping - Shape transparency and borders can be configured | + | *Mapping - Can plot simple [[Maps#Pie charts|Pie Charts]] |
| − | Mapping - Can plot simple Pie Charts | + | *Small multiples - Improved [[Small_Multiple_Charts#Colours_and_Style|colour configuration]] options |
| − | |||
| + | ==Slicers== | ||
| + | *Tree slicers maintain filters on [[Dimension_Slicers#Use_query_restrictions_for_children_.28new_in_v7.6.29|expansion]] | ||
| − | |||
| − | |||
==Formulae== | ==Formulae== | ||
| − | [[Flex Reporting]] | + | *[[Flex Reporting]] |
| − | [[XL3MemberNavigate]] - added defaultmember option | + | *[[XL3MemberNavigate]] - added defaultmember option |
| + | *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= | ||
==General== | ==General== | ||
| − | [[SharePoint Integration]] | + | *[[SharePoint Integration]] |
| − | + | *Published connections can be used for Adhoc grids | |
| − | + | *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
