FP&A Cloud Release Notes
2022.4.0
November 2022
Release notes describe the enhancements and bug fixes contained in new releases and maintenance releases.
Tip: To find the release note that contains a specific issue, search on the Prophix Support Desk ticket number.
Support for Microsoft 365
Analyzer and Contributor support Microsoft 365 using monthly or Semi Annual Channels.
Note: Microsoft Office 2019 and Office 2016 perpetual licensed editions are not supported.
What's new
Ad Hoc Analysis
-
MDX errors can now be viewed in Cell Properties: When an MDX calculation returns an error, the cell shows #Err. To see the details of the error, select View > Cell Properties. The error details appears in Miscellaneous:
Improved communication of cloud maintenance events
- Administrators: In Notifications Hub, Administrators now receive notifications for cloud maintenance events that are about to start, are underway, or have completed.
- Optionally, clicking a notification opens status.prophix.cloud at the page related to the maintenance event.
- If you are set up in Notifications Hub to receive email messages, then you will get an email for the event as well.
-
All users: An hour before maintenance, all users receive a popup message; clicking More details opens status.prophix.cloud at the page related to the maintenance event.
Model Manager
-
Pre-defined Calculated member types for Version and Time Perspective: In addition to the existing custom Calculated member type that requires knowledge of MDX, you can now choose from four of the most common calculated types and your calculation definition's MDX is created automatically.
In Add Member select a pre-defined calculation type plus its required parameters. After you complete the definition, your MDX appears in the Calculation Definition drawer:
The pre-defined calculation types are as follows:
- Time Perspective:
- Average to Date – Reports the average from the start of the year to the current month.
- Life to Date – Reports the sum of the life-to-date for the entire Time dimension.
Rolling Last N Periods – Reports the sum or average of the number of periods you specify.
- Version:
- Prior Period – Reports backwards one period from the currently selected time period, for a specific Version and Time level.
- Time Perspective:
Templates
- Choice of row filtering modes: For dimensions that have row filtering enabled, you can now choose between the original filtering behavior (all the leaf members of the selected non-leaf member are returned) or having returned only the members that you select (whether non-leaf or leaf).
The new Resolve to Leaf option is turned off by default; to use the original row filtering behavior, turn on the option:
Resolved issues
Note that the current build is always cumulative: it contains all previous patches.
| Released | Ticket number | Area | Description |
|---|---|---|---|
| November | 138562,139860 | Ad Hoc Analysis | After manually saving a data view, the Save successful "toast" message failed to appear. |
| November | 92228 | Browser | Changing pages quickly in Firefox caused the error: MacroTask requestAnimationFrame. |
| November | 96494, 133853 | Cell Comments | Error: Column '<DIMENSION.Alternate Hierarchy Name>' does not belong to table PivotedFlag. |
| November | 137389 | DPM | When adding or editing DPOs received a DPM Timeout message. |
| November | 126231 | DP Schedules | When copying and pasting in a schedule, if the element contains parentheses () the schedule did not save. |
| November | 128127, 139253, 141125 | DP Schedules | The Date Difference calculation returned an incorrect result in the DPO Summary tab compared to the DPM schedule. |
| November | 120625 | Drill Across | Including the Contract column in the Drill Across definition caused an error. |
| November | 134754 | Model Manager | The procedural calculation was not updating the account. |
| November | 135956 | Model Manager | Doing data entry to a daily cube resulted in errors after a set of accounts with procedural calculations were added. |
| November | 94028 | Process Manager | When running the Report Binder process users assigned a Standard license received a warning. |
| November | 129230 | Process Manager | A scheduled process failed to run on its specified end date. |
| November | 134134 | Process Manager | In the Import process, a high maximum number of rejected records caused import performance issues1. |
| November | 135203 | Process Manager | In the DP Import process, changing the settings in the General or Source tabs cleared the selections in the Target Mapping tab's mapping table. |
| November | 106041 | Process Manager | In the Infoflex process, referencing an empty named set returned a result of Success instead of Invalid. |
| November | 131978, 135663 | Report Binder | Report binders were ignoring the custom color scheme in web.config. |
| November | 132824 | System Hub | Under Login Events, authorization access errors showed nothing in the User ID and Name columns. |
| November | 127720,128611 | Template Studio | In the Edit Page Hierarchy Groups dialog, changing Member display for the Time dimension caused an error. |
| November | 135832, 139064, 139233 | Template Studio | When editing page hierarchy groups, selecting/deselecting Include resulted in other hierarchy data views in the grid being randomly selected/unselected. |
| November | 136639, 135959, 135682 | Templates | The Indent rows option was not working. |
| November | 140511, 140066 | Workflow Tasks | When certain users selected Workflow Tasks from the main menu, a timeout error occurred. |
1The maximum number of unique rejected records is now 1,000. Note the following:
- If you run an existing Import Data process and if its maximum number of unique rejected records was previously greater than 1,000, the maximum is now limited to 1,000.
- In Process Manager, if you select an existing Import Data process, the user interface now validates that the maximum number of rejected records is between 0 and 1,000 (otherwise a red border appears).
Known issues
| Area | Description | Workaround |
|---|---|---|
| Data Integration Service | When using ODBC as the Destination, field names that contain keywords or reserved words from the Source will not map and the process will fail. | An upcoming release will address this issue. |
| Data Integration Service | When using ODBC as the Destination and with text or Excel as the Source, if the Connection has Column name in first row turned off, then mapping will fail and the process will fail. | An upcoming release will address this issue. |
| Data Integration Service | When using Acumatica as the Source and AcccountSummaryInquiry as the query object, and if there are no query filters, the Data Integration process fails, returning the error message [Error: Timedout]: The job timed out. | In the query, add a filter condition to the Period field. |
| Detailed Planning Schedules |
When adding a new object/employee by populating the fields of the Add Employee Member dialog, upon returning to the schedule red borders appear around some cells and remain until the schedule is saved.
|
No workaround is necessary. This is a cosmetic bug only. An upcoming release will address this issue. |
| Process Notifications | When a process finishes, its notifications fail to appear, both in the Notifications Hub and as an email. | To see whether a process has completed, in Process Manager open the Task Log. |
