I am revisiting this issue because my new approach did not work properly.

The Case I'm trying to program is:

I have two OLAP tables where one table filters (component filter) data with:

(DATE < TODAY()) 

and the other has the component filter:

(DATE > TODAY() AND DATE < TODAY() + DAYS()). 

My aim is:

Column 1: Material Name

Column 2: Material Number

Column 3: The KPI of the Material as a whole from the OLAP Table 1 which is a Detail Table of all Materials

The filter is only a simplified representation of the code. In summary, I have one table that looks at dates from the past and one that looks at dates from the future (future orders/deliveries). However, I now want to connect KPIs from the table that maps from the data from the past on the table that looks into the future. 

For example, if I have the sales of a material from day 1 to today (past until today), I would like to be able to display that as additional info for the future orders of that material (considered the past data).

Problem: In Celonis, the component filter causes me problems because then the data from the past is not taken into consideration. I also haven't found a way to combine two OLAP tables together.

I'd like to find a way to do that without changing the Data-Integration.

Does anyone know a suitable solution? I have tried different approaches, but none yielded me the suitable solution.

My last approach was to delete the Component filter and filter the deliveries from the future like this:

CASE WHEN "EKET"."SLFDT" > TODAY() AND "EKET"."SLFDT" <= ADD_DAYS(TODAY(), <%=additionaldays%>) AND

ISNULL("EKPO"."ELIKZ") = 1 AND "EKPO"."WEPOS" = 'X' AND "EKBE_EKET"."BWART" = '101'

THEN 1

ELSE 0

END

But the problem is:

That it only uses the Data which is true for the statement to calculate the KPI according to the orders in the futures and not in general like the other table.

Anyone has an approach?

Thank you.