Add parameters to EPM Data Integration Query
Hi,
I have Data Integration rule, and its source system is MS SQL Server Database, and the query is working fine.
The query returns the following columns : "Period", "From Currency", "To Currency","Rate"
However, the query returns data for all periods ( even the unopened periods and the others not required to be mapped )
Is there any way in the SQL Query to filter the incoming query data based on "From Period" and "To Period" while running the data rule ( like "select * from AAAA where period =~PERIOD~ ")? In other words, can I pass the targeted period(s) as a Parameter that I can control it while executing the rule?
Tagged:
0