Oracle Analytics Cloud and Server

Home› Oracle Analytics› Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Parameter in Data Flows

Accepted answer
43
Views
3
Comments
Jean-Pierre Hoedenaeken
Jean-Pierre Hoedenaeken ✭✭✭✭
in Oracle Analytics Cloud and Server

Hello,

How can we use a parameter in a data flow please ?

Or is there any workarround to achieve the need of using a variable (like a week) in a data flow ?

Regards.

Jean-Pierre

Tagged:

Best Answers

  • Federico Venturin
    Federico Venturin ✭✭✭✭✭
    Answer ✓

    Hi @Jean-Pierre Hoedenaeken ,

    It's not possible to use parameters in data flows as they are defined at workbook level. As a workaround, you can define a subject area-based dataset to get the value of repository/session variables and then use it as an input in your data flows.

  • Gianni Ceresa
    Gianni Ceresa mod
    Answer ✓

    You could use another dataset that will contains all the parameters you need, and then you join it with your data in the dataflow and by using join conditions you can "filter" your data based on that variable value you have in the parameters dataset.

Answers

  • Jean-Pierre Hoedenaeken
    Jean-Pierre Hoedenaeken ✭✭✭✭

    Hi Federico and Gianni,

    I have used a new dataset with the only value that I need (previous week) and join it to one of my existing dataset to filter the data in my data flow.

    Thanks to both of you.

    Jean-Pierre