Prophix Cloud Release Notes

Fall 2020

December 2020

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

Analyzer

  • A brand-new Prophix add-in for Microsoft Excel, Analyzer replaces Prophix for Microsoft 365 Excel and allows advanced users to do the following:
    • Change data view structures from within Excel
      • Formerly in Prophix for Microsoft 365 Excel it was necessary to make multiple data views from different configurations.
      • Analyzer provides an Edit Layout tool identical to Edit Layout in Prophix.
      • Now after inserting a data view you can change the member selection, structure, and page members from within the Excel sheet.
    • Delete data views from within Excel
      • In Prophix for Microsoft 365 Excel if you wanted to delete a data view, you needed to delete its Excel sheet.
      • Analyzer allows you to delete a data view while keeping the sheet and all its other content.
    • Switch among display formats for page members
      • Prophix for Microsoft 365 Excel used the saved member display format and offered no way to change it.
      • Analyzer allows you to modify the member display format on every axis of a data view inside an Excel sheet.
      • You can change the display format to Names, Keys, or Names & Keys.

Dashboards

Notifications

  • Workflow notifications and emails now use the user’s chosen language as specified in the Locale option.

Cloud Data Integration

  • Sage queries now include the custom function get_accountbalancebydimension that allows retrieval of data in a more timely manner.
  • ODBC and ODBC32 connections now provide optional UserID and Password boxes for DSNs that do not store user IDs or passwords (for example, Oracle).
  • The Data Integration Service's Log Queue now uses verbose logging to allow for greater debugging capabilities.

Document Explorer

  • A new file type has been added: (WI) Web Link. You can use a Web Link file to store a URL, thus acting as a shortcut; clicking the file opens the referenced app.
  • The minimum permission needed in order to download external files is now read-only file access.
    • This applies to all drawers of Document Explorer where downloading is available, including the Process Files drawer.

Locales

  • A new option has been added to Locales: Spanish (Spain).

Templates

  • To speed up navigation, in template Report or Data Entry modes the Pages drawer is now expanded by default.

Resolved issues

Note that the current build is always cumulative: it contains all previous patches.

Released Ticket number Area Description
December 113425, 113225, 113124, 113438, 113326, 113212, 113504 Process Manager The Task Log for the Import Process was loading indefinitely.
December   Dashboards Charts had a problem with title display.
December   DPM Schedules The system setting for automatic posting of data was not working.
December   Analyzer An Excel sheet name that contained non-alpha-numeric characters or alpha-numeric but with less than five characters, caused an attention dialog to appear when pulling data into Excel.
December 113210, 112872, 113124, 113189, 112872, 113219 Process Manager The InfoFlex process gave the error: The multi-part identifier "ft.CurrencyKey" could not be bound.
November 110427 Ad Hoc Analysis The Cell Properties dialog did not display correctly.
November 112363 Dashboard Studio Page filters were not working with alternate hierarchies.
November 109237 Data Connector When previewing a SQL view a timeout error occurred.
November 108638 DPM Problem saving the correct Start Date for an employee.
November 104500, 98091 DPM Schedules Selecting a date member for editing caused its date to change.
November 104322 Drill Across Drilling across on a QTD was returning data for only a single period.
November 46563 Drill Across Drilling across on a YTD in Smart Client did not return the same result as in Web Client.
November 101165 Drill Across Drilling across to a SQL table the time there was changed in Prophix to local time.
November 107203 InfoFlex The SQL processing option showed a performance degradation.
November 110545 InfoFlex The SQL processing option failed with an error.
November 107820 Process Manager In offline workbooks the column and row locks on template cells were not retained.
November 105924 Template Studio If a report contained a chart there was a problem exporting the report to PDF.
November 106918 Template Studio When the Save As option was chosen for a Template Studio Classic file, the new file's Created by property contained the name of the previous user.
November 105512 Template Studio Error when deleting an Auto Text.
November 109191 Workflow If a user was assigned Owner and Observer for a Data Entry workflow task, the template automatically opened in Report Mode, rather than Data Entry mode.
November 106102 Workflow Write Access security failed to update when a named set was updated for a workflow task.