Oracle Analytics Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Native Goal Seek & Optimization Capability in Oracle Analytics DV (OAS/OAC)

11
Views
1
Comments

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.

Tagged:
2
2 votes

Submitted · Last Updated

Comments

  • peacey
    peacey Rank 3 - Community Apprentice

    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