Preview the features of our upcoming release. Details are subject to change.
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.
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). Calculations are performed for each row in a modeled sheet whenever that row is edited.
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:
Access Manual Recalculation and Custom Time Configuration with Updated APIs
The new version 16 of the REST APIs:
- Introduces the new
recalculateSheetfor recalculating sheets when recalculate on demand is enabled.
- Updates the response formats of
updateAccountto display each account's
exportTimeso that it now contains:
- a new optional
leafStratumIdproperty for requests
stratumelement to match the new model dependent time features available in the Time Administration screen
- a new optional
eraseActualsto only accept time periods at the same time stratum as the input account type for API versions 15 or higher.