I'm using a dimension which is based on KPI which contains different tables IDs (e.g: matnr from marc, ebeln from ekpo...) I´m trying to use this dimension whit a KPI (inventory on hand). This KPI is formed the following way:
COALESCE(
PU_LAST(
"MARC"
, "STOCK_HISTORY"."VALU_LBKUM_CON"
, ORDER BY "STOCK_HISTORY"."EVENTTIME" ASC
) -- Ascending order is considered. Hence the result is the last eventtime (and therefore most recent) in the table per Material || Plant.
,0.0
).
It is giving me a problem of common table, but I thought that by stablising MARC as the common table with pu_last it would work, as it is working with other KPIs made the same way.
Hope somebody can help me here, thanks
