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