Office Integration
Ad-hoc report
Ad-hoc reports provide a new way of creating reports in Excel Integration. Users can define the filters, columns, and rows of a report all at once instead of separately plotting them. The initial version of this feature includes the ability to define element subsets for filters, and hierarchies for rows, and columns. It allows expanding and collapsing on rows or column elements. Selection of element subsets for rows and columns is not available with this version of ad-hoc reporting.
New recalculation options
To address customer feedback, we have changed the behavior for when Infor functions are refreshed by adding three new options for recalculating reports in Excel Integration. These options are available:
- Recalculate Workbook
- Recalculate Sheet
- Recalculate Selected Area
These options enable you to share a report with someone who does not have access to Excel Integration.
New dynamic array functions
Two new functions for building reports are now available: INFOR.GET.AXIS and INFOR.READ.VALUES. You can
use INFOR.GET.AXIS to define columns and rows as dynamic
arrays and then use a single INFOR.READ.VALUES function to
retrieve a matrix of values for given axes and filters. This approach not only significantly
decreases the number of formulas in the report, which improves performance, but it can also
be used to build semi-dynamic reports. These functions are currently a preview of the
functionality and may be subject to change in future versions.