Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
OfficeConnect Ad Hoc Analysis

OfficeConnect Ad Hoc Analysis

With this release, we continue to improve the
OfficeConnect
 ad hoc analysis functionality. We now enable users to quickly apply and expand elements, providing faster dimensional analysis.

Apply and Expand Elements

Release: 2021-09-11
We now enable you to apply and expand elements from the Elements pane in a single action. Previously, you had to first apply the element to your report and then expand it as separate actions.
You can use the Apply and Expand option from either areas:
  • The right-click context menu in the Elements pane.
  • The Elements group of buttons in the OfficeConnect tab.

Expand to Any Level

Release: 2021-09-11
We now enable you to expand a parent element to any level within its hierarchy. The default expansion displays only the elements at the hierarchy level you select.
To override the default, uncheck the option to exclude ancestors from the expansion.

Exclude Uncategorized Elements from an Expansion

Release: 2021-09-11
We now provide a new workbook property that enables you to exclude the uncategorized and Only elements from an expansion.
Example: You can exclude these uncategorized and Only elements when you expand the parent element:
  • Prduct (Uncat)
  • United States (Only)

Expand to Any Level with Multiple Parents

Release: 2021-09-11
We now enable you to expand a single parent element to any level within its hierarchy. The default expansion displays only the elements at the hierarchy level that you select.
To override the default option, you can unselect the option to exclude ancestors from the expansion. When multiple parent elements exist at the same location, you can select a single parent to expand in the Elements section.