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
 
= Web Edition =
 

Revision as of 10:30, 7 September 2012

What's new in XLCubed Version 7.1.


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

  • New incell chart - Lollipop
  • Treemaps
  • Small multiples include a "Missing Data Handling" option

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