| Actor | Fragment | Worker | State |
|---|---|---|---|
| 739866 | 59013 | 51 | running |
| 739867 | 59013 | 51 | running |
| 740246 | 59010 | 51 | running |
| 740247 | 59010 | 51 | running |
| 740248 | 59009 | 51 | running |
| 740249 | 59009 | 51 | running |
| 740250 | 59011 | 51 | running |
| 740251 | 59011 | 51 | running |
| 740252 | 59012 | 51 | running |
| 740253 | 59012 | 51 | running |
| 740254 | 59014 | 51 | running |
| 740255 | 59014 | 51 | running |
CREATE MATERIALIZED VIEW alinma_bff.advisor_kpi_account_values_mv AS
SELECT
c.account_id,
SUM(h.market_value_system_currency) AS net_assets,
SUM(ABS(h.market_value_system_currency)) AS relationship_value,
SUM(CASE WHEN c.product_class = 'AUM' THEN h.market_value_system_currency ELSE 0 END) AS aum,
SUM(
CASE
WHEN c.product_class = 'DEPOSITS'
THEN h.market_value_system_currency
ELSE 0
END
) AS deposits,
SUM(
CASE
WHEN c.product_class = 'FINANCING'
THEN ABS(h.market_value_system_currency)
ELSE 0
END
) AS financing
FROM alinma_bff.advisor_kpi_account_product_class_mv AS c
JOIN insights.holding_values_latest_mv AS h
ON h.account_id = c.account_id AND NOT h.market_value_system_currency IS NULL
GROUP BY
c.account_id