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.
How to schedule 'Generate Audit Report' monthly 2nd day , so that it generates output for the last month We have tried creating new custom job similar to Generate Audit Report and enabled Date Argument Numbers (1,2) which is the date parameters , but it was not returning the data as expected. Its taking the number of days…
There are more menu options made readily available by default to non-admin users that we wish to restrict. It seems this functionality, to control menu options in the user button menu on the upper-right-hand-side of OAC (DV), is not currently available. Can we be given the ability to customize this menu? Ideally via…
Right now once you save a workbook, that's it. If you (or someone else with edit access) changes a canvas, deletes a calc or messes up a filter and saves, there's no easy way to get back to how it was. The options are digging out an old .dva export if you happened to take one, or asking an admin about a snapshot, which…
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…
