nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Siva Pratap Nellipudi-Oracle · 2026-02-17T09:07:11+00:00

Problem Statement * Users want to schedule reports with different parameter values. * Currently, scheduling requires Edit/Save privileges on workbooks. * Granting “Create/Edit Workbooks” privilege is not acceptable, as it allows users to create new workbooks on any dataset. Gap Identified * Users can change parameters…

Child Item

Expand OAC DV Scheduling Capabilities with Selection of Parameters at Run time

Siva Pratap Nellipudi-Oracle

Problem Statement

Users want to schedule reports with different parameter values.
Currently, scheduling requires Edit/Save privileges on workbooks.
Granting “Create/Edit Workbooks” privilege is not acceptable, as it allows users to create new workbooks on any dataset.

Gap Identified

Users can change parameters while running reports, but cannot change them while scheduling.
Workarounds (copying to Personal Folders, granting edit rights) introduce governance risks and are not aligned with customer requirements.

Reference Point

OAC Classic Agents supported parameter selection during scheduling, enabling flexible self‑service without requiring workbook edit rights.

Proposed Enhancement

Allow users to choose parameter values directly in the scheduling interface, independent of workbook edit/save privileges.
This ensures flexibility in scheduling while maintaining governance and restricting workbook creation.

Business Impact

Empowers users with true self‑service scheduling.
Reduces administrative overhead and avoids unnecessary privilege escalation.
Aligns with customer expectations for parity with OAC Classic functionality.

Find more posts tagged with

OAC

Needs Votes

OAC export

OAC Visualization

OAC Classic

Status: Needs Votes

Comments

User_G2XZK

This indeed a good feature, which multiple clients are requesting in OAC and even in FDI. Prod Dev team can you please consider this idea. This will add a good value addition to the product both OAC and FDI.

R Stonaker

This should be a critical enhancement - only allowing scheduling of the saved state of the workbook (if a consumer has no author privileges) is extremely limiting. Consumers should be able to schedule a workbook state for delivery, if not able to set parameter values at run time.

AdityaBoral-Oracle

This should be considered a critical enhancement. Restricting scheduling to only the saved state of a workbook when a consumer does not have author privileges is extremely limiting.

Consumers should be able to schedule delivery of a workbook using a selected workbook state. Even if they are not permitted to modify parameter values at runtime, they should still be able to choose from existing saved workbook states when configuring scheduled deliveries.

This capability would significantly improve usability while maintaining appropriate permission boundaries between authors and consumers.

Top Leaders

Tarik Branković 45

User_IG5IB 32

Michal Zima 32

Siva Pratap Nellipudi-Oracle 29

SantoshChandrasekaran 18

Top Ideas

Increasing Report Results limit from 5000 to the full report results data set
OAS Classic Report Results display the first 5000 rows and the OAS user needs to click the next button for the next 5000 rows and so on. The 5000 row limit is the maximum allowed to be setup in the OAS Console. OBIEE Report Results support display of the entire report results data set. Our users would like this feature in…
Provide proactive notification of bug fixes/patches that change API response behavior, before deploy
Background We recently identified an issue through an inconsistency in the number of records returned in an API response. This allowed us to notice, after the fact, that a fix had been applied that changed the behavior of an existing API. Problem We understand that information about resolved bugs is eventually made…
Granular permission for Session and Query Logs (Manage Sessions) independent of BI Service Administr
We need a way for non-admin users to view the backend/physical SQL queries executed by reports (via Session and Query Logs) without granting them full administrator access. OAC's custom Application Role model (Console > Roles and Permissions) allows selecting fine-grained permissions instead of assigning predefined roles.…
OAS Certified Data Source (DB2) Enhancement Request
Customer would like to request that IBM DB2 12.x be added as a supported data source for Oracle Analytics Server. They hope that it will be included as a certified and supported data source in the next(Year 2027 ) OAS release. Background: The customer is currently operating a reporting and analysis platform using Oracle…
MCP restriction/ tool restrictions to OAC user groups
We would like to restrict the MCP to certain OAC application roles instead of all the users. Please help us to achieve this functionality.