OfficeConnect - Miscellaneous Enhancements

For OfficeConnect for Financial Management and Adaptive Planning, worksheets now update separately as they finish refreshing. You don't have to wait for all worksheets in an open workbook to finish refreshing before you can see them updated. The refresh steps for each sheet complete separately and the sheets update separately.

For OfficeConnect for Financial Management and Adaptive Planning, we introduce a new workbook property:

Display unknown elements in worksheet and workbook filters

. When you select this option, users can see an unknown element that corresponds to an element that:

They can't access.
Doesn't exist in the hierarchy for a specific effective date

Example: A user creates a report filter on a specific date and you change the effective date to when the filter element doesn't exist. With the workbook property checked, you can now see the filter as an unknown element.

See Add Elements to Report Filters.

For OfficeConnect for Financial Management, we now extend the ability to report on the 3rd prior year for 3 calendar months of the new fiscal year.

Example: When FY 2024 comes around, we enable you to report on:

2023
2022
2021 for 3 months. After the 3 months, 2021 is dropped.

Previously, you'd lose the 3rd prior year of data when the new fiscal year began.