-
AI-Generated Semantic Model & Dataset Joins with Suggestions
Put all the tables required into the Physical Layer. Then OAC scans tables & recommends facts, dimensions, joins, hierarchies, measures, time dimensions, gaps & common calculations. This would help new users build proper star-schema-style models without needing a BI architect. Also allows for faster delivery of Subject…
-
Add Tooltips or Some Sort of Popup Text Function on Specific Headers (not values)
I know you can do Tooltips on values but looking for an option to apply notes or tooltips on Header columns in a table. For example, sometimes we create calculations for users & need to explain what that field does. For extra functonality, enabling an info icon next to the header name so users know to click on the header…
-
Enable Programmatic Export of Entire Dashboard to Excel with Server-side Persistence in OAS
In Oracle Analytics Server (OAS), there is a requirement to automate dashboard exports and persist the output to server-side file systems or to NFS, similar to capabilities previously leveraged in OBIEE-based workflows. Currently, OAS provides the following functionality in the user interface: Dashboard (including multiple…
-
Allow Users to Choose Which Columns Are Replacing / Reassigning When Adding a Logical Table Source
When adding a Source table at the Logical Layer table, it auto adds those physical table's columns to the logical table. Often I just want to assign fields to an existing field OR replace an existing OR just add them. I know you can just drag & drop from the physical table to the logical, but that just adds the field.…
-
Capture Adjusted Time for Map-Based Travel Estimations based on Historical data
We are using the new feature in OFS that adjusts travel estimations based on historical data when using Street Level Routing to calculate the planned travel time (with the option to apply minimum and/or maximum values of adjustment). However, we want to see (and be able to report on) what this adjustment is per journey /…
-
delete po receipt in bulk via postman api
As part of a business requirement, we need to perform bulk deletion of PO receipts using an API through Postman. Kindly provide guidance on how to achieve this.we are able to delete single line by above payload. {"VendorName":"Cardinal Glass","DestinationTypeCode": "RECEIVING","DocumentLineNumber": 8,"DocumentNumber":…
-
AD-Hoc Payment bank charges
We have business requirement where business need an option to select who will bear bank charges payee or organization when they do Ad-hoc payment, Same as Payables PPR.
-
Upload Excel / CSV into OAC & Save Directly to a Database Connection without Data Flow
Upload CSV / Excel to OAC & save directly to a Database connection without having to use a Data Flow. Creating a Data Flow to do this for each & every file is time consuming & if we need to update the file, we have reupload & then run the Data Flow again. Nice to have an option once the file is saved, to save directly to a…
-
Provide a way for users to input data to be used in a Data Flow
We have a data flow that users want to be able to enter parameters for, such as Month and Year to pull data for, select a particular external data file to process the flow against at runtime, or provide the name they would like the resultant dataset to be called when it is stored. There is no way for the user to provide…
-
Provide functionality to see how many records are in a Data Flow at any given step in the process
We have a growing community of DV users utilizing the OAS Data Flow tool to create complex joins across diverse data and performing other manipulations. One request that comes up constantly is "I'd really like to know how many rows are in the Data Flow at this step of the process". This particularly causes issues when a…
-
Improve Assistant Panel UI to Avoid Hiding Dashboard Content in OAC
When the Assistant panel is opened in Oracle Analytics Cloud (OAC), it currently overlays and hides a significant portion of the dashboard/visualization area. From the screenshot: The right-side Assistant panel covers nearly 30–40% of the visualization canvas This makes it difficult to view charts, tables, or validate…
-
Faster way to see sample data in Workbooks
Hi - our users are asking if there is a faster way to quickly view sample data in datasets that are brought over into a Workbook. I know users can drill into the Data Tab, then edit the Dataset & view data from there but it's a few clicks & loading screens too many. May be a window pane at the bottom of the DV to expand /…
-
In OAC report , we see drill down but there is no way to drill up
In hierarchical columns in a report, when you drill into a child record and its child, there is no way of returning to the original field. A report build off of subject area, that has a field 'Line of business', when you click the third menu button, it provides a menu option 'Drill to LOB L4', which drills down and takes…
-
Lock Window Panes / Visauls in a DV Workbook OR Customise Position of Visual's Window
Hi. We would like to lock particular windows / layout sizes & positions in DV's which would be helpful for Shared Layouts to keep the workbooks as consistent as possible. I don't mean lock the visual & prevent from editing…I just mean lock it so it cannot be resized or moved around until somone manually checks the unlock…
-
Simplify installation and configuration of OAS for Excel export and scheduled emailing of workbooks.
Excel export and scheduled emails of workbooks only works after additional installation of node.js and several configuration tasks. Since these are frequently used features, it would make sense if those features would be functioning out of the box (meaning directly with the install of Oracle Analytics) without separate…
-
Add Padding to Line Graph Values Axis Upper Limit (End = Max Data)
Some of the data label are not visible when the option of End = Max Data is picked, and when Data Labels are enabled, since the upper limit is set to the highest value in the data set. If there were some auto padding added or if the option were available to add padding of a certain percent when End = Max, then this could…
-
Prorate the withholding taxes across invoices
Currently, the Oracle Payables Cloud module does not properly withhold taxes at source per invoice, considering their respective individual values, in cases where the tax calculation point occurs at the time of payment. When there is an accumulation of the tax base for certain taxes, such as Brazilian Personal Income Tax…
-
Copying and Pasting Dashboard Filter Visualization does not transfer over LIMIT VALUE BY Selection
Idea Summary When a user copies and pastes an Oracle Analytics Data Visualization object that has a dashboard filter configured with a LIMIT BY selection, OAC does not preserve that LIMIT BY setting in the newly pasted visualization. This creates inconsistent behavior between the original visualization and the copied…
-
Using Canvas filter as variable for viz description
Hi, I have set a canvas filter for region and I want to use the filtered value as variable in the description of a visualization. Unfortunately, currently the approach of parameters only works for values used in drop down filters.
-
Support Accurate Cross-Dataset Calculated Metrics with Product Filters in OAC
In OAC, this complex calculated metric is derived from two different datasets from separate data sources, joined through the product table. The individual calculations work correctly on their own, but when they are combined with a product filter, the results become inaccurate because the physical query changes the join…
-
Deep Analysis of Field Changes, What will likely Break etc. Before Deploying Semantic Model
Hi. Wondering if it's possible to get a deep analysis of the semantic model changes that are about to take affect so we know what's changed, what will break etc. before deploying a semantic model. Some things that would be helpful to know: New objects (e.g. new dimension, facts, calcs) Changed objects (e.g. renamed…
-
Language Narrative Option to Read Existing Visuals + Prompting
Hi. It would be great for the Language Narrative Visual to have the option to read existing visuals & create a narration off that, rather than on specific fields. To help it along, users would like to add prompts for the Narration to help it along & provide business context. An example of a prompt would be "Negative values…
-
OAS unable to apply filter using contains,starts,ends,like pattern keyword inside dashboard prompt
OAS is unable to apply filter using contains,starts,ends,like pattern keyword inside dashboard prompt when a column is numeric. I imported the filter values passing sql statement like "Execute connection…" statement . I got the values for the filter however I was unable use any of the mentioned functions. I then converted…
-
Clopay has CSS standards that needs to be implemented to every report. Individual or Theme to apply
Currently in "Classic OBI" and in "OAC" no provision to select or apply required font color, size, background color, sized, images, logos etc., basically need an option to change the reports with "Clopay Standards" CSS file and apply across all the reports in OAC and in Classic OBI.
-
OAC DV Canvas Security – ability to apply role-based security to individual canvases in DV workbooks
Currently in OAC DV, there is no option to set security at the individual canvas level within a workbook by the workbook owner or a BI Administrator. By default, users who are granted access to a workbook can view all canvas pages within it. In many cases, we design workbooks that are intended to be shared across multiple…
-
Capture Adjusted Time for Map-Based Travel Estimations based on Historical data
We are using the new feature in OFS that adjusts travel estimations based on historical data when using Street Level Routing to calculate the planned travel time (with the option to apply minimum and/or maximum values). However, we want to see (and be able to report on) what this adjustment is per journey / activity, when…
-
OAC Usage by Devices
Customer would like to see what device users are using when logging to OAC. How do we get that information?. Customer needs this data to perform analysis to see what device users are using when logging to OAC.
-
Enhanced Dependency Tracking & Impact Analysis for Connections and Datasets
The Inspiration: Legacy Metadata Lineage In enterprise data modeling, knowing the "Lineage" or "Impact" of a change is foundational. This proposal seeks to bring a robust dependency inspector to the FDI/OAC front-end, allowing administrators to audit the entire ecosystem before performing cleanup activities. Problem…
-
customer would like to have feature to use data action from Σ (Grand Total and Sub Total)
4-0002704772 : Data Action from Grand Total Implement calculated work around for all reports where we have grand total/subtotal with data action are lot of works.
-
Enable DFFs at Customer Account Receipt Method Assignment level in Oracle Cloud Receivables
Idea Summary: Introduce the capability to define Descriptive Flexfields (DFFs) at the level where Receipt Methods are assigned to Customer Accounts in Oracle Cloud Receivables, consistent with the equivalent functionality available in Oracle E-Business Suite (EBS). Detailed Requirement: There is a need to capture…