Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Reporting and OfficeConnect

Preview the features of our upcoming release. Details are subject to change.

2017.3 Release Notes:  Build reports with faster formatting and interface enhancements, use attributes in calculations, and apply comprehensive settings for blanks and zeros in OfficeConnect.

Intuitive Report Building 

Faster Formatting

Save time when building or editing a report: select multiple elements within the same axis and tier and update the settings. You'll be able to apply style and number settings in one step. 


Calculate Attributes in Reports

Drag and drop subtotal, difference and custom calculations into an attribute tier on a matrix report, and treat attributes like standard dimensions.

Identify Dimension and Attribute Elements

When building a report, hover over elements to identify if they are attributes or dimensions

Manage Hierarchies

At-a-glance icons let you know if an element will appear as an expanded list  or a collapsed list  in the report.

Favorites  Fly-Out Menu

Find and select your favorite reports from the navigation fly-out menu, just like you do for sheets. 


New Settings for Blanks and Zeros

Use new settings to control how your reports display cells with no data and how report viewers can suppress zeros and blanks.  

User Settings

From the OfficeConnect ribbon, the User Settings control the default display of blank data for any new OfficeConnect workbook that you create. Choose to show zeros for blank data or clear the setting to show blanks. 

User Settings, General Tab

Workbook Properties

The Format tab in Workbook Properties controls the settings for the current workbook reports. Choose to show zeros for blank data or clear the setting to show blanks. 

Workbook Properties, Format Tab

Hide Zeros & Blanks Button

Hide zeros, and blanks now too, according to the settings defined in Workbook Properties > Format.

OfficeConnect task ribbon with the new Hide Zeros and Blanks button

More Windows Compatibility

New Support for Excel Keyboard Shortcuts

OfficeConnect now supports more Excel keyboard shortcuts:

  • Alt+R to insert a row
  • Alt+C to insert a column
  • Ctrl+Y to repeat insert column/row actions and delete rows/columns.
New Support for High DPI Displays

We’ve updated OfficeConnect’s UI to scale correctly on high DPI displays. If you have a new laptop or 4K monitor, you can now use OfficeConnect without reducing the Windows scaling setting.

Installation and Update Requirements

To update per-user installations of OfficeConnect to version 2017.3, you'll need Windows administrative permissions. For forthcoming versions, you'll be able to update without administrative permissions.

  • Was this article helpful?