select ds."name" as Сценарий
, fb."period" as Период
, vdbi.level1_name as СтатьяБюджетовГруппа
, dbi."name" as СтатьяБюджетов
, dbi.code as СтатьяБюджетовКод
, dd."name" as МВЗ
, dd.channel_name as КаналПродаж
, dp."name" as Проект
, dc."name" as Валюта
, dpi."name" as СтатьяДиР
, sum(fb.amount_cur) as СуммаВалюта
, sum(fb.amount_mng) as СуммаУпр
, sum(fb.amount_scn) as СуммаСценарий
, sum(fb.amount_reg) as СуммаРегл
from dm_pf_analysis.fact_budget fb
left join dm_pf_analysis.dim_scenario ds on fb.scenario_id=ds.scenario_id
left join dm_pf_analysis.dim_budget_item dbi on fb.budget_item_id = dbi.budget_item_id
left join dm_pf_analysis.dim_department dd on fb.department_mvz_id = dd.department_id
left join dm_pf_analysis.dim_project dp on fb.project_id = dp.project_id
left join dm_pf_analysis.dim_currency dc on fb.currency_id = dc.currency_id
left join dm_pf_analysis.dim_plcf_item dpi on fb.plcf_item_id = dpi.plcf_item_id
left join dm_pf_analysis.v_dim_budget_item vdbi on fb.budget_item_id = vdbi.budget_item_id
where fb.period between date '2023-07-01' and date '2023-07-31'
and ds."name" = 'Фактические данные'
and vdbi.level1_name = 'БДР'
group by
ds."name"
, fb."period"
, vdbi.level1_name
, dbi."name"
, dbi.code
, dd."name"
, dd.channel_name
, dp."name"
, dc."name"
, dpi."name";
- Форум тестировщиков
- → Публикации GdeRabota