Adding parameters in Data Flows — Oracle Analytics

Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Adding parameters in Data Flows

Needs Votes
61
Views
6
Comments
MJC
MJC Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server Idea Lab

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

Tagged:
5
Up
5 votes

Needs Votes · Last Updated

Comments

  • GabriellePrichard-Oracle
    GabriellePrichard-Oracle Mod

    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

  • MJC
    MJC Rank 3 - Community Apprentice
    edited Aug 14, 2025 6:22PM

    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.

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    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.

  • MJC
    MJC Rank 3 - Community Apprentice

    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.

    image.png
  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    @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.

  • MJC
    MJC Rank 3 - Community Apprentice

    @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).