Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Across the Adaptive Suite

Preview the features of our upcoming release. Details are subject to change.

2017.3 Release Notes: Enable flexible time modeling in modeled and cube sheets,  perform manual recalculations, and use updated APIs.

Plan with Sheets that Meet Your Time Needs

For each cube or modeled sheet, select any time granularity defined in your instance's configured time, so you can plan different parts of your model according to what works best for that sheet's accounts. Some aspects of your business are easier to plan week-by-week and others make more sense month-by-month. With our enhanced time capabilities you can now plan at higher levels of time like quarter, or even year. Enter data at a sheet's selected time, like week, or a higher level, like month.  

Understanding Time Strata

Speed Up Performance with Manual Recalculations  

You can isolate cube and modeled sheets from the rest of your instance so that calculations only occur on demand instead of occurring every time your data changes.

Manual recalculation provides a performance benefit by storing the results of calculations and using them until you click Recalculate Formulas Button (Recalculate Formulas). Calculations are performed for each row in a modeled sheet whenever that row is edited.

Recalculate Button on Sheets

Manual recalculation is enabled for individual cube and modeled sheets within their Sheet Properties > Settings. You can recalculate other rows on a modeled sheet when a related row is changed by enabling the Recalculate on match setting to indicate the other rows you also want to recalculate when a given row changes:

Set Up On-Demand Calculations

Access Manual Recalculation and Custom Time Configuration with Updated APIs

The new version 16 of the REST APIs:

  • Introduces the new recalculateSheet for recalculating sheets when recalculate on demand is enabled.
  • Updates the response formats of exportAccounts, createAccount, and updateAccount to display each account's timeStratum field.
  • Updates exportTime so that it now contains: 
    • a new optional leafStratumId property for requests
    • new inUse and isDefault for its stratum element to match the new model dependent time features available in the Time Administration screen
  • Updates eraseActuals to only accept time periods at the same time stratum as the input account type for API versions 15 or higher.
  • Was this article helpful?