CREATE MATERIALIZED VIEW insights.position_asset_values_mv AS
SELECT
account_group_id,
asset_id,
dim_value_date,
group_currency,
COALESCE(position_type, 'POSITION') AS position_type,
SUM(market_value_group) AS market_value,
SUM(average_cost_group) AS average_cost,
SUM(fair_value_group) AS fair_value,
SUM(accrued_value_group) AS accrued_value,
SUM(relationship_value_group) AS relationship_value,
SUM(fair_relationship_value_group) AS fair_relationship_value,
SUM(market_value_system) AS market_value_system,
SUM(average_cost_system) AS average_cost_system,
SUM(fair_value_system) AS fair_value_system,
SUM(accrued_value_system) AS accrued_value_system,
SUM(relationship_value_system) AS relationship_value_system,
SUM(fair_relationship_value_system) AS fair_relationship_value_system
FROM insights.position_values_mv
GROUP BY
GROUPING SETS (
(account_group_id, asset_id, dim_value_date, group_currency, position_type),
(account_group_id, asset_id, dim_value_date, group_currency)
)