cbriscoe
12 months agoContributor
Performance Decisions - Dynamic Vs. Stored Calculations
💎
OneStream consultants and administrators must make the correct decisions during the design phase of YOUR project. Top on the list:
- Deciding which one (Dynamic or stored Calculations) to use is a fundamental consideration of a project.
- Dynamic Calculations are an in-memory calculation that runs on demand (when necessary).
- Stored Calculations are calculations that run as part of the Data Unit Calculation Sequence (DUCS).
- All alternatives should be considered before storing calculated values in the application.
- Dynamic Calculations do not store a value in the cell. Instead, a numerical value calculates and displays when the Member is referenced.
- Stored Calculations result in data records and data cells being stored in a database table.
For further details: OneStream Foundation Handbook and Implementing OneStream course.
Exam QUESTION: What are the three ways to run Calculations?
- Cube View cells​
- Workflow Process task​
- Data Management Jobs