💎
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.
![cbriscoe_0-1709499871769.png cbriscoe_0-1709499871769.png](/t5/image/serverpage/image-id/8933iB24C8FFA5CCBEB6C/image-size/large/is-moderation-mode/true?v=v2&px=999)
For further details: OneStream Foundation Handbook and Implementing OneStream course.
![cbriscoe_1-1709500713294.png cbriscoe_1-1709500713294.png](/t5/image/serverpage/image-id/8934i422D74AEDB696261/image-size/large/is-moderation-mode/true?v=v2&px=999)
Exam QUESTION: What are the three ways to run Calculations?
- Cube View cells
- Workflow Process task
- Data Management Jobs