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.
We want to increase the rest api limit for this payload to incease from current 25 limit to 100. we are calling this api through RF Smart and due to limitation for paging size, the packing units more than 25 does not show up. Can you please increase the limit atleast to 100.…
We have observed a potential issue with dataset refresh schedules when changing the Data Access mode. When a dataset is configured with Automatic Caching, a reload schedule can be defined to refresh the data at specified intervals. However, if the Data Access setting is subsequently changed from Automatic Caching to Live,…
Would like for the old classic BIP bursting feature to be fully Agent aware so that end users no longer need to be concerned with scheduling via the classic console or building out as many BIP reports just to support this one thing.
We have various data sources in Microsoft Fabric and need the ability to build reports in Oracle Analytics Cloud that connect to data sources in Microsoft Fabric. This is an unavoidable reality in today's complex data ecosystems. Microsoft Fabric requires authentication via Microsoft Entra. We opened an SR and Oracle told…
With the OAC Visualization AI Skill, users can potentially extend existing custom visualizations and address limitations encountered in real-world use cases. As an example, we used the AI Skill to enhance the OracleVectorMapsH3 visualization from approximately 10,000 data points to a version supporting up to 50,000 data…
