| Actor | Fragment | Worker | State |
|---|---|---|---|
| 743699 | 62599 | 51 | running |
| 743700 | 62599 | 51 | running |
| 743701 | 62601 | 51 | running |
| 743702 | 62601 | 51 | running |
| 743703 | 62603 | 51 | running |
| 743704 | 62603 | 51 | running |
| 743751 | 62593 | 51 | running |
| 743752 | 62593 | 51 | running |
| 743753 | 62594 | 51 | running |
| 743754 | 62594 | 51 | running |
| 743757 | 62595 | 51 | running |
| 743758 | 62595 | 51 | running |
CREATE MATERIALIZED VIEW insights.private_asset_valuations_mv AS
SELECT
v.asset_id,
v.fact_date,
v.market_value_currency,
v.market_value * COALESCE(fxm.rate, CASE WHEN v.market_value_currency = 'SAR' THEN 1 ELSE NULL END) AS value_system_currency,
CASE
WHEN COALESCE(v.average_cost, 0) = 0
THEN 0
ELSE v.average_cost * COALESCE(
fxc.rate,
CASE
WHEN COALESCE(v.average_cost_currency, v.market_value_currency) = 'SAR'
THEN 1
ELSE NULL
END
)
END AS cost_system_currency
FROM olap.private_asset_valuations_ft AS v
LEFT JOIN insights.fx_rates_snapshot_mv AS fxm
ON fxm.source_currency_code = v.market_value_currency
AND fxm.target_currency_code = 'SAR'
LEFT JOIN insights.fx_rates_snapshot_mv AS fxc
ON fxc.source_currency_code = COALESCE(v.average_cost_currency, v.market_value_currency)
AND fxc.target_currency_code = 'SAR'
WHERE
v.disabled_at IS NULL
AND (
NOT fxm.rate IS NULL OR v.market_value_currency = 'SAR'
)
AND (
NOT fxc.rate IS NULL
OR COALESCE(v.average_cost_currency, v.market_value_currency) = 'SAR'
OR COALESCE(v.average_cost, 0) = 0
)