| Actor | Fragment | Worker | State |
|---|---|---|---|
| 746291 | 63482 | 51 | running |
| 746292 | 63482 | 51 | running |
| 746293 | 63481 | 51 | running |
| 746294 | 63481 | 51 | running |
| 746295 | 63483 | 51 | running |
| 746296 | 63483 | 51 | running |
| 746297 | 63484 | 51 | running |
| 746298 | 63484 | 51 | running |
| 746299 | 63486 | 51 | running |
| 746300 | 63486 | 51 | running |
| 746301 | 63487 | 51 | running |
| 746302 | 63487 | 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