July 2021


Notice:
Oracle NetSuite will be implementing a change tho their API by January 2022. This change will require an update to the Solver NetSuite connector. Solver will release an updated connector prior to the NetSuite release date.
Click here for more information


New features this month

New toolbar style for reporting screens

The Solver toolbars have been updated to allign with common user interactions. The Reporting and Planning screens have been updated with the new style. To learn more about the updated design, check out this months update video here.

Dynamic rolling periods for Rules within Jobs

Dynamic rolling periods for rules replicates the functionality of rolling periods for integrations. Dynamic periods with rules does require specials syntax in order to enable the rolling period capability.

To support this new rolling periods feature, a new rule parameter type has been introduced. This new type will enable rolling periods on the jobs screen. The new type is:

type="RollingPeriodBegin"

An example of this syntax added to a new rule is as follows:

<param table="d_Time" label="PeriodStart" variableName="PeriodStart" lookupFieldName="FYPeriod" type="RollingPeriodBegin" />
		<param table="d_Time" label="PeriodEnd" variableName="PeriodEnd" lookupFieldName="FYPeriod" type="RollingPeriodEnd" />


Template calculation performance improvements

We have updated a component which manages the calculations when running reports and input templates within the Portal. User should experience a significant improvement when inputting, pasting and delete data in templates with a large number of complicated Excel formulas.



Fixes this month

  • Data Warehouse:
    • Dimension Overview – Filtered view persists even after clearing the them.
    • Module Schema – Invalid Column Name Error Between GL and GL Detail Module During Edit Configuration.
    • Data Explorer – a misleading message stated no data found when data existed.
    • Trees: Switching Trees while in Edit Tree Name State will keep
    • Rules: Modified By Should Show User Name When Importing a Rule.
    • Dimensions: Exporting dimensions with a date field does not show correctly in Excel.
  • Reporting:
    • Playlist – report selection bar at the bottom missing