Difference between revisions of "Version 7.1"

(Grids)
m (Text replacement - "XLCubed" to "FluenceXL")
 
(14 intermediate revisions by 3 users not shown)
Line 1: Line 1:
What's new in XLCubed Version 7.1.
+
What's new in FluenceXL Version 7.1.
  
  
Line 7: Line 7:
 
* Level based formatting has been improved (you can now use the syntax LEVEL: 3 to format all members at level 3 of the dimension)
 
* 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
 
* 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
+
* Client side named sets can now be created in the member selector
 +
* An option to display Member properties at different levels, but with the same name, in a single column
  
 
== Tables ==
 
== Tables ==
 
* The number of rows to display using the [[Tables#Paging | pager]] control can now come from an Excel Range
 
* 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
+
* Additional layout options for the paging control
 
* Column headers can be removed from tables using a new property
 
* Column headers can be removed from tables using a new property
  
Line 17: Line 18:
  
 
* New incell chart - [[Lollipop Chart Designer | Lollipop]]
 
* New incell chart - [[Lollipop Chart Designer | Lollipop]]
* [[Treemaps]]
+
* [[Treemaps]] can be created with the data sourced from cubes, SQL, or an Excel range
 
* Small multiples include a "Missing Data Handling" option
 
* Small multiples include a "Missing Data Handling" option
  
 
== Slicers ==
 
== Slicers ==
  
* New Date slicer type
+
* New [[Date Slicer | Date Slicer]]
* New Member selector slicer type
+
* New [[Member Selector Slicer | Member Selector Slicer]]
  
 
== Scheduling ==
 
== Scheduling ==
Line 32: Line 33:
  
 
== General ==
 
== General ==
* Excel 2013 will be detected by the installation
+
* Support for Excel 2013
* Support for connceting to PowerPivot
+
* Support for connecting to PowerPivot workbooks
* New License keys can now be applied when in the "License Key" dialog
+
* [[Converting ProClarity Reports|ProClarity]] Briefing Books can be imported directly into FluenceXL
* [[Converting ProClarity Reports|ProClarity]] Briefing Books can be imported directly into XLCubed
+
* Improved license registration dialogs
  
 
== Grids ==
 
== Grids ==
  
* The member property selection screen has be redesigned and the order of the member properties can now be controlled
+
* The member property selection screen has be redesigned and the order of the member properties can now be easily modified
* The report designer now includes a measure group selector - this will show only the hierarchies that are related to the selected measure group
+
* The report designer now includes a measure group selector - enables quick filtering of the hierarchies by measure group
 
* Hovering over a selected member will show the complete path to reach that member (i.e. 2012 -> Q1 -> Jan 2012)
 
* 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
 
* Grids can be edited by double-clicking in the data area
* Named sets can now be created in the Member Selector (Highlight the members required, right-click and select "Create Named Set"0
+
* Named sets can now be created in the Member Selector (Highlight the members required, right-click and select "Create Named Set")
  
 
== Tables ==
 
== Tables ==
Line 51: Line 52:
  
 
* Any cube level errors (#queryex) can now be viewed using Extras -> Trace Formula Errors
 
* Any cube level errors (#queryex) can now be viewed using Extras -> Trace Formula Errors
* [[Xl3RunSQLProc]]
+
* [[XL3RunSQLProc]]
* New options for XL3SetProperty:
+
* New options for [[XL3SetProperty]]:
 
** "SortColumns" to control the columns to use for sorting data tables
 
** "SortColumns" to control the columns to use for sorting data tables
 
* "Recalc Range" added to ribbon, will recalculate the selected range
 
* "Recalc Range" added to ribbon, will recalculate the selected range
Line 60: Line 61:
  
 
* All colour selections now show the 2007/2010 colour profiles (for Excel 2003 users the colour selection remains the same)
 
* 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 [[Adding Round Corners to Excel | Round Corners]]
+
* New option to easily create [[Adding Round Corners to Excel | Round Corners]] for dashboards and scorecards
  
 
== Workbook Options ==
 
== 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
+
* The ability to specify a worksheet protection password, this allows FluenceXL 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
 +
 +
[[Category: Versions]]

Latest revision as of 09:32, 4 July 2023

What's new in FluenceXL 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
  • Client side named sets can now be created in the member selector
  • An option to display Member properties at different levels, but 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
  • Additional layout options for the paging control
  • Column headers can be removed from tables using a new property

Visualisation

  • New incell chart - Lollipop
  • Treemaps can be created with the data sourced from cubes, SQL, or an Excel range
  • Small multiples include a "Missing Data Handling" option

Slicers

Scheduling

  • Scheduling distribution groups can now come for a SQL Query

Excel Edition

General

  • Support for Excel 2013
  • Support for connecting to PowerPivot workbooks
  • ProClarity Briefing Books can be imported directly into FluenceXL
  • Improved license registration dialogs

Grids

  • The member property selection screen has be redesigned and the order of the member properties can now be easily modified
  • The report designer now includes a measure group selector - enables quick filtering of the hierarchies by 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
  • Named sets can now be created in the Member Selector (Highlight the members required, right-click and select "Create Named Set")

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
  • New formulae XL3RefreshObjects and XL3RefreshObjectsNamed, can be used to trigger refreshes of grids, slicers etc. using XL3Link

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 for dashboards and scorecards

Workbook Options

  • The ability to specify a worksheet protection password, this allows FluenceXL 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