SDI Flowgraph Passing the Variable with Dynamic Value like Current Date

[zameer0448]

Hi All,

I need your help to resolve the issue of performance as the functions(like current_date) are not pushing down to the Source system. This is SAP SDI tool and adapter limitation. as a query. We are looking for alternate solution, like using flowgraph in SDI where we can define variables and use this in filter to load the data. Please find the flowgraph we have created for testing. During testing, we picked up the Virtual table as the source in the data source and added the filter section.

In the filter section, we defined the below where condition with a variable. We ran the task, and it ran successfully and quickly as we had sent the static values in the variable condition.

CDATE Variable has been defined as Variable in Properties section with Default value as Static date.

Now, we want to add a Variable to this task where the current date will be replaced by a Variable (CDATE).
So for that we created the Stored Procedure where we will define some variable(EX_DATE) and mapped this to CURRENT_DATE and we tried to call the task with below procedure.

After saving this when we tried calling the procedure and the procedure is working but is it not passing any current value in the task.

This is where we are stuck now. Could you help us with what needs to be done here?

We followed the below SAP blogs to implement this. We are very close to achieving this, but we are missing a few basics. Could you please shed some light on what needs to be done? Looks like we are not calling the way the task has to be called when we have the variable in flow diagram.