CREATE MATERIALIZED VIEW alpheya_experience_bff.report_pnl_daily_mv AS
SELECT
pag.portfolio_id,
pag.type AS account_group_type,
p.dim_balance_date,
p.currency_code,
p.market_value,
p.total_average_cost,
p.fair_value,
p.market_value_system_currency,
p.total_average_cost_system_currency,
p.fair_value_system_currency,
p.cumulative_adjusted_netflow,
p.cumulative_adjusted_netflow_system_currency,
p.total_gain_loss,
p.unrealized_gain_loss,
p.realized_gain_loss,
p.total_gain_loss_system_currency,
p.unrealized_gain_loss_system_currency,
p.realized_gain_loss_system_currency
FROM insights.portfolio_to_account_groups_mv AS pag
JOIN insights.pnl_summary_mv AS p
ON p.account_group_id = pag.account_group_id AND p.position_type = 'POSITION'