CREATE MATERIALIZED VIEW alpheya_experience_bff.report_position_daily_mv AS
SELECT
pag.portfolio_id,
pag.type AS account_group_type,
ps.dim_balance_date,
ps.currency_code,
ps.market_value,
ps.fair_value,
ps.accrued_value,
ps.relationship_value,
ps.fair_relationship_value,
ps.market_value_system_currency,
ps.fair_value_system_currency,
ps.accrued_value_system_currency,
ps.relationship_value_system_currency,
ps.fair_relationship_value_system_currency
FROM insights.portfolio_to_account_groups_mv AS pag
JOIN insights.position_summary_mv AS ps
ON ps.account_group_id = pag.account_group_id
AND ps.position_type = 'POSITION'
AND ps.source_entity_type = 'portfolio'