Forum Discussion
Append 2 tables - expression.error: a cyclic reference was encountered during evaluation
table 2 is dependant on table 1
in step#"Not in PDB - merge query 1"
you do join with MASTER PDB TEMP
I'd suggest creating reference to MASTER PDB TEMP and appending Table 2 to the new, referenced query
Dear community members,
I am trying to implement incremental refresh "manually" as my database is SAP BW and query folding is not working. Here is what I am trying to do.
1. Extract latest date from Master Data table and store it as a query (lets call it last_date)
2. Use last_date query to fetch New Data (from last_date till today). It is working so fine so far.
3. Append New Data to Master Data -> Getting cyclic reference error here
Tried creating reference to Master Data and appending New Data to it. It resolves the error but it is not useful since the "last_date" query is still linked to old Master Data.
Kindly help!
Stachu CR