Add a native Goal Seek and constraint-based optimization capability in Oracle Analytics DV to calculate the required driver values needed to achieve business targets such as revenue, margin, utilization, or cost directly within DV workbooks.
Why?
Today this requires Excel Solver, custom Python, or manual parameter trial-and-error, leading to extra effort, and slower decisions.
Key Capabilities:
- Select target metric and driver to solve for
- Support limits like budget, capacity, or utilization
- Interactive scenario comparison inside DV
- Optional integration with OCI Data Science solvers
- Governed, reusable logic in the semantic model
Value:
Moves DV from reporting to real decision support, reduces spreadsheet dependency, and strengthens Oracle Analytics’ competitive position.
