Every month we have to update dozens of filters in data flows. This would not be necessary if we could use parameters, or other stored variables, in the data flow. Please add functionality to allow parameters\ variables in data flows
Hello! I’m curious what your use case looks like — what kinds of filters are you updating in your Data Flows each month? Are these mostly date filters, or do they include other fields as well? @MJC
Hi! We have data flows that, in some cases, have a dozen branches. each branch is pulling data for either the current or prior month, so we have filter boxes embedded within each branch of the flow that we have to update every month. If we had a parameter for current month and prior month we could just enter those once and the flow would be updated. Does that make sense? I have screenshots I could email.
Why not store the month in a parameter table that is used by the data flow? Even with parameters, there needs to be a process that updates the parameter value periodically. Having a parameters table and possibly a data flow that updates the parameters might be useful. It will be great if you can share more details on your use case to see if it will be applicable or not.
Hi @Gabby Rubin-Oracle - you would have to explain that concept to me. I'm not sure how a data flow can reference a parameter table. I'm attaching a screenshot with a snip it of a data flow we update monthly. it would be great to only have to update a parameter for current month and prior month instead of going into each filter individually and updating them.
@MJC Looking into the use case. I assume your current month is not the system's current month, but rather a specific month you need to target.
@Gabby Rubin-Oracle this is typically updated on the first or second business day of a month (for example, September 3) for the prior month end accounting close. So some of the branches in the flow are for August (Aug-2025 period name) and some of the branches are for the prior month end close (Jul-2025).
We are having similar issue for our monthly PA-GL_Reconciliation due to different Start_Date/End_Dates of GL periods and PA Periods.
Right now, OAC offers pre-built pages and watchlists related to NSAW. At our University, we do not need these pages, and we want to delete them entirely. We've been told in response to our SR that all we can do is keep "Access" limited to only the default admin and sysAdmin roles. This prevents regular users from seeing…
It would be nice to have a way to right click on an object (subject Area, Column, Calculation, etc.) in the Data Panel and show where that object is referenced in a workbook = canvas, visualization, filter, calculation, data action, etc.) In Workbooks with multiple canvases and multiple subject areas, we are left to hover…
We want to automate the workbook export to .dva file and import this into another OAC instance using REST API, The goal is an OCI DevOps pipeline that can promote (a) a whole folder, (b) a single workbook, or (c) several workbooks in one run to another OAC instance, and print a status result at the end. Blocker: Export and…
When Oracle Analytics AI features find an anomaly, trend or key driver, let authors save those results as a dataset or subject area. Each run would add rows with the metric, the date found, the expected versus actual value, the severity, the main drivers and the filters applied. Authors could then build workbooks, schedule…
We use the snapshot to update AppRoles members. But we would like to disable catalog content to have smaller snapshots and create snapshots faster.
