Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • Version 8

    What's new in XLCubed Version 8.

    Main Additions

    Enhanced User Interface for XLCubed Web Edition

    Richer Control and Operational Reporting option for XLCubed Web Enterprise. Reports can now be published to an SQL database rather than fileshare, which provides for more straightforward security management, report version control, and operational reporting on usage etc.

    XLCubed Scheduling enhancements

    Multi-sheet Web Printing - this is a new option to allow for Propagate Across Sheets style printing and saving to Excel from the Web Edition, producing multi-paged PDFs or multi-sheet workbooks from a single worksheet.

    Slicer Enhancements

    General Navigation and usability enhancements

    Data Visualisation

    • Bump Charts - to show changes in rank position over time

    Connectivity

    • SAP HANA odbo connector (available as beta with teh release of V8)
    • Teradata available as new SQL connection

    General

    • Advanced Workbook Open Options - Hold shift when opening a workbook to handle invalid members or temporarily disable XLCubed functionality
    • Named range support - named ranges can be used as the source for any range driven items and will stay linked to the named range
    • Right-click menu speed up in Excel 2013
    • Import & Export custom calculations
    • Search in Custom Calculations
    • Support for SCOPE in custom calculation scripts
    • Pagers can input and output entirely to Excel ranges
    • Bulk edit properties - edit properties for several grids/slicers etc at the same time
    • Workbook Explorer: gives an overview of all the objects in a workbook
    • Design Mode: edit grid layout without running any queries
    • Copy and Paste lists into editable cells on the web
      • Accepts lists in plain text or ranges copied from Excel.

    Grids

    • Back and forward controls on Grids
    • Option for non-pinned Grid Calculations (i.e. always show at position x)
    • Grid Calculations can be re-ordered
    • New option for member search: "Does not include"
    • Support aliasing, to rename dimensions and members
    • Option to display member property instead of member caption in all dialogs and results
    • "Apply" button on member selector
    • Filter measure can be range driven
    • Grid Charts: highest level option
    • "Order By" member property in advanced sorting
    • Outlier Grouping - option to always include a specified member (either in the ranking/filtering or as an additional row)
    • Option to format Leaf members in a grid
    • New option to select the "Default Member" in member selections
      • A new toolbar button on the advanced tab of the member selector
    • Grid Ribbon: new option to create grouped members and named sets

    Tables

    • Support for "OData" datasources

    Visualisation

    • Cube-based Treemaps: size and colour can be driven from an Excel Range
    • Treemaps: Specify formatting of treemaps
    • Small multiples: Can apply number format to x and y-axis
    • Small multiples: Option to hide border
    • Small multiples: data driven x-axis min and max values
    • Small multiples: New Bump Charts chart type
    • Maps: option to select colour for "Blank" values
    • New: SparkHeatMap
    • Heatmaps - XL3SparkHeatMap() formula

    Slicers

    Formulae

    SQL

    • Centralised connections - all formula take a connection id and any SQL driven objects use the same central connection, so they can be edited under the standard Manage Connections form
    • Added support for "Teradata" to the SQL Connection form

    Scheduling

    • Support for HTML formatting

    Web Edition

    General

    • New improved look and feel
    • SQL Repository
    • Custom or automatic preview images of reports
    • Option to view: Most recent, Most viewed, Popular and Bookmarked reports on the homepage
    • Add support for including a custom logo
    • Advanced Member searching option
    • Web edition connection history can be edited
    • Retain chart names when saving back into Excel
    • Support for Excel data validation
    • Mutli-line editing for unlocked cells on the web
      • Ctrl+Enter creates a new line
    • Connection Mapping support for SQL Connections
    • Dependency Explorer - check sheet calculation dependencies from Excel
    • New option to Hide Sheet Tabs when publishing

    Formulae

    SharePoint

    • Support for saving reports when viewing them in SharePoint
    • Support for adhoc grids
    • Support for Analytic Books
    • Option to enable Mobile app access to SharePoint published reports