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.
Read the API Documentation for more details.
Allow User Imports to Only the Levels They Own
As an admin, you can control if users import only to their levels, or to all levels. Any users who could import everywhere before, automatically get Import to All Levels.
Restrict users to their levels by unchecking the new Import to All Levels permission.
Read Users Roles and Permissions for more details.
Log in More Quickly
The login page for the Adaptive Planning and OfficeConnect includes a new checkbox that lets your browser remember your user name. If you check it, the next time you return to the login page you only need to provide your password.
Read Logging In for more details.