- <doroga>
- <Nod nod="Дорога">
- <Region region="По региону">
- <Station station="Все станции" id="">
    <vag_m> 75026 </vag_m> 
    <tn_m> 4571402 . 84 </tn_m> 
  </Station>
 </Region>
 </Nod>
- <Nod nod="КАРТЛ">
- <Region region="По региону">
- <Station station="Все станции" id="8005">
   <vag_m> 17184 </vag_m> 
   <tn_m> 1068812 . 61 </tn_m> 
   </Station>
  </Region>
- <Region region="КАРТЛ">
- <Station station="Все станции" id="800500">
    <vag_m> 17184 </vag_m> 
    <tn_m> 1068812 . 61 </tn_m> 
  </Station>
  </Region>
</doroga>

- <doroga>
      <vag_m> 75026 </vag_m> 
       <tn_m> 4571402 . 84 </tn_m> 
    -<Nod nod="КАРТЛ">
          <vag_m> 17184 </vag_m> 
         <tn_m> 1068812 . 61 </tn_m> 
      -<Region region="КАРТЛ">
            <vag_m> 17184 </vag_m> 
            <tn_m> 1068812 . 61 </tn_m> 
           - <Station station="АЛЬМУХАМЕДОВО" id="818209">
               <vag_m> 3 </vag_m> 
               <tn_m> 187 . 60 </tn_m> 
            </Station>
       </Region>
      </Nod>
</doroga>

isnull(cast([[Станция погр]].[НОД погр]].[MEMBER_CAPTION]]] as varchar), 'Дорога') as nod,
isnull(cast([[Станция погр]].[Регион погр]].[MEMBER_CAPTION]]] as varchar),' По региону') as region,
isnull (cast([[Станция погр]].[Стан погр]].[MEMBER_CAPTION]]] as varchar), ' Все станции') as station,
 [[Measures]].[id]]] as id_st,
 [[Measures]].[Вагоны нрст]]] as vag_m,
cast([[Measures]].[Вес нрст]]] as decimal( 10 ,  2 )) as tn_m,
into #a
from openrowset('MSOLAP.2','Provider=MSOLAP.2; Persist Security Info=True;User ID=sa;Data Source=localhost; Initial Catalog=KSARM;Client Cache Size=25;Auto Synch Period=10000' , 
'with member [Measures].id as '' [Станция погр].Properties("key")''
select {id,[Measures].[Вагоны нрст], [Measures].[Вес нрст], [Measures].[Вагоны], [Measures].[Вес_т], [Measures].[Вагоны сред], [Measures].[Вес сред],
[Measures].[План ваг], [Measures].[План тонн], [Measures].[Заказ ваг], [Measures].[Заказ тн]} on columns,
Filter([Станция погр].AllMembers, [Measures].[Вагоны нрст]>0) on rows
from [Погрузка]
where [Дата].[Все Даты].[2006].&[10].[19]') 

select
  1  as Tag,
 Null as Parent,
  nod as [Nod! 1 !nod],  
 null as [Region! 2 !region],
 null as [Station! 3 !station],
  null as [Station! 3 !vag_m!element],
 null as [Station! 3 !tn_m!element],
 from #a

union 
select
 2 ,
 1 ,
nod,
region,
null,null,null
from #a

union
select
 3 , 2 ,
nod, region,
station,vag_m,tn_m
from #a
order by  nod,[Region! 2 !region]
for xml explicit
drop table #a