Prophix Cloud Release Notes
2022.3.0
August 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
Dashboard Studio
-
Reverse a column's direction: In a waterfall chart, you can now reverse the direction of any column.
-
Availability of the Autotext option: Now when editing badge tiles or chart tiles, if the data view has no page dimensions, the Autotext option is hidden. (This behavior is to be consistent with that of Template Studio.)
-
Set Display Units for the value axes: For all x-y chart types (column, bar, line, area, and combo) you can now select the Display Units in both the Primary Value Axis drawer and the Secondary Value Axis drawer, and the data labels of the plotted series also inherit and display the selected units.
Detailed Planning Manager
- The effect of offline cubes:
- You cannot open the Administration drawer when the Detailed Planning cube or a linked cube is offline.
- You cannot open a Detailed Planning Schedule if it uses a Detailed Planning cube that is offline.
Process Manager
- Two new processes specifically for line item details:
- The Export Line Item Details process allows you to export existing line item details from your cube to an Excel file.
- The Import Line Item Details process enables creating line item details in Excel and importing them to your cube.
- These processes can be combined to migrate line item details between cubes.
Analyzer
- Analyzer adds two new functions:
- PROPHIX.GETMEMBERKEY() returns a member key or a custom member property (taking a cube and a single-member named set for arguments).
PROPHIX.SETVALUE() updates a cube value (taking a formula, cube, and member combination for arguments).
Caution: PROPHIX.SETVALUE() formulas should not reside in the same worksheet as an Analyzer data view. If they are on the same page, there is a risk that when the data view is refreshed, the PROPHIX.SETVALUE() function could write a blank value to the cube.
Note: Each time that Prophix updates Analyzer with new functions, to access them Microsoft requires that you perform a couple of simple steps.
Resolved issues
Note that the current build is always cumulative: it contains all previous patches.
| Released | Ticket number | Area | Description |
|---|---|---|---|
| August | 135445, 135450, 135449, 135447, 135442, 135433, 135419 | Dashboard Studio | When opening a dashboard, non-admin users received the error: Content no longer available. Please contact your administrator. |
| August | 129999, 131896 | Line Item Reports | The report showed zero values when the member selections were for two versions, but if only one version was selected the values were correct. |
| August | 128922 | Model Manager | Could not extend the Time dimension. |
| August | 130911 | Model Manager | Was unable to delete a DPM cube due to a Foreign Key constraint. |
| August | 117151 | Process Manager | The Import Data process did not work properly if spaces preceded one or more values in the source file. |
| August | 133805 | Process Manager | After running the DPM Post process the results were not reflected in Model Manager. |
| August | 130132 | Process Manager | After running the Import Data process and having rejected records, Unique Reason for Rejection was blank. |
| August | 136348 | Process Manager | The Import Mapping Table process returned an error. |
| August | 134307 | Security Manager | Could not save after removing functions from a role. |
| August | 130023 | Template Charts | Saving a template chart to PDF resulted in legend series labels that were inconsistent and looked bad. |
| August | 132725 | Template Runtime | Attempting to do data entry on values and row notes at the same time caused an error. |
| August | 1297601 | Template Runtime | Copying dollar-format values directly from Prophix web browser to an Excel sheet resulted in Excel treating the values as text.1 |
| August | 124945 | Workflow Manager | Workflow reminder mail notifications did not work as expected. |
| August | 130933 | Workflow Tasks | Workflow automatic completion and notifications did not work. |
1The following bug fix allows for any newly formatted cells using the Accounting format with Location: English (United States) to correctly copy and paste numeric data from a template to Excel.
To correct existing formatted cells: select the cell(s) and, in the Format Cells dialog, change the format from Category: Restricted format back to the desired Accounting format.
The following screen shots show the Format Cells dialog before and after the change:
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. |
