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

member [Measures].[公司貸款余額] as '([客戶分類].[所有 客戶分類].[企業(yè)客戶],[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 [營業(yè)網(wǎng)點].[合計] as '[營業(yè)網(wǎng)點].&[0001]'

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

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


crossjoin函數(shù)里面是兩個set,可以顯示出set{公司貸款余額,個人消費貸款余額},{抵押,質(zhì)押,保證,擔保合計}這兩個set和所有營業(yè)網(wǎng)點的三維數(shù)據(jù)出來.展現(xiàn)效果見相冊.