Difference between revisions of "Version 7.1"
(→Workbook Options) |
|||
Line 3: | Line 3: | ||
= General = | = General = | ||
+ | |||
+ | == Grids == | ||
+ | * Level based formatting has been improved (you can now use the syntax LEVEL: 3 to format all members at level 3 of the dimension) | ||
+ | * Named sets are now displayed as part of the member selector | ||
+ | * An option to display Member properties with the same name in a single column | ||
+ | |||
+ | == Tables == | ||
+ | * The number of rows to display using the [[Tables#Paging | pager]] control can now come from an Excel Range | ||
+ | * The layout of the paging control can now be changed | ||
+ | * Column headers can be removed from tables using a new property | ||
== Visualisation == | == Visualisation == | ||
Line 8: | Line 18: | ||
* New incell chart - [[Lollipop Chart Designer | Lollipop]] | * New incell chart - [[Lollipop Chart Designer | Lollipop]] | ||
* [[Treemaps]] | * [[Treemaps]] | ||
+ | * Small multiples include a "Missing Data Handling" option | ||
+ | |||
+ | == Slicers == | ||
+ | |||
+ | * New Date slicer type | ||
+ | * New Member selector slicer type | ||
= Excel Edition = | = Excel Edition = | ||
+ | |||
+ | == General == | ||
+ | * Excel 2013 will be detected by the installation | ||
+ | * Support for connceting to PowerPivot | ||
+ | * New License keys can now be applied when in the "License Key" dialog | ||
+ | |||
+ | == Grids == | ||
+ | |||
+ | * The member property selection screen has be redesigned and the order of the member properties can now be controlled | ||
+ | * The report designer now includes a measure group selector - this will show only the hierarchies that are related to the selected measure group | ||
+ | * Hovering over a selected member will show the complete path to reach that member (i.e. 2012 -> Q1 -> Jan 2012) | ||
+ | * Grids can be edited by double-clicking in the data area | ||
+ | |||
+ | == Tables == | ||
+ | * DAX tables now include a "Add Slicer" shortcut | ||
+ | |||
+ | == Formulas == | ||
+ | |||
+ | * Any cube level errors (#queryex) can now be viewed using Extras -> Trace Formula Errors | ||
+ | * [[Xl3RunSQLProc]] | ||
+ | * New options for XL3SetProperty: | ||
+ | ** "SortColumns" to control the columns to use for sorting data tables | ||
+ | * "Recalc Range" added to ribbon, will recalculate the selected range | ||
+ | |||
+ | == Visualisation == | ||
+ | |||
+ | * All colour selections now show the 2007/2010 colour profiles (for Excel 2003 users the colour selection remains the same) | ||
+ | * New option to easily create [[Round Corners]] | ||
== Workbook Options == | == Workbook Options == | ||
Line 15: | Line 59: | ||
* The ability to provide a worksheet protection password, this will allow XLCubed to work with protected workbooks; unlocking and re locking the worksheets as required | * The ability to provide a worksheet protection password, this will allow XLCubed to work with protected workbooks; unlocking and re locking the worksheets as required | ||
* "Save to Excel" as live can now be disabled for a specific workbook | * "Save to Excel" as live can now be disabled for a specific workbook | ||
− | |||
− |
Revision as of 10:30, 7 September 2012
What's new in XLCubed Version 7.1.
Contents
General
Grids
- Level based formatting has been improved (you can now use the syntax LEVEL: 3 to format all members at level 3 of the dimension)
- Named sets are now displayed as part of the member selector
- An option to display Member properties with the same name in a single column
Tables
- The number of rows to display using the pager control can now come from an Excel Range
- The layout of the paging control can now be changed
- Column headers can be removed from tables using a new property
Visualisation
Slicers
- New Date slicer type
- New Member selector slicer type
Excel Edition
General
- Excel 2013 will be detected by the installation
- Support for connceting to PowerPivot
- New License keys can now be applied when in the "License Key" dialog
Grids
- The member property selection screen has be redesigned and the order of the member properties can now be controlled
- The report designer now includes a measure group selector - this will show only the hierarchies that are related to the selected measure group
- Hovering over a selected member will show the complete path to reach that member (i.e. 2012 -> Q1 -> Jan 2012)
- Grids can be edited by double-clicking in the data area
Tables
- DAX tables now include a "Add Slicer" shortcut
Formulas
- Any cube level errors (#queryex) can now be viewed using Extras -> Trace Formula Errors
- Xl3RunSQLProc
- New options for XL3SetProperty:
- "SortColumns" to control the columns to use for sorting data tables
- "Recalc Range" added to ribbon, will recalculate the selected range
Visualisation
- All colour selections now show the 2007/2010 colour profiles (for Excel 2003 users the colour selection remains the same)
- New option to easily create Round Corners
Workbook Options
- The ability to provide a worksheet protection password, this will allow XLCubed to work with protected workbooks; unlocking and re locking the worksheets as required
- "Save to Excel" as live can now be disabled for a specific workbook