Forum Discussion
Problem refresh incremental Connexion SAP Hana for Reference, Append and Merge Query
Hi Anonymous,
i think you have to filter the original query to reduce the data from hana
and the appred query to control the storage of the historical data.
Hii,
here are the queries, Original source table + two reference table + appendi
Hi Anonymous ,
i think it works this way.
You have to insert the filter parameters in the "original" query and in the "final" query.
In the "original" query, so that the data can be filtered in the source by query folding.
In the "final" query, so that the parameterization is activated and the result of this query is saved.
I assume that the parameter of the "final" query will be forwarded to the "original" subquery.
Hi mwegener
How can I access the filter parameters in the reference table and the append table?
I add parameter filters in all queries ?
Thanks,
Hi Anonymous,
I think you can only set the parameters in the final query.
The other queries should be executed as subqueries and have the same parameter values as the final query.Can you confirm my guess?
My problem is the sub-requests, just take the refreshes of the original request (source Hana), so I will have only the incremental data in the sub-requests and I will not have history in apprend and reference query