With
member [Measures].[貸款余額] as '(ClosingPeriod([日期].[日],[日期].CurrentMember), [Measures].[I_余額])/10000',solve_order =1,format = '#,#0.00'

member [Measures].[公司貸款余額] as '([客戶分類].[所有 客戶分類].[企業客戶],[Measures].[貸款余額])',solve_order =1,format = '#,#0.00'
member [Measures].[個人消費貸款余額] as '([客戶分類].[所有 客戶分類].[個人客戶],[Measures].[貸款余額])',solve_order =1,format = '#,#0.00'
member [擔保方式].[合計] as '[擔保方式].[所有 擔保方式]',solve_order =1,format = '#,#0.00'

member [營業網點].[合計] as '[營業網點].&[0001]'

Select
{[營業網點].&[0001].children,[營業網點].[合計]} on rows,
crossjoin({[Measures].[貸款余額],[Measures].[公司貸款余額],[Measures].[個人消費貸款余額]},{[擔保方式].[所有 擔保方式].children,[擔保方式].[合計]}) on columns
From? [信貸財務信息分析]

Where ([日期].[所有 日期].[2005年].[4季度].[10月],[余額狀況].[所有 余額狀況].[余額不為0])


crossjoin函數里面是兩個set,可以顯示出set{公司貸款余額,個人消費貸款余額},{抵押,質押,保證,擔保合計}這兩個set和所有營業網點的三維數據出來.展現效果見相冊.