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).
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…
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…
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.…
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…
We would like to restrict the MCP to certain OAC application roles instead of all the users. Please help us to achieve this functionality.
