Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Native Goal Seek & Optimization Capability in Oracle Analytics DV (OAS/OAC)
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.
Comments
-
Have recently been looking at how we integrate custom python scripts with OAS to do this sort of thing. Too badly documented as others have noted. So will just use py outside of OAS. But any enhancements in this area much appreciated
1